Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Different colors on a single line chart
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Different colors on a single line chart
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 Sarah wrote: 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! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Changing Line in line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |