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
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