Posted to microsoft.public.excel.programming

Shell

external usenet poster

Posts: 32

Delete a chart

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to delete chart	NonTechie	Charts and Charting in Excel	7	September 24th 09 05:59 AM
delete chart	Wayne	Excel Discussion (Misc queries)	6	May 3rd 07 03:00 PM
delete worksheet with chart?	Judy Ward	Excel Programming	2	August 23rd 05 12:11 AM
Delete Chart	agac8103	Charts and Charting in Excel	3	December 13th 04 04:54 AM
Using VBA to Delete a Chart	MikeM[_2_]	Excel Programming	3	October 14th 03 02:49 AM

All times are GMT +1. The time now is 03:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us