VBA Training

Hi Melanie, thanks for your query. We code a chart on our advanced VBA course, but the quickest way for you to experiment with this is to record the creation of a chart using the macro recorder and then examine the code. Be warned, that in Excel 2003 the macro recorder does not "drill down" as far as it does in later versions, so if you record yourself modifying, say, the removal of tick marks on the x-axis of your chart it will fail to translate this into code. The code we use on our course covers this sort of detail.

Hope this helps,

Anthony