hatman
Well-known Member
- Joined
- Apr 8, 2005
- Messages
- 2,664
I have the following code snippet:
Which is part of a much larger application. Basically, this works fine almost always, but occassionally, when the code tries to set the HasTitle property, I get an error 'unable to set HasTitle Property'. When I debug, and look at the Chart, ther is NO PlotArea... and I can;t figure out why. Right now, I can;t figure my way out of it, I can;t figure out how to ensur ethat ther eis a PlotArea... or how to create one if it's missing. Any help woul dbe appreciated.
Code:
Set Chrt = Charts.Add(before:=Sheets(Insert_Sheet_Name))
Chrt.ChartType = xlXYScatterLinesNoMarkers
'set the tab name and chart title
Chrt.Name = shtCharts.Range("A" & Chrt_Row).Value
Chrt.HasTitle = True
Which is part of a much larger application. Basically, this works fine almost always, but occassionally, when the code tries to set the HasTitle property, I get an error 'unable to set HasTitle Property'. When I debug, and look at the Chart, ther is NO PlotArea... and I can;t figure out why. Right now, I can;t figure my way out of it, I can;t figure out how to ensur ethat ther eis a PlotArea... or how to create one if it's missing. Any help woul dbe appreciated.