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

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

How do I show break in bar graph to show large and small numbers 1
How to make a break in chart scale? 1
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? 1
NEED HELP WITH PULLING IN ONLY NECESSARY DATA FROM A TABLE 1
How to make a chart with selective (discontinuous) data? 1
Excel 2007 - Printing graphs with no data or graph lines 1
How do i break really long bars to show short ones in Excel? 1
Making a graph with easily changed dates 2

Top