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
> I still don't get it.
>
[quoted text clipped - 6 lines]
> 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
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-----
>> I still don't get it.
>>
[quoted text clipped - 59 lines]
>
>.
Jean Ruch - 31 Dec 2003 16:55 GMT
> 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 D1:D8
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
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!!
>-----Original Message-----
>> I knew I'd missed something on my problem. I have a bar
[quoted text clipped - 25 lines]
>
>.
Jon Peltier - 04 Jan 2004 02:07 GMT
Is it too late to suggest this link?
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______
> 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
[quoted text clipped - 45 lines]
>>
>>.