carlgren
06-21-2013, 02:17 PM
Hi,
I used the following code to create a chart:
With shtMain.ChartObjects.Add _
(Left:=20, Width:=430, Top:=170, Height:=225)
.Chart.SetSourceData source:=Sheets("Results").Range("$d$2:$e$" & rowCount)
.Chart.ChartType = xlColumn
End With
and it works fine for creating the chart but on the right hand side of the chart is "Series 1".
I can't figure out how to get rid of that or to get a title to display on my chart.
Thanks
Don
I used the following code to create a chart:
With shtMain.ChartObjects.Add _
(Left:=20, Width:=430, Top:=170, Height:=225)
.Chart.SetSourceData source:=Sheets("Results").Range("$d$2:$e$" & rowCount)
.Chart.ChartType = xlColumn
End With
and it works fine for creating the chart but on the right hand side of the chart is "Series 1".
I can't figure out how to get rid of that or to get a title to display on my chart.
Thanks
Don