| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change color of point in series based on date
I have a line graph that covers Jan - Dec with 4 different series of data.
I'd like to change the color of either the line and/or the marker for each month and series depending on if the data for that month is "closed/final" or not. Is there a way to change the color based on the month and not the actual data? Thanks!! Cathy |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change color of point in series based on date
Jon tell how to do this at
http://peltiertech.com/Excel/Charts/...nalChart1.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Cow Girl" wrote in message ... I have a line graph that covers Jan - Dec with 4 different series of data. I'd like to change the color of either the line and/or the marker for each month and series depending on if the data for that month is "closed/final" or not. Is there a way to change the color based on the month and not the actual data? Thanks!! Cathy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the Point of a Series | Charts and Charting in Excel | |||
| How can change the color of the data series from one point onwards | Excel Discussion (Misc queries) | |||
| Change color of every third point | Charts and Charting in Excel | |||
| cell color change based on due date | New Users to Excel | |||
| Printing point on graph in different color based on pos or neg | Charts and Charting in Excel | |||
Linear Mode
