pivot charts

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

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

Pivot Charts

resolvedResolved · Medium Priority · Version 365

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!

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.


 

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips


Server loaded in 0.05 secs.