ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line Graphic with Area (https://www.excelbanter.com/charts-charting-excel/92844-line-graphic-area.html)

Pedro Serra

Line Graphic with Area
 
How can I built a line graphic (one serie only) that as under the line a
coloured area without hiding the X and Y gridlines?


Andy Pope

Line Graphic with Area
 
Hi,

As you are aware the trick of using an area chart to colour below the
line will obscure the gridlines. Therefore you will have to create your
own gridlines using more dummy series. See Jon Peltier's explanation.
http://peltiertech.com/Excel/Charts/...Gridlines.html

Cheers
Andy

Pedro Serra wrote:
How can I built a line graphic (one serie only) that as under the line a
coloured area without hiding the X and Y gridlines?


--

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


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

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