Hello!
I would like to change the values of a existing chart ("chart 1") in
workbook1, worksheet2 (I added a column and I would like to expand
sourse data of chart) , and I don't know how. I tied something like:
Workbooks("workbook1.xls").worksheets(2).Charts("C hart
1").SeriesCollection(1).Values =
Range(Workbooks("workbook1.xls").worksheets(2).Cel ls(x, y),
Workbooks("workbook1.xls").worksheets(2).Cells(x1, y1))
but :( nothing (it doesn't work).
HELP PLEASE!!!
---
Message posted from
http://www.ExcelForum.com/