Hi,

I have six charts displayed on a page with buttons
representing product categories on the left side of the
worksheet. The data supporting the graphs is on a
different worksheet.

When I click on one of the the buttons I need to update
all six graphs and change their data ranges to point to
different rows on the worksheet containing the data. I
have tried using a number of different methods with no
success, I either get subscript out of range or 1004
error. Anybody know how to do this?

Thanks

Keith