Flex, take a look at Quick Charts at http://www.add-ins.com/quickcharts.htm

It is close to what you want.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"graph novice" wrote in message
...
does anyone have any suggestions for a macro to update the source data for
a chart when it is on a different sheet? i have a couple charts that i have
developed based on data in sheet 1. i would like to replicate those charts
for data contained in sheet 2, then sheet 3, etc (i have 60 sheets total).
the data in sheet 2, sheet 3, etc. is in the exact same location, but just
referring to a different project. i've started doing this manually and it
will be very time consuming.

is there some type of edit/replace feature that i could use in a macro? or
a box asking for the new source data sheet (all the data locations remain
the same)?

any assistance would be greatly appreciated.

----- flex zax wrote: -----


I have several charts on sheet1. Every chart lies between columns A
and
AE starting from the top of the sheet to downward. Each chart's
source
data start in the first row below the chart and the source data (i.e
setsourcedata) is about 2,3,or 4 rows long(it varies from chart to
chart). Each chart's source data is updated from column A to column
AD
only.

- I need a macro that will loop through each chart, click on it, and
update the source data (i.e setsourcedata) to from column A to AE
instead.

I will appreciate any help.

~Flex




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!