Drop down list for graphs/charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My boss wants a drop down box in Excel that will give us about ten different
graphs. I did all ten of these graphs individually on separate tabs but my
boss wants one tab with a drop down box that when we choose one of the
groups, it will give us that graph.

Can this be done?
 
Based on the drop-down, in a separate range select the data which you want
to plot. And plot this in one graph only. For e.g. you have data A1:A10 for
the first graph, B1:B10 for the second. Lets say in M1:M10 use a formula
which will get the data from A1:A10 or B1:B10 based on the drop-down
selection. Plot M1:M10 only in the graph.



Mangesh
 
Back
Top