Hi all, I have just added a second chart to a workbook and then proceeded to add a second scroll bar for that chart. The problem is, the second scroll bar will also scroll the first chart, even though I do not have it linked to it. Is this normal?
Hi all, I have just added a second chart to a workbook and then proceeded to add a second scroll bar for that chart. The problem is, the second scroll bar will also scroll the first chart, even though I do not have it linked to it. Is this normal?
Last edited by Mordred; 12-30-2010 at 09:27 AM.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
I've added a third and fourth chart, with a third and fourth scrollbar, and now all 4 charts are scrolling. I have created different names for scrolling for each chart, linked the starting point to 4 different cells and still have all four scrolling.
I figure the best way here is to upload the file. It is just a bit bigger than 1000KB so I zipped it.
All of the scrollbars are linked to the same cell, S1.
All of the named ranges use S1 to determine the column offset.
Yep, that fixed it Andy, thanks a million.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks