Hi all,
A few months ago I managed to create, with the help of a couple of great guys from here, a worksheet with 31 charts on it. The charts displayed data from 31 various rows on other worksheets. At the top of the WS with the charts are some buttons that select which WS the data comes from. It works great, just the way I wanted it to. When I press a button it retrieves the data from that WS and displays it. Press another button and the charts update to the data from that WS. EXCEPT for one chart. This one chart only displays the data from the first WS with data. I have tried deleting it and redoing it, copying another chart and changing the data source but nothing sems to work. I have checked all the properties between the charts and they SEEM all the same. At first I thought it might have been the macros attached but it can't be because the macros are identical for each button. Unfortunately I can't post the workbook due to commercial reasons. Can someone please direct me in the correct direction. Also this is happening across 4 workbooks I have made, cut and paste of course, so I have cut and pasted the problem. I really am at a loss as to where to look.
Bookmarks