AnswerBun.com

Dynamically change charts from a drop down with a changeable data range

Super User Asked by Mirza on August 17, 2020

I will be straight to the point, aassuming you got a set of some measured data, and there in a Column A you got a product name, in Column B number of tests you did (always different) and third Column C are the results.

I wanted to make a dynamic chart where everytime I change my product name (column A), I will be getting exactly the results and test numbers for a given product. Sometimes there will be 5 tests, sometimes 25, always differing, depending on a product.

My idea was dynamic named ranges for all the columns, and then connecting via drop downs. Maybe this job will be a bit tedious because of amount of data, or is there another way?

My data is looking exactly like this, so no TABLE format and with this "average" yellow row.

Data set

Add your own answers!

Related Questions

Can Brightness of Windows changed per App?

1  Asked on December 15, 2020 by akam

   

What is Special Permissions?

2  Asked on December 15, 2020 by old-geezer

         

How do I hide/mask my IP address from my home network?

1  Asked on December 15, 2020 by zoesmum

 

Explorer.exe making outbound TCP connection to Akamai

1  Asked on December 14, 2020 by john-hammond

         

Dell Inspiron E6430 bluetooth “skipping”

0  Asked on December 13, 2020 by steven-carline

       

Copy files except when destination modified in last x days

1  Asked on December 13, 2020 by mark-schultz

         

Problems installing and opening packages on Linux Lite

0  Asked on December 13, 2020 by jorgeserrano

 

What is “push route” used for in OpenVPN?

1  Asked on December 12, 2020 by dark_st0rm

       

xfreerdp ignores resolution parameter

2  Asked on December 12, 2020 by vitas

       

How to config the keystore of Nginx mutual SSL?

1  Asked on December 11, 2020 by jimmy-chu

     

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP