Using Listbox to select multiple series for chart dynamically

Hi everyone,

I'm trying to see if it's possible to (without VBA) have a chart that the series (minimum of 2) can be selected from a drop down List in an excel sheet. In other words, a chart that's driven by dynamic data with an option to choose the series to display in the chart (I'm not allowed to use Powerviews unfortunately)
Thanks

Try this approach with a helper column

See the file

Hi José, thanks but not quite what I'm after.. I'm looking at to a certain degree mimicking the slicer feature in excel on a pretty standard Excel chart i.e. To be able to select more than one series to display from a list and have the chart dynamically respond to the selection

Have you try a dynamic chart?

See the file

Thanks again! I tried the above option before posting but couldn't figure out how to get Excel to just list the field in the VALUES area (not to sum up the values), it currently provides the option to either Sum, Count, Average etc...

Can you send a sample file of your problem?

Sure.. In the attached file, the charts tab shows two series.. I'm trying to see if I can have a simple dropdown that enables me to select any of the series on the data sheet and have the chart update dynamically

See if the dynamic chart I propose solve your problem.

Hi Jose,

Many many thanks, I've just downloaded your dynamic chart, (still going through it) it's not exactly what I was after but definitely something I can use!

obrigado!!