ExcelBanter - 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/