charts
 

Hi,
I have some 100-150 dates whose different datas have to be represented on
line chart. So when i created same the chart made is small and cant be
properly displayed. What i need is ome sort of scroll bars at ends so that
at one time i can show say 10-15 dates' data and scroll to show others....

pl help...

try this url

http://www.andypope.info/charts/Scrolling.htm


help wrote in message
...
Hi,
I have some 100-150 dates whose different datas have to be represented on
line chart. So when i created same the chart made is small and cant be
properly displayed. What i need is ome sort of scroll bars at ends so
that
at one time i can show say 10-15 dates' data and scroll to show others....

pl help...

charts
 

This is very intriguing! How do you you get the scroll bar to display and
lind to E2?
--
..


"R.VENKATARAMAN" wrote:

try this url

http://www.andypope.info/charts/Scrolling.htm


help wrote in message
...
Hi,
I have some 100-150 dates whose different datas have to be represented on
line chart. So when i created same the chart made is small and cant be
properly displayed. What i need is ome sort of scroll bars at ends so
that
at one time i can show say 10-15 dates' data and scroll to show others....

pl help...

charts
 

Hi,

That particular scroller is from the Control toolbox toolbar.
If you go into design mode, press the pencil/ruler/triangle icon, and
then right click the scroller and pick properties, you can set the
LinkedCell property to E2.

Cheers
Andy

Aaron wrote:
This is very intriguing! How do you you get the scroll bar to display and
lind to E2?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

charts
 

Thank you very much!!!!!
--
..


"Andy Pope" wrote:

Hi,

That particular scroller is from the Control toolbox toolbar.
If you go into design mode, press the pencil/ruler/triangle icon, and
then right click the scroller and pick properties, you can set the
LinkedCell property to E2.

Cheers
Andy

Aaron wrote:
This is very intriguing! How do you you get the scroll bar to display and
lind to E2?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info