Format Axis

[Andy Cave]

I have a line chart which is pulling data from a different
sheet in my workbook.

The X axis is the date, formatted: Jan-XX, Feb-XX, etc.

The Y axis is dollar amounts formatted as 200000, 400000,
etc. - increasing by 200K at each interval. - this is
correct.

The X axis is defaulting to date the same date all the way
across, "Jan-00, Jan-00, Jan-00". So, I'm seeing Jan-00
12 times, where I would like to see each month of the year.

When I change the X axis to so that it reads each month,
as I'd like...

The scale on my Y axis changes to:

min = 0 (this is correct)

max = 1 (not correct)

Major Unit = .1 (not correct)

Minor Unit = .002 (not correct)

The desired values are:

min = 0

max = 1600000

major = 200000

minor = 40000

When I change the y axis to my desired values, my x axis
(the months) remain correct, but I LOSE my data lines.

Please help. Any suggestions would be extremely helpful.

Thank you.

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.]

Typically, this is a symptom that one (or more) of your chart points is
not interpreted by XL as data that is consistent with the other values
on that axis.

Check if what you think are dates are dates according to XL. If the
dates are in column A starting with A2, and if col. C is empty, in C2
enter =ISNUMBER(A2) and copy C2 down column C to cover all cells in
col. A. If any of the results are 'FALSE' you need to fix the corr.
dates in col. A.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office