Slider control in chart
 

Can someone please tell me how to insert a slider control into a chart?

I just want to be able to scroll up and down the data on the x axis which
are days/dates.

Many Thanks.

Slider control in chart
 

Hi,

Here is an example of a scrolling chart.
http://www.andypope.info/charts/Scrolling.htm

If you want to embed the control within the chart sheet or object you will
need to use the Forms control scroll bar.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Les" wrote in message
...
Can someone please tell me how to insert a slider control into a chart?

I just want to be able to scroll up and down the data on the x axis which
are days/dates.

Many Thanks.

Slider control in chart
 

Cheers Andy

I will download from home, can not download zip files from work even though
it's for work!

Excellent website by the way, added to my favourites and will be my forst
stop for future queries.


"Andy Pope" wrote:

Hi,

Here is an example of a scrolling chart.
http://www.andypope.info/charts/Scrolling.htm

If you want to embed the control within the chart sheet or object you will
need to use the Forms control scroll bar.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Les" wrote in message
...
Can someone please tell me how to insert a slider control into a chart?

I just want to be able to scroll up and down the data on the x axis which
are days/dates.

Many Thanks.

Slider control in chart
 

Thanks for the comments.

You may also find this page/site of interest.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Les" wrote in message
...
Cheers Andy

I will download from home, can not download zip files from work even
though
it's for work!

Excellent website by the way, added to my favourites and will be my forst
stop for future queries.


"Andy Pope" wrote:

Hi,

Here is an example of a scrolling chart.
http://www.andypope.info/charts/Scrolling.htm

If you want to embed the control within the chart sheet or object you
will
need to use the Forms control scroll bar.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Les" wrote in message
...
Can someone please tell me how to insert a slider control into a chart?

I just want to be able to scroll up and down the data on the x axis
which
are days/dates.

Many Thanks.