Animated XY Chart?

**Cam** · 07-05-2011, 09:39 AM

Hi,

I am hoping to animate an XY chart in Excel and wondering how to go about it.... any starts would be much appreciated.

The starting point would be 2 columns af data plotted via an XY chart - the loop would go:

plot the first point (row1)
delay in microseconds
plot the second point (row2), keeping the first point
If blank row is reached - stop.

The end result is a chart full of points down to the last row.

The data would be something like:

10 45
15 12
81 32
55 94
27 27
etc.....

PS to moderator - sorry about the duplicate post - came up with a database error so I tried again - please delete the locked thread - thanks.

**Andy Pope** · 07-06-2011, 05:18 AM

You can use a named range to extend the data covered by a series.

You will find examples of animated charts here
http://chandoo.org/wp/
http://www.excelhero.com/cgi-bin/mt/...ation&limit=20

**Cam** · 07-06-2011, 05:29 AM

Thanks Andy, just checked out your site - nice work .... :-)

Not being a VBA bod, would you mind me asking how I might achieve what you described?

**Andy Pope** · 07-06-2011, 05:41 AM

The macro will update every second.

Please Login or Register  to view this content.

The named range CHTDATA gets the number of points to plot from cell E2

=OFFSET(Sheet1!$B$2,0,0,Sheet1!$E$2,1)

To how finer control over the time delay search for the SLEEP api function.

The 2 blogs I posted have more detail on usage.