Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing DataSource of a Chart
Hi all,
Every morning I have to run a macro for reporting needs, basically I add a row in a table from wich I draw multiples charts. I would love if the macro could add the new data to expand the chart of one day. I have try to use variable with the command SetDataSource, but without any succes. The trick part is, my charts use differents column (and row for the header) that are not adjacent. To sum this up : Let's say one of my graph has for Datasource : "A1, A17:A31, C1, C17C:31, F1, F17:F31" and I want the following day :"A1, A17:A32, C1, C17C:32, F1, F17:F32". Help would be greatly appriciated . Mike --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing DataSource of a Chart
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating A Datasource | Excel Discussion (Misc queries) | |||
Changing datasource for pivottables | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
Chart DataSource Change | Charts and Charting in Excel | |||
vb and excel as datasource | Excel Programming |