| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can change the color of the data series from one point onwards
The easiest way is to plot them as two series:
Actual Projected 01/01/07 xxxx 01/02/07 xxxx 01/03/07 xxxx etc 01/24/07 xxxx 01/25/07 xxxx 01/26/07 xxxx 01/27/07 xxxx Leave all the blanks in place and include them in the chart's source data, so the series will line up. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Saran" wrote in message ... I am currently using the line chart to project the # of bugs on a daily basis which go e.g. from 1 Jan to 31 Jan. I however want to show the Bugs from 1 Jan to 24 Jan (today) in one color and the remainder of the series in a different color as this would allow me to easily segregate the actual vs the projected. Any help is appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To: Easy Box Plot | Charts and Charting in Excel | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
