Source Data - Values - Dynamic Range possible?

[BR]

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,

 

[Jon Peltier]

It takes a little VBA:

http://peltiertech.com/WordPress/dynamic-chart-source-data/

- Jon

 

[BR]

Very useful Jon, many thanks. Query answered.