Charts based on Pivot Table



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😓


  • 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.


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.