Category Archives: Drawing

Drawing in Excel-4

Posted on 15/07/2008 by dougaj4

This post will look in a bit more detail at the methods presented in the previous post.  It would be a good idea to open the previous post on another tab, or download the example file and open the code … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 3 Comments

Drawing in Excel-3

Posted on 04/07/2008 by dougaj4

Previous post OK, here are some of the promised basics of using VBA to create drawings in Excel. This and following posts will cover: The shape objects and how to create them How to select, group, and delete shapes How … Continue reading →

Posted in Drawing, Excel | Tagged , , , | 6 Comments

Drawing in Excel – 2

Posted on 22/06/2008 by dougaj4

Before getting down to basics, the attached file: Animation demo Illustrates how Excel shapes can be simply animated. Screen shot: The code for the animation (having previously drawn a circle and a rectangle with no fill, and noted their names): … Continue reading →

Posted in Drawing, Excel, Newton | Tagged , , , , | 19 Comments

Drawing in Excel – 1

Posted on 01/06/2008 by dougaj4

This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to … Continue reading →

Posted in Charts, Drawing, Excel | Tagged , , , | 6 Comments