Colour shade an area in an Excel graph!

[aiyer]

Hello all!

Am Arun and I work for Vtec corp.
Well, a quick qn.

I constructed a line between points (0,3) and (16,3) (above an
parallel to the X Axis). Is there a way I can colour-shade the regio
bounded by the above line and the X-axis? (the X- axis is 16 units lon
and has units marked till (16,0)).

I look forward to your help guys.

Thanks a bunch in advance.

Regds,
Arun

 

[Jon Peltier]

Hi Arun -

Take a look at this web page. I show how to make a combination XY-Area chart:

http://peltiertech.com/Excel/Charts/XYAreaChart.html

Alternatively, you can use this topic for such a simple shading pattern. Use only
one column series, with only one point, with a value of 3.

http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______