Dynamic build of a chart

[InactiveB0845]

Hello.

I have 70 years or so of data, 1 value for each month, that I've used to build a bar chart (ends up the data distribution is trimodal). I'd like to be able to show the accumulation of the data over time to show how the shape of the chart has changed from its 'normal' distribution shape years ago to what it is now. What I am thinking is inserting one data value every 1/10 of a second through a macro, then watching the chart change as it builds the data over the 60-90 seconds it will take to get all of it included. This would be a dramatic presentation of my data.

Any ideas on this would be a great help, because I have no idea on how to start this. THANKS!

 

[mjbeam]

Record a macro while you set the source data for your chart to just the first row of data. Then again for the first and second row of data. Look at the code generated when you recorded the macro. You should be figure out the code needed by looking at the code in the recorded macro.