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

a good one can be found here.
www.ozgrid.com


--
Don Guillett
SalesAid Software

"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

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

Tom,

It works fine.

Thank you
Alex

"Tom Ogilvy" wrote:

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

You don't even need to draw a textbox. Select the chart, press the equals key, and
select the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tom Ogilvy wrote:

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.