Change color of point in series based on date

C

Cow Girl

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change series or line color in excel 2007 vba 4
different color for 1 series 2
change color of curve line as time changes 2
How can i change chart data point format based on value? 3
Zero length string on chart 1
Data Series question 2
"pinning" a format to a data series 1
Variable series multi line chart? 1

Top