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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"IJ Anderson" wrote in message
...
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
--
IJ Anderson