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

T

taleman

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I don't want to graph "null" values? 1
Large Discrepencies in Graph Data 0
How to make a break in chart scale? 1
How do I show break in bar graph to show large and small numbers 1
How do you make a hole in a line graph? 2
How do I get all 5 graph charts to show data (not be greyed out)? 1
Beginner needs help to make chart or graph or pie 1
Multiple Bar Graphs on one chart 0

Top