Creating charts in Excel VBA 2010

Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart sheet is the Chart object whereas the embedded chart is part of the shape collection for the worksheet.

Read More……