I have a chart that starts incrementing at 5,000. Is there a way to
truncate say between 0 - 25,000 (and perhaps show it as a broken bar
graph, like other graphing programs can do)? If not, is there at least
a way to make the increments larger?

Also, I am putting the value labels on the top of each bar. They are
extremely crowded and overlap each other, even when I make the font
tiny. Any suggestions?

Thanks!


--
thigley986
------------------------------------------------------------------------
thigley986's Profile: http://www.excelforum.com/member.php...o&userid=31967
View this thread: http://www.excelforum.com/showthread...hreadid=549944

Hi,

Broken axes is not a built-in feature but here are some examples of how
to produce the effect.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...tutorial/index...
http://www.andypope.info/charts/brokencolumn.htm

Does turning the labels thru 90 degrees help?

Cheers
Andy

thigley986 wrote:
I have a chart that starts incrementing at 5,000. Is there a way to
truncate say between 0 - 25,000 (and perhaps show it as a broken bar
graph, like other graphing programs can do)? If not, is there at least
a way to make the increments larger?

Also, I am putting the value labels on the top of each bar. They are
extremely crowded and overlap each other, even when I make the font
tiny. Any suggestions?

Thanks!



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info