Excel Updating the title of a Chart in Excel via VBA

Joined
Jun 22, 2010
Messages
1
Reaction score
0
I have sheet "Data1" of data in which I add a new row of data at the end of the sheet every few days. Now I have another sheet "Chart1" in which I have the chart. I have a makro which updates the chart according to the new data. I want the makro to update the Title of the chart to be some fixed text followed by the value in the first element of the row of new data entered. Following is what I am trying to do

ActiveChart.ChartTitle.Caption = "Some of my text" & "= 'Data1'!$A$" & RowNumber

The output of this on the title of the chart is "Some of my text = 'Data1'!$A$17

Thanking you in advance

Best Regards
Jawad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top