| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I make a graph with one very large piece of data
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how do I make a graph with one very large piece of data
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| Limiting Data Obatined By A Graph From A Spread Sheed | Charts and Charting in Excel | |||
Hybrid Mode
