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
_______
"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"taleman" wrote in message
...
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