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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|