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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top