eastsidemarket
asked on
add title on pie chart using vba
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.
I've tried:
I have also tried:
Any ideas? Thanks!
I've tried:
Dim ChartTitle As String
ChartTitle = ws.Name
ActiveChart.ChartTitle.Text = "" & Title
I have also tried:
ActiveChart.ChartTitle.Text = ws.Name
Any ideas? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the title piece of the code does the trick, thanks!
Open in new window