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

Dynamic series in rows 1
Need help modifying code 0
Overlay line graph points on bar graph 1
Automation of scanned file storage based on content 0
change color of curve line as time changes 2
change series or line color in excel 2007 vba 3
How can i change chart data point format based on value? 3
"pinning" a format to a data series 1

Top