#1   Report Post  
help
 
Posts: n/a
Default 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...
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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...



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 287
Default 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...




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 287
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"