If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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, -- ----- |
#2
|
|||
|
|||
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, -- ----- |
#3
|
|||
|
|||
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, -- ----- |
Thread Tools | |
Display Modes | |
|
|