Excel 2007 Conditional Format a Line Graph

[JDubs84]

Hi All,

I have an Excel 2007 Line Graph. I want the line to change color depending on certain thresholds. The line values are percentages and want to conditional format similiar to how I format cells. 95% or greater is Green, 90-95% Yellow and below 90% Red.

Is this possible in 2007 excel?

Thanks
Jared

 

[SkipVought]

You do this on your source data. Lets assumes that your data is in columns. In adjacent columns you have formulas for each percentage. When the data meets that criteria, it displays in that column. Each column is a separate series, with it's color.

VOLA!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

Yes it can be done.

You need to create three new series. Assuming your values are in column B, then the first new series can be obtained by:
=IF(B2>=0.95, B2,NA())
2nd series by:
=IF(B2<0.95,if(B2>=0.90,B2,NA()),NA())
and third series by:
=IF(B2<0.90,B2,NA())

Plot all three series as line graphs. Format series one [green]green,[/green] series two [yellow]yellow[/yellow] and series three [red]red[/red]

Canadian eh! Check out the new social forum Tek-Tips in Canada.
I thought I had retired...I was mistaken. I used to work for a large corporation; now I work for my wife.

 

[JDubs84]

Thanks guys!

Finally figure it out late Friday. I was able to use one column with all values to create a faint gray line. Then used the other three series to plot the points in the correct colors and no line so it looked like they followed along the gray line.

 

[SkipVought]

Just eliminate the thin grey line, if you think you can. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}