Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
advanced excel training - macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Macros

advanced excel training - Macros

ResolvedVersion Standard

Christine has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Macros

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?

RE: Macros

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

TrustPilot
TrustScore 4.9 / 5       2447 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.17 secs.