PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting I need help shrinking a large difference in data on a bar graph

Reply

I need help shrinking a large difference in data on a bar graph

 
Thread Tools Rate Thread
Old 30-09-2004, 04:51 AM   #1
=?Utf-8?B?S3lsZQ==?=
Guest
 
Posts: n/a
Default I need help shrinking a large difference in data on a bar graph


I have one data of 720% and the next largest in 140%. How can I hide on the
bar graph gridlines 200-600? I can't find any help on it anywhere.
  Reply With Quote
Old 30-09-2004, 01:35 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: I need help shrinking a large difference in data on a bar graph

Kyle -

I explain one technique on this web page, and at the end I link to a couple other
techniques:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Kyle wrote:

> I have one data of 720% and the next largest in 140%. How can I hide on the
> bar graph gridlines 200-600? I can't find any help on it anywhere.


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off