Excel Charts using VBA

You can do almost anything in VBA that you can do as an Excel user. The easiest way to find out how the code will look is to record the code of producing the chart and then take a look at the code and work from there.

I recorded creating a chart from a pivot table and got the following code. My pivot table was on Sheet4 and A6 was inside it.

Sub Macro2()
Charts.Add
ActiveChart.SetSourceData Source:=Sheets("Sheet4").Range("A6")
ActiveChart.Location Where:=xlLocationAsNewSheet
End Sub

Formatting the chart to appear as you need is another record a macro and see what it does and tweak it to suit your needs.

Laura GB