How to create a chart with wide range of numbers

[Roxana]

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

 

[Bernard Liengme]

use a log scale after subtracting MIN(y-values) to each point to make all
values positive?
best wishes

 

[ShaneDevenshire]

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.

 

[Roxana]

This worked very well...except it's pretty convoluted to add a secondary
axis...but in the end it worked.

Thanks
R