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.

On Oct 23, 8:39*am, 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.

Wow. You and I asked the same question in two different ways. I hope
one of us gets an answer.

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.

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.

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.

Hi,

There is no reason the dummy data has to be static.
You only need a few bits of information to draw 2 lines.
If you plot 1 additional data series as an xy-scatter with 2 points you
only need the start and finish x value to change. Y values would be zero
or whatever value your x axis crosses the Y.
These 2 values can be determined by formula. The formula can either be
stored in a couple of cells or named ranges if you do not want to use
the worksheet.

Cheers
Andy

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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info