J
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.
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.