chart problem

M

mayuss

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("Chart
1").SeriesCollection(1).Values =
Range(Workbooks("workbook1.xls").worksheets(2).Cells(x, y),
Workbooks("workbook1.xls").worksheets(2).Cells(x1, y1))

but :( nothing (it doesn't work).

HELP PLEASE!!!
 
Top