-
Chart source data depends on the sheets choosen on the Combo box
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
-
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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules