Chart Creation with VBA

Excel SpreadsheetDid you know that Excel Charts can be created using VBA? Have you ever needed to create different chart styles from one set of data?
We experimented in creating charts using VBA coding and this is the result. In both the demo and full versions there are two files; one that creates a new chart sheet each time the macro is run; the other overwrites the chart sheet with the updated style or data.

The fully working demo version has some restrictions, and of course the VBA code is hidden. Try it for yourself and give us your feedback.

The full version of this Excel template has no restriction on the chart style type, size or data values.

Our introductory video will be available shortly. Check out our You Tube channel for more video tutorials. Meanwhile, contact us if you have any questions, or if you would like this template adapted for your own use.

The editable version of this worksheet is without restrictions and passwords, allowing you to freely view and change the code, etc to meet your own requirements. Price will be subject to the current rate of UK VAT where applicable.

We recommend that you add our email address ( to the contacts in your email program to help prevent our emails from going into the spam/junk mail folder.


We do require your email address in order to send the link to your free worksheet, and it would be good to use your name in a personal thank you. Our privacy policy is your assurance that any personal information is safe with us.