put a textbox on the chart (or use a title). Then select the textbox

go to the formulabar

put in an equal sign,
navigate to cell with the mouse an click in it.

Hit enter.

--
Regards,
Tom Ogilvy

"Metallo" wrote in message
...
Hi,

My WB contains many Charts linked to many tables etc.
Every month I update them in order to get an YearTo Date situation.
A remark I got from a user is that in the chart is not evident which month
I'm referring to, (although it's YTD, during a presentation it would be
better to see, say, December YTD).
Do I have a possibility to get this information embedded in the plot area
every month automatically? So far, I have to digit it in the title of the
chart.
Bear in mind, that many of my sheets have a specific cell containing the
month in number, for instance, YTD 12, maybe there's a way to link that
cell
to the Chart?

Thank you for your help

Alex