Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / January 2004

Tip: Looking for answers? Try searching our database.

color gridlines green yellow red

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BOBK - 24 Dec 2003 19:03 GMT
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 - 24 Dec 2003 19:57 GMT
Try borders instead.

> 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 - 24 Dec 2003 20:03 GMT
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

In article
<jemcgimpsey-554113.12571324122003@msnews.microsoft.com>,

> Try borders instead.
- 26 Dec 2003 14:30 GMT
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.
>-----Original Message-----
>Try borders instead.
[quoted text clipped - 4 lines]
>> changed. Thanks.
>.
- 26 Dec 2003 18:51 GMT
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

>-----Original Message-----
>Try borders instead.
[quoted text clipped - 4 lines]
>> changed. Thanks.
>.
Jean Ruch - 26 Dec 2003 22:40 GMT
> 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
- 31 Dec 2003 14:43 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. 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
- 31 Dec 2003 20:35 GMT
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]
>>
>>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.