Date in Chart Title

  • Thread starter Thread starter IJ Anderson
  • Start date Start date
I

IJ Anderson

I want the chart title to include a date, "October 31, 2009." It shows as "
31-Oct-09." The ribbon to format text is not accessible while in chart.

Any ideas to format this change.

Thanks
 
Hi,

Does this mean your chart title is linked to a cell in someway?
For me the formatting of the cells is carried through to the chart title.
If the cell contains text and formula reference then use the TEXT function
to format the string.

Here the data is in C1.

B1: ="Chart Date " & TEXT(C1,"dd-mmmm-yyyy")

If not you need to explain more about where the title text is coming from.

Cheers
Andy
 
Why not format it in the data sheet using =TEXT(A2,"mmmm dd, yyyy"), and
then use that cell as the source cell for your chart title?
Or in fact you can just format the date in a data sheet cell the way you
want it, and the chart will pick up that format when you link to it.
 
Back
Top