Consulting | Excel Examples
Keywords: Chart, Wait Method, Chart Series
Description: This example uses a Visual Basic for Applications procedure to update and display different values for a line chart. Each value is displayed for 1 second.
Tip: You can use the Wait method in Visual Basic for Applications to animate the display of a chart. If you use the Wait method and change the properties of the Series object, the chart will appear to be animated. Each value will show on the chart in sequence. The user of the chart can how the shape of the line changes over time.
Guide to the Example: Scroll the worksheet Sheet1 so that the line chart is visible. Click on the "Animate Graph" button and view changes in the line chart. The data series used to animate the graph are shown at the top of Sheet1. Module1 contains the Animate and ReplaceSeries procedures.
Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.