Assign Chart Title w/ VBA

B

Bob Barnes

Last month, Jon Peltier was kind enough to give me the below code to set a Chart's Title

With ActiveWorkbook.Worksheets("OneMonth").ChartObjects(2).Char
.HasTitle = Tru
.ChartTitle.Text = "Monthly Scrap Dollars
End Wit

My question, I am not able to concatenate a named Range like..
.ChartTitle.Text = "Monthly Scrap Dollars " & ATitle ---> where ATitle is a named range filled i
thru automation within Access (yes it works from Access)...IE "From 1/1/04 To 1/19/04

I am trying similar code, but it won't work...only a string w/o concatenation is working

Can it be done

TIA - Bo
 

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

Similar Threads

Assign Chart Title w/ VBA 3
No Chart Titles 1
Create several charts in one go using VBA 4
how to add error bars into bar chart 1
Format Date in Chart Title 2
Cannot change title of second chart 2
Store Current Selection As Range Variable. 3
Chart Generation. Changing interior color. 3

Top