I am trying to add a chart title to a pie chart and would like it to equal the name of the worksheet. having a hard time getting this to work.
Dim ChartTitle As String
ChartTitle = ws.Name
ActiveChart.ChartTitle.Text = "" & Title
I have also tried:
ActiveChart.ChartTitle.Text = ws.Name
Any ideas? Thanks!