Source Data - Values - Dynamic Range possible?

B

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top