Hi,

2003 and earlier has no way to format the axis to more than 1 color. You
can buy 2007 it lets you use gradient fill on the axis, but it is a gradient
not a solid color all the way to the half way point.

I suppose you can draw two lines using the line tool and format each to a
different colors then line them up over the axis.

You can check Jon Poltier's site but I doubt he has a solution.

--
Thanks,
Shane Devenshire


"Mr. Platypus" wrote:

Thank you much. Unfortunately, that is not going to work. Adding dummy data
will not be advisable as the chart is continually having data added to it.

It don't want to have to update a dummy data set every time.

"ShaneDevenshire" wrote:

Hi,

Yes/No - not the axis in 2003, but suppose your lowest value is 0, that is
the x-axis crosses the y-axis at zero. Add two new series to your data set
all of the values of which will be 0. See below. Add these two series to
the chart, turn their markers off and change their colors as you need.
Remove them from the Legend

Data Dummy X1 Dummy X2
12 0
31 0
21 0
54 0 0
34 0
54 0
61 0

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Mr. Platypus" wrote:

I have a cash projection spreadsheet with a linked line chart. In the
projection sheet, the font goes from black to green when the data goes from
actual to projected.

Is there a way to make the line or the x-axis change colors at the point
that the date does so (i.e., have the line turn green halfway through the
chart)?

Thank you in advance.