cellMatrix.net

Spreadsheet Modeling and Related Topics

VBA Fireworks Model from AJP Excel Information

Recently I had the opportunity to build Andy Pope's fireworks display into a line chart that I produce each month. Fireworks were requested because 2009 was the best year on record for a particular business unit at work. When I presented the operating results the animation was a big hit.

Once you download the file you'll find that Andy's display utilizes an XY Scatter chart and VBA code with trigonometry functions to produce the fireworks. Because the code is unprotected you can easily load the modules into your own project and then customize the code as you wish. Even if you don't have an interest in using the display, the file is worth downloading just to study how the model was developed. Thanks Andy for making this available.

Posted on Thursday, January 28, 2010 | Comments (0) | Permalink

Page 1 of 1 pages

Statistics

  • Total Entries - 136
  • Current Viewers - 26

Categories

Entries by Day

Jul - 2010
S M T W T F S
27 28 29 30 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Recent Comments

Syndicate