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