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 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP