| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a chart with wide range of numbers
Hello,
What is the best way to create a chart in excell 2007 when you have a wide range of numbers (positive to negative) ? The numbers in the middle of the range don't get represented clearly. Thank you Roxana |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to create a chart with wide range of numbers
use a log scale after subtracting MIN(y-values) to each point to make all
values positive? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Roxana" wrote in message ... Hello, What is the best way to create a chart in excell 2007 when you have a wide range of numbers (positive to negative) ? The numbers in the middle of the range don't get represented clearly. Thank you Roxana |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to create a chart with wide range of numbers
Hi,
Another alternative is to plot the small (intermediate) values on one axis and the large values on the secondary Y axis. This means you need to create two series instead of one. -- Thanks, Shane Devenshire "Roxana" wrote: Hello, What is the best way to create a chart in excell 2007 when you have a wide range of numbers (positive to negative) ? The numbers in the middle of the range don't get represented clearly. Thank you Roxana |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to create a chart with wide range of numbers
This worked very well...except it's pretty convoluted to add a secondary
axis...but in the end it worked. Thanks R "ShaneDevenshire" wrote: Hi, Another alternative is to plot the small (intermediate) values on one axis and the large values on the secondary Y axis. This means you need to create two series instead of one. -- Thanks, Shane Devenshire "Roxana" wrote: Hello, What is the best way to create a chart in excell 2007 when you have a wide range of numbers (positive to negative) ? The numbers in the middle of the range don't get represented clearly. Thank you Roxana |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a pie chart with 793 numbers? Possible? | New Users to Excel | |||
| Print wide chart over multiple pages? | Charts and Charting in Excel | |||
| Wide data range | Charts and Charting in Excel | |||
| Excel charts with one standard grid and wide range of numbers | Charts and Charting in Excel | |||
| How to break scale when numbers are wide range? | Charts and Charting in Excel | |||
Linear Mode
