Charts

Hello Fareen,

The code for the chart is the same, but you need to include before that code the following one line to create a new chart sheet.

Charts.Add (this is what you need to type)
ActiveChart.ChartType = xl3DColumn

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer