Bar chart scales

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pluto - 15 Dec 2003 11:10 GMT

Hi,
I have data that has large discrepancies in it. For
example, 90% of the data is on a scale of 10. The
remaining 10% is on a scale of 900. I want to create a
split in the bar so that the one outlier doesn't create a
graph that shows only the large number and not the small
numbers. How do I do that?
Pluto

Reply to this Message

Tushar Mehta - 15 Dec 2003 12:53 GMT

Check Jon Peltier's
http://www.geocities.com/jonpeltier/Excel/Charts/BrokenYAxis.html

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Hi,
> I have data that has large discrepancies in it. For
[quoted text clipped - 4 lines]
> numbers. How do I do that?
> Pluto

Reply to this Message