Charts based on Pivot Table

Hana Hozakova
ββ
Hello,
I have a Pivot table. However, this always contains a Total column. I want to use this table as a source to create a chart. But I don't want to have the total column displayed in the graph. I didn't figure out how to remove it from the chart. It distorts the visualization.
Is it going somehow?
Thank you
Hana Hozakovaπ
Answers
-
Hi Hana,
In the chart creation window select edit data and select the area of the pivot with the data you want to display. Don't include the totals.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.7K Get Help
- 474 Global Discussions
- 202 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives