Dynamic chart with scrollbar

Question

I am trying to make a sine wave in excel which propagates from start to end position with change in scroll bar (form control). I am not able to do that. Can any one help?

Answer 1

Sorry, that link does not work for me. Did you share the file? You need to share the file and then get a link and post it here.

Answer 2

Hi,

that's a OneDrive for Business link, which only allows me to view the file in the browser. But the browser does not support the form controls, so I cannot see how they are set up.

I need a link to download the file so I can edit it in Excel for desktop. So, please do as I asked above: store the file in your OneDrive (your personal OneDrive) or another file sharing service where I can download a copy.

From just looking at it I can see that your chart has a line with two points. That will always plot as a straight line. If you want to plot a sine curve, you need data for a sine curve, i.e. more than two points. 

Hi,

With more than one data complete sine curve is appearing. But I want to animate the sine wave in such a way that at intial point of scrollbar no wave will be there. Sine wave will start to generate with movement of scrollbar. Complete sine wave will be generated at final point of scrollbar. Can it be possible?

I have uploaded the file in the follwoing link.

https://d.docs.live.net/40d802fd470a2d51/Documents/SINE%20WAVE.xlsm

Answer 3

Hi,

that's a OneDrive for Business link, which only allows me to view the file in the browser. But the browser does not support the form controls, so I cannot see how they are set up.

I need a link to download the file so I can edit it in Excel for desktop. So, please do as I asked above: store the file in your OneDrive (your personal OneDrive) or another file sharing service where I can download a copy.

From just looking at it I can see that your chart has a line with two points. That will always plot as a straight line. If you want to plot a sine curve, you need data for a sine curve, i.e. more than two points.

Answer 4

Hello,

it's not clear what you want to achieve in detail. 

Conceptually, the scrollbar changes a cell value. You can use formulas that evaluate the current value of the cell that the scrollbar changes, for example dynamic named ranges whose size changes. Then use these dynamic range names as the source for a chart.

For more detailed help you need to share more information about your workbook. How about you upload a sample to your OneDrive public folder, share it and post a link here?

Hi,

I have uploaded my workbook in OneDrive. You can find the workbook in the follwoing link.  I am not getting proper shape of the wave form with movement in scrollbar. It is only a straight line. I think if we can fix the last position in graph then we can get proper shape of wave. Kindly support.

https://schneiderelectric-my.sharepoint.com/personal/sesa359106\_schneider-electric\_com/\_layouts/15/guestaccess.aspx?docid=1ea0a2ada2c7f4df28b2510dd2f489e52&authkey=AVanZWZ8d6XK01OKRgZYMT0

Thanks

Debangshu

Answer 5

Hello,

it's not clear what you want to achieve in detail. 

Conceptually, the scrollbar changes a cell value. You can use formulas that evaluate the current value of the cell that the scrollbar changes, for example dynamic named ranges whose size changes. Then use these dynamic range names as the source for a chart.

For more detailed help you need to share more information about your workbook. How about you upload a sample to your OneDrive public folder, share it and post a link here?