In Charts-Source Data-Values,
Can I specify a dynamic range (say, using a formula) ?

Problem:
I have an area chart showing Balances for three series (1) Senior (2) Equity
A (3) Equity B
X axis: Months 0 to 60
(display looks great for a print)

Next I change values, refresh outputs
X axis: Months 0 to 600
Chart formulae need to be edited (!), Can I avoid this by specifying a
dynamic range under - "Values" and "Category X axis labels"


many thx,
--
-----