Y AXIS PROBLEM

  • Thread starter Thread starter Hennie Olivier
  • Start date Start date
H

Hennie Olivier

We have created various charts in Excel 2000 in which the
values in the y-axis were reflected in thousands (in other
words, a value of 9 million would be reflected as 90,000
in Excel 2000). Upon exporting these charts to our printer
(who used Excel 98 to open the charts)three extra zero's
were added to the values on the y-axis, so that the chart
values were actually displayed as 9,000,000 in Excel 98.
Howcome does this happen and how can this be avoided?
We could forward a typical graph to you if required.
Thanks
 
XL98 is a Mac version of XL. It might not support the scaling of the
axis values.

One way to do this is to scale the results yourself. Instead of
plotting 9,000,000, create a set of cells that convert the millions
into thousands with =<original-cell>/ 1000. Plot this new cell range,
and add a textbox to the chart that indicates that the numbers are in
thousands.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Hennie -

Did you just send the chart on a worksheet, without sending also the
linked data? By default, a chart axis takes on the number format of the
source data. If the source data is on a different workbook, and you
close the workbook, Excel defaults to the General format, which in your
case adds back the zeros. What you can do, when the original workbook
is open, is to double click on the axis, click on the number tab, and
uncheck the Linked to Source box. This saves the format in the chart.

- Jon
 
Back
Top