Changing the colour of individual gridlines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt T - 21 Nov 2003 12:15 GMT

Hi,
I am putting together a bar chart and thought it would be a nice touc
to change the colour of the gridlines to represent threshold markings
ie. 10 - 50 = green ; 60 - 80 = Amber ; 80 and above would be red.
Is there any way I can individually colour the horizontal gridlines a
the only option I have at the moment is to colour all the same.

thank

Reply to this Message

Debra Dalgleish - 21 Nov 2003 12:32 GMT

Jon Peltier has instructions for conditional charts:

http://www.geocities.com/jonpeltier/Excel/Charts/format.html#CondChart

> Hi,
> I am putting together a bar chart and thought it would be a nice touch
> to change the colour of the gridlines to represent threshold markings.
> ie. 10 - 50 = green ; 60 - 80 = Amber ; 80 and above would be red.
> Is there any way I can individually colour the horizontal gridlines as
> the only option I have at the moment is to colour all the same.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Jon Peltier - 21 Nov 2003 18:17 GMT

To create individually formatted gridlines, check out this page:

http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#ArbGrid

which uses error bars on a dummy series to provide the actual gridlines.
Skip the use of crosses as points and data labels for axis labels if
these are satisfactory in the original chart. You need a different
dummy series for each differently formatted set of gridlines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> Jon Peltier has instructions for conditional charts:
>
[quoted text clipped - 6 lines]
>> there any way I can individually colour the horizontal gridlines as
>> the only option I have at the moment is to colour all the same.

Reply to this Message