Home » Category » Microsoft Excel

Microsoft Excel: YTD to appear in the Charts

205| Fri, 23 May 2008 06:01:00 GMT| anonymous| Comments (4)
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

Keywords & Tags: ytd, appear, charts, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/494879/
 
«« Prev - Next »» 4 helpful answers below.
a good one can be found here.
www.ozgrid.com
Don Guillett
SalesAid Software
donaldb...281.com
"Metallo" <Metallo...discussions.microsoft.com> wrote in message
news:9BEF98A9-9E91-4ABB-A5DD-638AB7918281...microsoft.com...
> 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 | Fri, 23 May 2008 06:02:00 GMT |

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" <Metallo...discussions.microsoft.com> wrote in message
news:9BEF98A9-9E91-4ABB-A5DD-638AB7918281...microsoft.com...
> 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 | Fri, 23 May 2008 06:03:00 GMT |

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" <Metallo...discussions.microsoft.com> wrote in message
> news:9BEF98A9-9E91-4ABB-A5DD-638AB7918281...microsoft.com...
> > 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
>
>

metallo | Fri, 23 May 2008 06:04:00 GMT |

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

jon | Fri, 23 May 2008 06:05:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories