|
Re: Automatically update Graphs in Excel 2003
The named range with OFFSET is the way to go and depending on if you want to include all columns in your graph or the last x columns on your graph.
To include all use:
Code:
=OFFSET(Sheet1!$A$1,0,COUNT(Sheet1!$1:$1))
To include x (in this example last 3) use:
Code:
=OFFSET(Sheet1!$A$1,0,COUNT(Sheet1!$1:$1),1,-3)
I would use this as the named range for the xVal and you will need to create a named range for each series. the easiest way would be to offset from your xVal:
Code:
=OFFSET(xVal, 1, 0) 'ser1
=OFFSET(xVal, 2, 0) 'ser2
=OFFSET(xVal, 3, 0) 'ser3
|