View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how do I make a graph with one very large piece of data

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