Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Updating the chart source data
1 view
Skip to first unread message
vicky
Nov 25, 2009, 2:27:41 AM11/25/09
to
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
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
CellShocked
Nov 25, 2009, 7:26:12 AM11/25/09
to
On Tue, 24 Nov 2009 23:27:41 -0800 (PST), vicky <vimalb...@gmail.com>
wrote:
wrote:
You should ask this question in the microsoft.public.excel.programming
group.
0 new messages