View Single Post
  #1   Report Post  
Bob
 
Posts: n/a
Default Scrollbar on Chart Jumps to Left when Chart is Clicked

I fiddled around with 'offset' and a scrollbar, and now I can change the
range of my chart just by clicking on the scrollbar. However, there is a
problem with placement.

If I click on the chart, and move the scrollbar to where I want it, when I
click *OFF* the chart, the scroll bar moves about double the distance from
top left that it was when the chart was clicked. It's like the scrollbar
thinks I'm doubling the size of the chart when I click off the chart. If
I position the scrollbar past halfway from top left, when I click off the
chart the scrollbar totally disappears.

Or, to put it another way, WHEREVER the scroll bar is on the chart (while
I'm editing my data in other cells) if I click on the chart, the scrollbar
jumps towards the top left (about half the distance).

I'm thinking this has something to do with the fact that when I pasted the
scroll bar on the chart it first appeared at the top left.

Any ideas?

thanks
john