ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Is it possible to format *individual* gridlines? (https://www.excelbanter.com/charts-charting-excel/75156-possible-format-%2Aindividual%2A-gridlines.html)

newaglish

Is it possible to format *individual* gridlines?
 
I would like to make the 0 line (X-axis) bold, to emphasise when my graphed
line drops below zero, but it seems as though I can only format all of the
gridlines together.

Is it possible to format a single gridline alone?

Andy Pope

Is it possible to format *individual* gridlines?
 
Hi,

No you can not format individual gridlines.
To get the effect you can use a dummy series and format that.
See here for more information.

http://peltiertech.com/Excel/Charts/AddLine.html

Cheers
Andy

newaglish wrote:
I would like to make the 0 line (X-axis) bold, to emphasise when my graphed
line drops below zero, but it seems as though I can only format all of the
gridlines together.

Is it possible to format a single gridline alone?


--

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


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

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