scroll bar on chart disappears
I put a scrollbar on a chart. Every time I click inside the chart but not
on the scrollbar the scrollbar disappears. Since the scrollbar refers to a cell, if I click on the cell the scrollbar re-appears on the chart and I can use it to change my charting range. Pretty cool feature actually. But why does it disappear? I tried "bring to front". no dice. any ideas? bob |
The scroll bar is really on the worksheet, instead of the chart. When
you activate the chart, it hides the scrollbar. To put the scroll bar on the chart: Right-click on the scroll bar, and choose Cut Right-click on the chart, and choose Paste Bob wrote: I put a scrollbar on a chart. Every time I click inside the chart but not on the scrollbar the scrollbar disappears. Since the scrollbar refers to a cell, if I click on the cell the scrollbar re-appears on the chart and I can use it to change my charting range. Pretty cool feature actually. But why does it disappear? I tried "bring to front". no dice. any ideas? bob -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Note: After adding the scroll bar to the chart, I had to change its
location to a chart sheet for the scroll bar to work. When I changed it back to an embedded chart, the scroll bar continued to work. Debra Dalgleish wrote: The scroll bar is really on the worksheet, instead of the chart. When you activate the chart, it hides the scrollbar. To put the scroll bar on the chart: Right-click on the scroll bar, and choose Cut Right-click on the chart, and choose Paste Bob wrote: I put a scrollbar on a chart. Every time I click inside the chart but not on the scrollbar the scrollbar disappears. Since the scrollbar refers to a cell, if I click on the cell the scrollbar re-appears on the chart and I can use it to change my charting range. Pretty cool feature actually. But why does it disappear? I tried "bring to front". no dice. any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
that did it! thank you.
now I can click the scrollbar to change the range of my chart. pretty cool. bob On Sun, 17 Apr 2005 07:09:55 -0400, Debra Dalgleish wrote: Note: After adding the scroll bar to the chart, I had to change its location to a chart sheet for the scroll bar to work. When I changed it back to an embedded chart, the scroll bar continued to work. Debra Dalgleish wrote: The scroll bar is really on the worksheet, instead of the chart. When you activate the chart, it hides the scrollbar. To put the scroll bar on the chart: Right-click on the scroll bar, and choose Cut Right-click on the chart, and choose Paste Bob wrote: I put a scrollbar on a chart. Every time I click inside the chart but not on the scrollbar the scrollbar disappears. Since the scrollbar refers to a cell, if I click on the cell the scrollbar re-appears on the chart and I can use it to change my charting range. Pretty cool feature actually. But why does it disappear? I tried "bring to front". no dice. any ideas? -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com