Hello,
I am trying to add a title to my radar graph but keep getting an error on the line in yellow. Can someone explain why pls ? thank you.
kind regards
Kaps
I am trying to add a title to my radar graph but keep getting an error on the line in yellow. Can someone explain why pls ? thank you.
kind regards
Kaps
Rich (BB code):
current_question = output_workbook.Sheets(sheet_name).Range("o2").Offset(0, c).Value
Set chart_output_range = output_workbook.Sheets(sheet_name).Range("a5").Offset(((c - 1) * 7) + 1, 1).Resize(5, 6)
Set chart_data_range = output_workbook.Worksheets(sheet_name).Range("o1").Offset(last_row_of_source_data + 2, c).Resize(5, 1)
With output_workbook.Sheets(sheet_name).ChartObjects.Add _
(Left:=chart_output_range.Left, Width:=chart_output_range.Width, Top:=chart_output_range.Top, Height:=chart_output_range.Height)
.Chart.SetSourceData Source:=chart_data_range
.Chart.ChartType = xlRadar
' .ChartTitle.Text = current_question
End With
Last edited by a moderator: