i can't download that file - the others at your site (i only tested 2 of
them) download fine. however, i don't believe that your solution would help.
i am familiar with using a secondary axis. however, that works if the
values of the numbers on the secondary axis are fairly close to each other.
the values for these data points go from 9 to 17000 with most of the values
in the range of 100 to 500.

i am using 2 chart types -a line graph for unrestricted revenue and a column
graph for restricted revenue. there are 79 data points in both restricted
and unrestricted. i am looking at monthly contributions over a 7 year period.
--
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