Excel Chart Question

[Keith Johnston]

Hello,

I am working on a chart and was wondering if it is possible:

1. To change the color of the chart's background, only above a certain value? (i.e. above the value 100 on the Y-Axis, the background would be red, while below 100 it would still be gray).


or


2. To change the color of just one of the gridlines at a certain value on a line chart. (i.e. the gridline at the value 100 on the Y-Axis is red, while all of the other gridlines are still black).


Thanks for any help!
Keith

 

[eliW]

Hello Keith,

You can find few ideas in the following site:

http://peltiertech.com/Excel/Charts/format.html#CondChart

HTH

Eli

 

[Jon Peltier]

I am working on a chart and was wondering if it is possible:

1. To change the color of the chart's background, only above a certain value? (i.e. above the value 100 on the Y-Axis, the background would be red, while below 100 it would still be gray).

Some links:
http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html
http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

2. To change the color of just one of the gridlines at a certain value on a line chart. (i.e. the gridline at the value 100 on the Y-Axis is red, while all of the other gridlines are still black).

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html
http://peltiertech.com/Excel/Charts/AddLine.html

 

[Jon Peltier]

I am working on a chart and was wondering if it is possible:

1. To change the color of the chart's background, only above a certain value? (i.e. above the value 100 on the Y-Axis, the background would be red, while below 100 it would still be gray).

Some links:
http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html
http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

2. To change the color of just one of the gridlines at a certain value on a line chart. (i.e. the gridline at the value 100 on the Y-Axis is red, while all of the other gridlines are still black).

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html
http://peltiertech.com/Excel/Charts/AddLine.html