Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO UPDATE CHARTS !
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts do not update | Excel Discussion (Misc queries) | |||
Why won't the charts update? | Excel Discussion (Misc queries) | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Update Charts | Excel Discussion (Misc queries) | |||
Macro to Update Charts Source Data | Charts and Charting in Excel |