Hi,

How can I arrange it so that the x and y axis scales
automatically adjust to different data within the same
series?

Eg say I make a chart that has the x axis (A1:A10) going
from 1 to ten. If I paste in an x axis range going from
100 to 1000 how can i get the scale to adjust
automatically?

Thanks for help,

N

Jon Peltier has instructions for linking the axis scale to formulas on a
worksheet:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

Nicole wrote:
> How can I arrange it so that the x and y axis scales
> automatically adjust to different data within the same
> series?
>
> Eg say I make a chart that has the x axis (A1:A10) going
> from 1 to ten. If I paste in an x axis range going from
> 100 to 1000 how can i get the scale to adjust
> automatically?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

For a readymade solution, check the AutoChart Manager add-in, available
from my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <a59201c3eb66$ef495d20$(E-Mail Removed)>,
(E-Mail Removed) says...
> Hi,
>
> How can I arrange it so that the x and y axis scales
> automatically adjust to different data within the same
> series?
>
> Eg say I make a chart that has the x axis (A1:A10) going
> from 1 to ten. If I paste in an x axis range going from
> 100 to 1000 how can i get the scale to adjust
> automatically?
>
> Thanks for help,
>
> N
>