Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 216
Default 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

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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:
  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!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom gridline - one single gridline at a specific value Barry Guidry Charts and Charting in Excel 3 September 14th 07 07:04 PM
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 09:03 AM
Color of a specific gridline Ccwm27 Charts and Charting in Excel 1 June 20th 06 09:37 PM
Radar Chart - How to include X axis gridline Michelle Charts and Charting in Excel 1 December 7th 05 10:30 AM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"