Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic data ranges and Charts
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic cell ranges in charts | Charts and Charting in Excel | |||
Dynamic charts without Named Ranges? | Charts and Charting in Excel | |||
Using named ranges in dynamic charts (excel 2007) | Excel Worksheet Functions | |||
of Named Ranges, Dynamic Charts and scroll bars... | Charts and Charting in Excel | |||
a question regarding dynamic ranges and charts | Charts and Charting in Excel |