Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Macros
Resolved · Low Priority · Version Standard
Christine has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Can I create a macro to enable me to select from a drop-down list to change the data displayed in a graph depending on the criteria selected e.g. to display data for Croydon, London, England and Wales?
Hi Christine
Thanks for your question.
This sounds like the sort of thing you could do with a PivotChart. You would need to create a PivotTable from your data first, then you can create a PivotChart directly from the PivotTable by using the PivotChart button on the PivotTable toolbar.
I hope this helps.
Amanda
|
Excel tip:Removing border lines on the keyboardHighlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines. |
We'll call during UK business hours
Server loaded in 0.1 secs.