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😓

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