so sorry,

you are correct. i tried the chart with the secondary axis and it looks
much better.

thank you
--
aprilshowers


"trip_to_tokyo" wrote:


On the information that you have provided I have just uploaded a file to:-

http://www.pierrefondes.com/

It is item number 51 towards the top of my home page.

I hope that this is of help to you.

It was prepared in EXCEL 2007.

Please hit Yes if my comments have helped.

Thanks.



"april" wrote:

i have a chart in which one number is 17000 while the range for the other
data points range from 9 to 4000 with most of the data points below 1500.
the data point with 17000 distorts the rest of the data, i.e. you can't see
subtle shifts at the lower ranges. is there a way to correct this problem?

thanks in advance for your help
--
aprilshowers