Shading on a scatter graph
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 |
Shading on a scatter graph
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 |
All times are GMT +1. The time now is 06:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com