chart problem
 

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/