ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-05-2005, 03:06 PM
Nelson
Guest
 
Posts: n/a
Grid Lines

Is there any way to change the color of a single gridline in a bar chart? I
have a presentation with a threshold and would like to make that gridline
Red. Showing that anything above is and anything below is bad.

Thanks in Advance,

Nelson
Reply With Quote
  #2  
Old 05-05-2005, 04:06 PM
John Mansfield
Guest
 
Posts: n/a
RE: Grid Lines

Nelson,

You can't change the color of a single gridline. However, you can add a
dummy series that acts like a gridline. You can then change the color of the
dummy series.

For an example, please see Jon's site:

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

Change the line to dotted to give the appearance of a gridline.

----------------------------
Regards,
John Mansfield
http://www.pdbook.com


"Nelson" wrote:

> Is there any way to change the color of a single gridline in a bar chart? I
> have a presentation with a threshold and would like to make that gridline
> Red. Showing that anything above is and anything below is bad.
>
> Thanks in Advance,
>
> Nelson

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 11:28 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0