View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_8_] Jon Peltier[_8_] is offline
external usenet poster
 
Posts: 70
Default 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.