ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I shade the space between two data series in Excel? (https://www.excelbanter.com/charts-charting-excel/18945-how-do-i-shade-space-between-two-data-series-excel.html)

spike5150

How do I shade the space between two data series in Excel?
 
I want to shade in between two data series on an xy scatter chart when they
cross over each other. Is this possible in Excel or are there any add on
graphics packages that would allow more flexibility with charts?

Andy Pope

Hi,

Have a look at this example.
http://www.andypope.info/ngs/ng21.htm

You can shade areas using additional data plotted as area or stacked
area charts.

Cheers
Andy

spike5150 wrote:
I want to shade in between two data series on an xy scatter chart when they
cross over each other. Is this possible in Excel or are there any add on
graphics packages that would allow more flexibility with charts?


--

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


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com