View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Metallo[_3_] Metallo[_3_] is offline
external usenet poster
 
Posts: 39
Default YTD to appear in the Charts

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