Hello,
I have created a macro which is shown below which creates a graph. However, i need the chart to include a chart title automatically inside the macro.
Doe anyone know how to do this?
Please Login or Register to view this content.
I want the chart title to be "Total Un-sourced parts per SCU"
Thank you!
Hey there buddy,
You could use ChartTitle.Text property under ActiveChart. To do that, select the chart first and then set the text. Try following code and see if meets your requirement. Say, if your chart name is "Chart 1" then,
Please Login or Register to view this content.
cOdEsLiZeR - Back after a long break.. Let's sLiZe some more cOdEs!!
Thank you for your response.
I created the chart and it is named chart 17 (due to creating so many).
On this excel page, there will be many charts being created so linking the chart title to a specific chart name will be difficult.
is there any way of inserting something in the macrowhich just names the chart it is actually creating and not linking it to a specific chart name?
doesn't matter, have solved this myself, having a 'blonde' day today!
Yes, avoid Selection then. As soon as you add a chart to the sheet, be default, it'll be the active chart. Simply, add a title to the chart (if the chart has more than one data columns - which is your case) and use the Text property to change the title. For single column data the title is available by default. Try following code, might see some good results
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks