Currently, I have the following code which creates charts within excel:
With Sheet1.ChartObjects.Add(Left:=390, Width:=375, Top:=25, Height:=225)
.chart.SetSourceData Source:=Sheet22.Range("A1:L2")
.chart.ChartType = xlColumnClustered
.chart.ChartTitle.Characters.Text =...