color gridlines green yellow red

[BOBK]

A simple 0 to 100% in chunks of 10. I want the gridline at
70% to be yellow and the gridline at 90% to be red. Every
time I select to alter gridline, I get ALL grdlines
changed. Thanks.

 

[J.E. McGimpsey]

Try borders instead.

 

[J.E. McGimpsey]

Oops -meant Lines. And hit send too fast

Jon Peltier also has a way of spoofing individual gridlines.

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

 

[Guest]

I been poking with DRAWING and OBJECT borders, but
clicking on Line style doesn't let me select any of the
choices (the box is ghosted--non-selectable).
Here's what I do.. Fill A cells with a b c d e.
Fill B cells with 1 2 3 4 5.
Reset axis to 10. OK.. how to change the 7 gridline to
yellow and the 9 gridline to red. Thanks.

 

[Guest]

I still don't get it.

Here's setup..
Col A A1 to A5... a b c d e
Col B B1 to B5... 1 2 3 4 5
Now I expand the axis to 10

NOW HOW TO TURN GRIDLINE 7 TO YELLOW, and GRIDLINE 9 TO
RED?
Thanks

 

[Jean Ruch]

I still don't get it.

Here's setup..
Col A A1 to A5... a b c d e
Col B B1 to B5... 1 2 3 4 5
Now I expand the axis to 10

NOW HOW TO TURN GRIDLINE 7 TO YELLOW, and GRIDLINE 9 TO
RED?
Thanks

Hi BOB,



With the values you indicate, I presume your efforts concerned a Line
Diagram

My suggestion here is to use an x-y Diagram, arranging your Data as
follows



A2..A6 = a, b, c, d, e

B1..B7 = 0, 1, 2, 3, 4, 5, 10 ( 10 as your max y-Scale )

C1..C7 = 0, 0, 0, 0, 0, 0, 0

D2..D6 = 1, 2, 3, 4, 5

E1..E7 = 0,7 * B$7 (= 70% max y-Scale)

F1..F7 = 0,9 * B$7 ( = 90% max y-Scale)



Make your Diagram on the base of the Range A1 : F7

Colour the lines 70% / 90% in yellow / red without markers

Line Style thick or medium, so they remain visible when you

add the Grid-Lines.

Take 0 and 10 as well for x-min and x-max values

To arrange the x-Axis as in a Line Diagram, Use an Add-in like

Chart Labeler (www.appspro.com) or

JWalk Chart Tools ( http://j-walk.com/ss)

Apply the labels A1.A7 to the dummy-values of column C

The original Scaling of the x-Axis is to be made white + not visible

Possibly, you have to format / move the labels so to achieve the

same "look" as for a Line Diagram.

I hope I didn't misunderstand you, unless you perhaps could make use

of only some elements of such a procedure.



kind regards
Jean

 

[Guest]

I knew I'd missed something on my problem. I have a bar
chart of percentages that go to 100 % at 10% increments.
I'd just like a left to right line at 70% to be yellow and
a l-to-r line at 90% to be red. It sounds simple but is it
the bar charting that has no special facility to put the
line across? Thanks. On a line graph, I can cheat by
filling COL C cells with all 70 and COL D cells with all
90 and then I get control of coloring and widening the
lines. >-----Original Message-----

 

[Jean Ruch]

I knew I'd missed something on my problem. I have a bar
chart of percentages that go to 100 % at 10% increments.
I'd just like a left to right line at 70% to be yellow and
a l-to-r line at 90% to be red. It sounds simple but is it
the bar charting that has no special facility to put the
line across? Thanks.

Hello BOB

Try the following:

Let's suppose you have your category names in Column A, from A1:A8,
your y-values in column B ( B1:B8)
Let column C be void
in Column D you put 0,7 in the range D18
in column E you put 0,9 in the range E1:E8

Select the whole ( A1: E8 ) and call the Diagram assistent
Choose customized types / Columns + line

and you should get what you want.
Format as you like....

A happy new year ! from

Jean

 

[Guest]

Thanks so much for the help. I just had to tweek all my D
cells to 70.00 and all the E cells to 90.00 and then I got
the bars and 2 lines that I could change color on. My bars
showed their proper values and the other 2 color lines
were left to right limiters. PERFECT!!

 

[Jon Peltier]

Is it too late to suggest this link?
http://peltiertech.com/Excel/Charts/AddLine.html

- Jon