View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Date in Chart Title

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