Exponential numbers viewing wrong on chart

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I am currently using Excel 2000 on a windows 2000 system.
I have a chart created with almost 10,000 plots on an X,Y
scatter chart. I have exponent numeric values for the X
axis on my data sheet. When I create the chart my exponent
values start at 0.00E+00 instead of -6.36E-07 where the
first values should start. The values end at 1.00E+04 and
should end at 1.36E-06. I've done this many times before
without issue, can anyone think what I may be doing wrong
this time?
TIA
George
 
Hi George
You can specify the start and end values by right clicking the axis, open
Format Axis, go to Scale tab and set Max and Min values to taste.
Best wishes
 
Are you sure you have a XY Scatter chart and did not accidentally create
a Line chart? 1E4 is the number of data points you have. ;-)

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 doesn’t show Y-axis values when the values are small. 2
Chart size relative to contents 1
time scale proportional using a column chart - not just for scatte 4
Swapping X and Y Axis - line Chart 3
charting variable length line data 1
Odd chart type needed 2
How do I adjust marker spacing in Excel scatter plot? 1
Scattered chart combined with columns and time-x-axis in XL2007 4

Back
Top