Help creating an animated bar chart.

[toddy17992]

I would like to make a bar chart that has a control panel that allows the chart to change based on time.

Data visualisation.png

My data are similar to the above and all I want the chart to have is 2 bars corresponding to Right and Left, that when you press play the graph moves to the next time point (Next rows) and so on until the data has finished.

I don't mind how this is done, but any help would be appreciated.

If a similar idea has been discussed or there is a particular name for what I want to do please let me know.

Thanks in advance.

[dflak]

I doubt anyone is going to take the time to recreate the data you already have. Providing a sample workbook always increases the chances that someone will pick up the quest.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[toddy17992]

Thanks for this, I have now attached a sample data set with what I want in the document.

[jeffreybrown]

How about this which uses a macro.

[dflak]

Nice implementation, Jeff. It did not work for me unless I stepped through the code manually. Even inserting a Doevents didn't do it. I had to modify your code to force a chart refresh by activating it (ugh!)

Please Login or Register  to view this content.

[jeffreybrown]

Thanks dflak. Weird why it didn't work for you, but thank you for posting an alternative which hopefully can help the OP.

[Andy Pope]

Newer versions of excel take a few more doevents to have the save effect.

I also prefer the Sleep to Application.Wait to provide finer control over the animation.

[jeffreybrown]

Thank you Andy for the additional information.

[toddy17992]

Thank you for this it is great.
One question regarding the Sleep to application in the "1232897.xlsm" file. My actual data set was recorded at 1000 Hz and has 1856 data points, how do make the playback fast enough that I doesn't take a few minutes to play through the full dataset. I have tried changing the sleep to 1 but it is still pretty slow. If this is the best that can be done I will probably just average the data to make a smaller data set.

[Andy Pope]

reduce the frequency of the loop by adding a step value

Please Login or Register  to view this content.

[toddy17992]

That's brilliant thanks.