We have an Excel 2003 front end workbook that draws data from a SQL 2005
"Cube" into a pivot table with an associated pivot chart.
The values on the line chart, as shown e.g. in data labels, are correct
against the pivot table, however in some cases the plotted points on the
chart are way out on the scale - a value of -168 is plotted somewhere between
-220 and -250 against the scale, and in other cases where negative values are
below the X axis, -3 is plotted below -5 although the scale is rising, i.e.
has 0 above -1.
We have tested lots of different scenarios and most of them are fine with
correct plotting but just a few of them are incorrect.
Can anyone help please?
Thanks