Different colors on a single line chart

S

Sarah

Hi there
I have a single line chart, with dates on the X axis. After a certain date,
I would like the line to be a different color. Is this possible? Without
having to edit the color of each datapoint? And when I add new data, it
should appear in that same second color. Thanks!
 
A

Andy Pope

Hi,

To do this without code you can use 2 data series to give the appearance
of a single line.
In this previous example I posted the future data was a dotted line but
you can just change the formatting to another colour.
http://www.andypope.info/ngs/ng45.htm

Cheers
Andy
 

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

Top