Source Data - Values - Dynamic Range possible?
 

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,
--
-----

Source Data - Values - Dynamic Range possible?
 

It takes a little VBA:

http://peltiertech.com/WordPress/dyn...t-source-data/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"BR" wrote in message
...
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,
--
-----

Source Data - Values - Dynamic Range possible?
 

Very useful Jon, many thanks. Query answered.

--
-----


"Jon Peltier" wrote:

It takes a little VBA:

http://peltiertech.com/WordPress/dyn...t-source-data/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"BR" wrote in message
...
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,
--
-----