Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Updating the chart source data
i have many charts in a sheet. i want to make their souce data
dynamic. the source range of charts are like sheet1!$B$9:$CN$13 where $B$9 is starting range and " $CN$ " is ending range. for every chart the starting range is different but the ending Datarange is of same Column "$CN" . i want to make the column Letter dynamic ,Row number are Static ... from "CN" it has to change it to "CO" in all the charts.. Every occurence of CN DataRange has to be changed to CO .Every month one column gets added up. i.e from co to cp and so on. this change has to reflect in all the charts . hope anyone can provide a macro for this |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Updating the chart source data
On Tue, 24 Nov 2009 23:27:41 -0800 (PST), vicky
wrote: i have many charts in a sheet. i want to make their souce data dynamic. the source range of charts are like sheet1!$B$9:$CN$13 where $B$9 is starting range and " $CN$ " is ending range. for every chart the starting range is different but the ending Datarange is of same Column "$CN" . i want to make the column Letter dynamic ,Row number are Static ... from "CN" it has to change it to "CO" in all the charts.. Every occurence of CN DataRange has to be changed to CO .Every month one column gets added up. i.e from co to cp and so on. this change has to reflect in all the charts . hope anyone can provide a macro for this You should ask this question in the microsoft.public.excel.programming group. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart not updating with changes in source data | Charts and Charting in Excel | |||
auto updating source data | Excel Discussion (Misc queries) | |||
auto updating source data | Charts and Charting in Excel | |||
Updating charts when data source is in a different file | Charts and Charting in Excel | |||
updating chart source after transposing rows | Charts and Charting in Excel |