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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/newsgroups/broken_y_axis/tutorial/index.ht
ml
 
Back
Top