ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Formatting (https://www.excelbanter.com/charts-charting-excel/62855-formatting.html)

Dan deGrassi

Formatting
 
How do I highlight (e.g., bold) just 1 particular y-axis gridline? I want to
make it stand out as a threshold.

Andy Pope

Formatting
 
Hi,

You can not format individual grid lines.
You can add a dummy series to act like a grid line and format that as
required.

Jon Peltier has an explanation for creating arbitrary grid lines that
you can adapt.
http://peltiertech.com/Excel/Charts/...Gridlines.html

Or here are some explanations of adding lines to charts.
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Dan deGrassi wrote:
How do I highlight (e.g., bold) just 1 particular y-axis gridline? I want to
make it stand out as a threshold.


--

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


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

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