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

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 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.

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