How do you add a scroll bar to a chart? I have the end of day stock close
over a 5 year period and I would like to scroll back and forth to see how
the stock changes over a 50 to 75 days.

Hi,

See "Funchart7.zip" under "Charting Examples" in "Steve Bullen's Excel
Page", http://oaltd.co.uk/Excel/

Regards,
B. R. Ramachandran
"news2" wrote:

> How do you add a scroll bar to a chart? I have the end of day stock close
> over a 5 year period and I would like to scroll back and forth to see how
> the stock changes over a 50 to 75 days.
>
>
>

Thanks for help.

CC

"B. R.Ramachandran" <(E-Mail Removed)> wrote in
message news:EFD0990C-CFCE-42EE-8CBB-(E-Mail Removed)...
> Hi,
>
> See "Funchart7.zip" under "Charting Examples" in "Steve Bullen's Excel
> Page", http://oaltd.co.uk/Excel/
>
> Regards,
> B. R. Ramachandran
> "news2" wrote:
>
>> How do you add a scroll bar to a chart? I have the end of day stock
>> close
>> over a 5 year period and I would like to scroll back and forth to see how
>> the stock changes over a 50 to 75 days.
>>
>>
>>

Hi,
The funchart is for embedded charts on a spreadsheet. I was wanting to have
a chart sheet with scroll bars at the bottom. Do you know if this is
possible.

Thanks
"B. R.Ramachandran" <(E-Mail Removed)> wrote in
message news:EFD0990C-CFCE-42EE-8CBB-(E-Mail Removed)...
> Hi,
>
> See "Funchart7.zip" under "Charting Examples" in "Steve Bullen's Excel
> Page", http://oaltd.co.uk/Excel/
>
> Regards,
> B. R. Ramachandran
> "news2" wrote:
>
>> How do you add a scroll bar to a chart? I have the end of day stock
>> close
>> over a 5 year period and I would like to scroll back and forth to see how
>> the stock changes over a 50 to 75 days.
>>
>>
>>

Charles -

It will work fine. Set it up the same way, with the chart on its own
sheet, and the scroll bars on the chart sheet. The cell links from the
scroll bars are on the worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Charles wrote:

> Hi,
> The funchart is for embedded charts on a spreadsheet. I was wanting to have
> a chart sheet with scroll bars at the bottom. Do you know if this is
> possible.
>
> Thanks
> "B. R.Ramachandran" <(E-Mail Removed)> wrote in
> message news:EFD0990C-CFCE-42EE-8CBB-(E-Mail Removed)...
>
>>Hi,
>>
>>See "Funchart7.zip" under "Charting Examples" in "Steve Bullen's Excel
>>Page", http://oaltd.co.uk/Excel/
>>
>>Regards,
>>B. R. Ramachandran
>>"news2" wrote:
>>
>>
>>>How do you add a scroll bar to a chart? I have the end of day stock
>>>close
>>>over a 5 year period and I would like to scroll back and forth to see how
>>>the stock changes over a 50 to 75 days.
>>>
>>>
>>>
>
>
>