If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I link timeline labels to a line chart? | hizzle | Charts and Charting | 1 | December 6th, 2005 09:36 AM |
Change chart colors at report run time | rogge | Setting Up & Running Reports | 1 | March 31st, 2005 01:37 PM |
Conditional Chartting | Os | Charts and Charting | 14 | October 16th, 2004 01:12 PM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |
How to create stacked line chart with some empty value? | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 06:35 PM |