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

What type of charts are they? 2 column charts?

Column and a line chart?

Which version of EXCEL are you using?

"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

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

i have another project that needs my immediate attention. i will look at
your solution tomorrow and let you know if it helps. thanks for your input.
--
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

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

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