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

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:

1. Select the chart that you want to modify.
2. Right-click on the axis that you want to modify and select "Format Axis" from the drop-down menu.
3. In the Format Axis pane that appears on the right-hand side of the screen, click on the "Axis Options" tab.
4. Under "Axis Options", scroll down to the "Axis Position" section and select "On Tick Marks" from the drop-down menu.
5. Scroll down to the "Tick Marks" section and select "Inside" or "Outside" from the drop-down menu to specify where you want the tick marks to appear.
6. Scroll down to the "Major Tick Mark Type" section and select "Cross" from the drop-down menu to specify the type of tick mark that you want to use.
7. Scroll down to the "Major Tick Mark Color" section and select the color that you want to use for the tick mark.

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!

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