YTD to appear in the Charts

[Guest]

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

 

[Don Guillett]

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

 

[Tom Ogilvy]

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.

 

[Guest]

Tom,

It works fine.

Thank you
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.

 

[Jon Peltier]

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/
_______