Thread
:
Delete a chart
View Single Post
#
3
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
Delete a chart
Charts.Add
myChart = ActiveChart.Name
Sheets(myChart).Delete
--
Regards,
Nigel
"Shell" wrote in message
...
I have created a chart in code as follows:
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Sheets("Analysis").Range("B1:C3"),
PlotBy:= _
xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:="Analysis"
With ActiveChart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With
How do I delete the chart in code?
Thanks
--
Shell
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]