How do I increase the y axis in a bar graph?

I want to add more lines to my y axis without making the highest value of my
bar graph touch the top of the y axis. For example, I want the highest value
in my bar graph to have a value of 60, but I want the y axis to go up to 100.
How do I do that? Thanks.

I fake it.

For example, I make the actual axis go to 70, and then I either ungroup the
graph and change the 70 to 100, or I leave the graph "grouped," and I place
a filled autoshape over the 100 and then a non-filled textbox with 70 on top
of that. I do this so that I can set the filled autoshape to "white" in
Black and White View, which allows everything to print properly in B/W.
Using a filled textbox prints with lines around the textbox in B/W.

Then I draw a couple of little lines to "break" the axis. (Actually, I draw
one and then duplicate and place it....)

Or see this technique from Excel MVP Tushar Mehta:
http://www.tushar-mehta.com/excel/ne...orial/index.ht
ml

--
Echo [MS PPT MVP]
http://www.echosvoice.com


"Silviawood72" wrote in message
...
I want to add more lines to my y axis without making the highest value of
my
bar graph touch the top of the y axis. For example, I want the highest
value
in my bar graph to have a value of 60, but I want the y axis to go up to
100.
How do I do that? Thanks.