My pivot chart has the wrong Y axis values but correct data point values
- by Mark Harnett
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 anybody have any thoughts?
Image link