advanced excel training - Macros

Resolved · Low Priority · Version Standard

Fri 9 Feb 2007, 09:47 Delegate Christine said...

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?

Mon 12 Feb 2007, 12:00 Trainer Amanda said...

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:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips

advanced excel training - Macros

Macros

RE: Macros

Excel articles

Excel tip:

Removing border lines on the keyboard