X-axis scale

[John]

Is there any way to vary the scale of the X-axis
automatically? For example, one set of data may be spread
over a 30 year period, while another could be over a 60
year period. In the 30-year example, the source data would
contain only 30 years of data and the graph would look
better if it only had a scale of 30 years.
i.e. can the expression Worksheet!$A$1:$A$60 be replaced
by Worksheet!$A$1:$A$K where K is a variable?
Thanks on advance.

 

[Jon Peltier]

John -

You can't quite do that in a series formula or a series values
reference, but you can use OFFSET and other worksheet functions to
define a named range, that can be used to specify source data. Check out
these examples and links for Dynamic Charting:

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

- Jon