Reply to thread

Message: [QUOTE="CyberTaz, post: 6818125"] I'm betting you're typing the expression directly into the chart element itself, but that isn't the 'text box' that was meant :-) Type the expression into the Chart Options> Titles text box in the Toolbox/Formatting Palette [Where it says "Click here to add title"]. I.e., If the cell you want to use for the content is C15 on SheetX type the expression as: =SheetX!C15 Then press return. (Don't omit the ! Between the sheet name & the cell reference.) If you change the content of cell C15 the title will update to reflect the change. HTH |:>) Bob Jones [MVP] Office:Mac [/QUOTE]