Charts based on Pivot Table

Hana Hozakova
Hana Hozakova ✭✭
edited 06/14/22 in Add Ons and Integrations

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

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    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.