If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date in Chart Title
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Date in Chart Title
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. -- David Biddulph "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 |
Thread Tools | |
Display Modes | |
|
|