|
| 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
January 31st, 2006, 08:27 PM
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
January 31st, 2006, 09:23 PM
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
|
| 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 |
Linear Mode
