Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Chart Error
I keep getting HasTitle of _Chart has failed error. Any ideas?
Sub MakeChart() On Error Resume Next Application.DisplayAlerts = False Charts("Term Chart").Delete On Error GoTo 0 Set NewChart = ThisWorkbook.Charts.Add NewChart.Name = "Term Chart" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "Terms" If FirstRange 1 Then NewChart.SeriesCollection.Add Source:=FirstRange End If If SecondRange 1 Then NewChart.SeriesCollection.Add Source:=SecondRange End If If ThirdRange 1 Then NewChart.SeriesCollection.Add Source:=ThirdRange End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Cannot combine chart type error with only one chart. | Charts and Charting in Excel | |||
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
Chart error | Excel Programming | |||
Chart Error when using Chart Line - Column on 2 Axes in vba code | Excel Programming |