Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollbar in charts
I have not used scrollbar in charts before,
I have seen posting for scroll bar option but still did not get it. if I have to add scroll bar to the chart then what should i do? I know the icon from the controlbox tool menu but I dont know how to write the code to connect scroll bar with chart/data. any help will be appreciated. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollbar in charts
Do a Google with: excel chart control "forms toolbar"
Lots of info out there on the topic Then come back with more specific questions best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "kay" wrote in message ... I have not used scrollbar in charts before, I have seen posting for scroll bar option but still did not get it. if I have to add scroll bar to the chart then what should i do? I know the icon from the controlbox tool menu but I dont know how to write the code to connect scroll bar with chart/data. any help will be appreciated. Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollbar in charts
in excel file - Scrollbar.xls
i have created scroll bar and zoom bar and it does not give proper value on x axis it show % instead of Week i have this table - for 52 weeks. Week Utilization Est Target 1 99% 99% 90% 2 95% 95% 90% 3 90% 90% 90% 4 92% 91% 90% 5 97% 92% 90% 6 100% 88% 90% 7 97% 89% 90% 8 87% 90% 90% Formula i am using - for data in x axis lable XData =offset(Sheet3!$A$3,Scroll,1,Zoom,1) formula for values (Y axis value) utilization=OFFSET(Scrollbar.xls!XData,0,0) Est = =OFFSET(Scrollbar.xls!XData,0,1) Target = =OFFSET(Scrollbar.xls!XData,0,2) Thanks! "Bernard Liengme" wrote: Do a Google with: excel chart control "forms toolbar" Lots of info out there on the topic Then come back with more specific questions best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "kay" wrote in message ... I have not used scrollbar in charts before, I have seen posting for scroll bar option but still did not get it. if I have to add scroll bar to the chart then what should i do? I know the icon from the controlbox tool menu but I dont know how to write the code to connect scroll bar with chart/data. any help will be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scrollbar size | Excel Discussion (Misc queries) | |||
Scrollbar help | Excel Discussion (Misc queries) | |||
Formatting scrollbar | Excel Discussion (Misc queries) | |||
ScrollBar property | Excel Discussion (Misc queries) | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) |