emphasize one value axis

[deb]

How do I emphasize one axis value by making that gridline
darker than the others:
example:
160,000__________________(gridline)
150,000__________________(gridline only want thicker)
140,000__________________(gridline)

 

[dvt]

How do I emphasize one axis value by making that gridline
darker than the others:
example:
160,000__________________(gridline)
150,000__________________(gridline only want thicker)
140,000__________________(gridline)

Is it possible to make the 150,000 gridline a "major" and the other two
"minor" gridlines? Then you could use a thicker line for the major
gridlines.

If not, you'll probably need to create your own gridlines using a dummy
series. Jon Peltier has directions that you can adapt to your needs at
http://www.geocities.com/jonpeltier/Excel/Charts/ArbitraryGridlines.html.

Dave
dvt at psu dot edu

 

[deb]

I tried the major gridline idea but then it changes the
incremental amounts. I then went to this web site but it
seems to be beyond my understanding.

 

[dvt]

How do I emphasize one axis value by making that gridline

I tried the major gridline idea but then it changes the
incremental amounts.

We might need a little more detail. What are the minimum and maximum values
for that axis? Exactly where do you want all of the darker gridlines?
Where do you want all of the lighter gridlines? Let me try to throw out an
example with some guesses at the answer to those questions.

Your axis has a minimum of 130k and a maximum of 170k. You need gridlines
at every 10k (140k, 150k, and 160k). You want a thick line at 150k and thin
lines at 140k and 160k.

Select the axis by clicking on it. On the menu, click Format | Selected
Axis | Scale tab. Set minimum to 130k, maximum to 170k, major unit to 20k,
and minor unit to 10k. Click OK.

Now select the chart and go to Chart | Chart options | Gridlines tab. Make
sure that the axis you are woking with has boxes checked for both minor and
major gridlines. Click OK.

Now click on the gridline at 150k. Go to Format | Selected gridlines |
Patterns tab. Set the line type as you wish. Click OK and repeat this
sequence after you have selected the gridline at 140k.

Dave
dvt at psu dot edu

 

[deb]

I copied it to work and drew a black line across the value

 

[dvt]

I copied it to [Word] and drew a black line across the value

That works. You should be able to draw a line in Excel, too. View |
Toolbars | Drawing, then select the line tool and draw just like in Word.

Dave