Dynamically change data in chart title

  • Thread starter Thread starter Bill James
  • Start date Start date
B

Bill James

Is there a way to put a cell reference in the chart title text box? I have
numerous charts that have a date in the title. It would be much less work if
I can modify a date in a cell and have all the charts automatically be
updated. Example: "Service Calls - Sunday 02/03/08" would be "Service Calls
- Sunday =A2" where cell A2 has my date. Or can this be modifiec via a VBA
macro?
 
Select the chart tile and then type the cell reference in the formula bar,
prefixed by the sheet name, such as =Sheet1!A2. To get what you want, in B2
add

="Service Calls - Sunday "&TEXT(A2,"dd-mmm-yyyy")

and the reference that cell.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Even easier, select the title, type = in the formula bar, then click on the
cell. This works with chart titles, axis titles, data labels, and shapes
(text boxes etc).

- Jon
 
Back
Top