Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing the last row of a chart and changing it
Hi,
I have about 100 charts in a spreadsheet that refer to various sheets filled with data of varying number of columns. When I import new data over the existing data the charts ofcourse do not reflect the additional data. What I want to do is be able to click a button to update all the charts by looping through them to show the new data which is imported onto these sheets. I don't want manually go to the series and make them dynamic as there are one hundred of them. So I need to capture from the chart the reference to the data and modify it. Any guidance will be greatly appreciated. Thanks in advance Suzanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
Changing the chart name | Charts and Charting in Excel | |||
Capturing chart title from cell | Charts and Charting in Excel | |||
Changing chart title changes position of chart | Excel Programming | |||
capturing data on multiple students; keeping history; making chart | Excel Discussion (Misc queries) |