Excel line graph with colored ranges (Red/Yellow/Green)

[mykeee]

I am trying to create a chart in Excel 2003. What I want to do is track my performance over a year in %. In the chart I would like to see color ranges that show which category I am in. From 0-85% should be red. From 86-92% should be yellow. From 93-100% should be green. Any ideas on how I can make the background of my chart these colors at these values? I'm not sure I explained myself well.

 

[sheetspread]

Conditional Formatting of Excel Charts - Peltier Tech Blog colors the lines or bars

Are you trying to fill the area below each range a certain color?

 

[mykeee]

Yes, I would like to fill the area below 85 red, between 85 and 92 yellow, and above 92 to 100 green.

Something like this:

-- removed inline image ---

 

[mykeee]

http://peltiertech.com/images/2011-09/HBand_Finished.png

 

[sheetspread]

It sounds like you really want:

Fill Under or Between Series in an Excel XY Chart - Peltier Tech Blog


"Fill Under One XY Series"


No?

 

[mykeee]

No, what I am trying to do is track our company's score. We get rated (%) by one of our customers each month. Depending on the score, it puts us in one of 3 categories. Red, Yellow or Green. Any score below 85% is Red. 86-92% is Yellow, and higher than 92% is Green. I would like to see over the coarse of the year how our score rises and dips through these 3 ranges.

 

[sheetspread]

Ok so the H-Band method it is:

Excel Charts With Horizontal Bands - Peltier Tech Blog

the link is pretty descriptive but if you want a hand just post some data and I'll try to work it through

 

[mykeee]

Is there some way to attach the spreadsheet to this post so you could have a look at it?

 

[mykeee]

I have posted the spreadsheet to Dropbox. I have attempted to follow the instructions from the site you linked to, but something went wrong.

https://www.dropbox.com/s/c9w0tace3bzk5wm/Test.xls

 

[sheetspread]

This board doesn't accept files and charts won't appear on the screen attachment (you'd have to save it to a file host but then the source data can't be copied off the screen directly). I'll send you my email.