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.