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

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

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

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