PDA

View Full Version : [SOLVED] Change Data for Chart via dropdown



Hoopsah
01-15-2009, 04:34 AM
Hi

If I have a chart based on regional figures, is there an option within excel that will allow me to incorporate a drop down Combo Box that if the user selects just one area only that area will be displayed on the graph.

One of the options would have to be All that would then show all data.

Kenneth Hobs
01-15-2009, 09:15 AM
See http://www.mrexcel.com/forum/showthread.php?t=354580

Hoopsah
01-16-2009, 02:41 AM
Fantastic!

Thanks for that Ken

Hoopsah