Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Charts

Pivot Charts

ResolvedVersion 365

Fri 24 Feb 2023, 16:10 Delegate Catherine said...

Catherine has attended:
Excel Advanced course

Pivot Charts

Is there a way of creating a dynamic chart from a pivot table where I can click on different buttons that take me to different versions of a chart, each using a different metric? Thank you!

Mon 27 Feb 2023, 13:01 Trainer Martin said...

RE: Pivot Charts

Hello Catherine,

Welcome to STL's support forum and thank you for your question.

You can create pivot charts that show different metrics based on button selection by using something called Form Controls in Excel.

For a demo on how to use Radio buttons (a type of form control) to help you interact with a Chart/Pivot Chart, click on the link below:

https://www.youtube.com/watch?v=oSTgFUiRDGI

Hope this helps you get started

Kind regards
Martin

Mon 6 Mar 2023: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Pivot Charts

Pivot Charts

RE: Pivot Charts

Excel articles

Excel tip:

Turn Function tooltips on and off