My pivot chart has the wrong Y axis values but correct data point values

Question

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values.

The values on resulting lines are correct (see the data label at the end of the line) but the Y axis is off by about 100, but not off by any consistent amount. I have played with auto axis on and off, turn log scale on and off. All to no avail.

Does anyone have any thoughts?

Solution

You are using a Stacked Line chart. This causes your data points to accumulate amongst all the series of data. So, your purple line which should have the value of $53 is actually being reflected as a $53 delta on top of ($43 (green) + $30 (red) + $19 (blue)). If you change the chart type to Line, it will fix this.

Comments

[phoebus]

A pivot chart is a chart tied to a pivot table, which is a particular object in Excel (and other spreadsheets) that allows easy on-the-fly switching of variables among different axes, handy auto-aggregations, etc. en.wikipedia.org/wiki/Pivot_table

[quack quixote]

comment from Mark Harnett: Stacked line it was. Thanks.

[Todd Pierzina]

Thank you, I'd made the same mistake and was going crazy.