I'm trying to shade an area on my scatter graph and it's all going very
wrong!

There is a diagonal line on this chart and I simply want to shade in
the area beneath it. But when I change it to an Area Chart it goes all
pear shaped...

Can you help!!!??


+-------------------------------------------------------------------+
|Filename: excel.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4991 |
+-------------------------------------------------------------------+

--
strobinson1
------------------------------------------------------------------------
strobinson1's Profile: http://www.excelforum.com/member.php...o&userid=36124
View this thread: http://www.excelforum.com/showthread...hreadid=558981

Hi,

Do the following to the Chart
- change line series to Area chart
- format area series to use secondary axis
- via Chart Options enable secondary X axis as Time Series
- format secondary X axis Min=40 Max=160 (don't worry about dates just
enter the values). Remove ticklabels and marks.
- format secondary Y axis Min=40 Max=160. Uncheck Category(X) crosses at
Maximum
- format primary X axis Min=40 Max=160
- format area series as required

Cheers
Andy


strobinson1 wrote:
I'm trying to shade an area on my scatter graph and it's all going very
wrong!

There is a diagonal line on this chart and I simply want to shade in
the area beneath it. But when I change it to an Area Chart it goes all
pear shaped...

Can you help!!!??


+-------------------------------------------------------------------+
|Filename: excel.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4991 |
+-------------------------------------------------------------------+


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info