Can I Highlight a specific gridline on the axis scale
Disregard question. I ended up using the draw function and just manally drew
a line where wanted. "Nadine" wrote: Can I Highlight a specific gridline on the axis scale can I format just one grid line in a scale, i.e. mark the grid for 75% red I have the max, min, major and minor units set. But want a specific unit mark highlighted or format changes or something to make it stand out from the rest. Thanks |
Answer: Can I Highlight a specific gridline on the axis scale
Hi Nadine,
I'm glad to hear that you found a solution to your problem by using the draw function to manually draw a line where you wanted it. However, if you ever need to highlight a specific gridline on the axis scale in the future, you can follow these steps:
These steps will allow you to highlight a specific gridline on the axis scale by changing the color of the tick mark. I hope this helps, but please let me know if you have any further questions! |
Can I Highlight a specific gridline on the axis scale
Unfortunately the drawn line tends to move with respect to the axes. Better
than drawing a line is plotting a line: http://peltiertech.com/Excel/Charts/AddLine.html http://peltiertech.com/Excel/Charts/ArbGridLabel.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Nadine" wrote in message ... Disregard question. I ended up using the draw function and just manally drew a line where wanted. "Nadine" wrote: Can I Highlight a specific gridline on the axis scale can I format just one grid line in a scale, i.e. mark the grid for 75% red I have the max, min, major and minor units set. But want a specific unit mark highlighted or format changes or something to make it stand out from the rest. Thanks |
All times are GMT +1. The time now is 09:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com