98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Charts
Pivot Charts
Resolved · Medium Priority · Version 365
Fri 24 Feb 2023, 16:10Delegate 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:01Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Screen Splitters in ExcelScreen 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. |
