PDA

View Full Version : Chart source data depends on the sheets choosen on the Combo box



annemarie
08-18-2009, 01:34 AM
Hi there again!
I have questions about the use of combo box. Is possible to link the combo box to a chart?
For example: the list on my combo box are work sheet names, when I choose a work sheet a chart will be made from the data on that chosen work sheet.
and the graph should be made on a summary sheet, which also contains the combo box, say below the combo box with the sheet name.

Is this possible?how will i do it?

thanks in advance!

annemarie:help

mdmackillop
08-18-2009, 03:32 AM
Record a macro to create and place the chart where you require it.
Change the hard coded names to variables.
Create an Event macro that will pass the required sheet name to the recorded macro.

If you get stuck, please post the recorded code.