Date in Chart Title

[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

 

[Andy Pope]

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

 

[David Biddulph]

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.