how do I make a graph with one very large piece of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

taleman - 27 Oct 2006 18:52 GMT

I am trying to make a graph in Excel with mostly small numbers for data, but
with one large number. The graph does not display well. Is there a way to
break up that large number so that the small numbers show up too.

eg
Hockey 3
Soccer 2
Basketball 3
Football 59

Reply to this Message

Bernard Liengme - 27 Oct 2006 19:08 GMT

There is no really "good" way
Some suggestions are
1) Put football on a secondary axis
2) Use a log scale
3) Set the maximum y scale value to a small number (5, say) and add a text
box to state that football is 59
I favour #3
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I am trying to make a graph in Excel with mostly small numbers for data,
>but
[quoted text clipped - 7 lines]
> Basketball 3
> Football 59

Reply to this Message

Jon Peltier - 27 Oct 2006 19:48 GMT

If you're up for a challenge:

4) Broken Y Axis, http://peltiertech.com/Excel/Charts/BrokenYAxis.html

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

> There is no really "good" way
> Some suggestions are
[quoted text clipped - 15 lines]
>> Basketball 3
>> Football 59

Reply to this Message