Colour shade an area in an Excel graph!
 

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

--
aiye
-----------------------------------------------------------------------
aiyer's Profile: http://www.excelforum.com/member.php...nfo&userid=607
View this thread: http://www.excelforum.com/showthread.php?threadid=26404

Colour shade an area in an Excel graph!
 

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/...ackground.html

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

aiyer wrote:

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 and
parallel to the X Axis). Is there a way I can colour-shade the region
bounded by the above line and the X-axis? (the X- axis is 16 units long
and has units marked till (16,0)).

I look forward to your help guys.

Thanks a bunch in advance.

Regds,
Arun.