| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Date in Chart Title
Hello group,
In Cell B2 I have 3-Oct-04 My code is as follows With Sheet1.ChartObjects(1).Chart .ChartTitle.Text = DateValue(Range("B2")) End With The Chart title displays 10/3/04 How can I get it to display 3/10/04 ? Thanks Michael Singmin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format Date in Chart Title
What is your value in Range B2?
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format Date in Chart Title
"Chip" wrote:
What is your value in Range B2? Hello Chip, In B2 is a proper date. Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in Chart Title | Charts and Charting in Excel | |||
| Format Chart Title Alignment Vertical doesn't work | Charts and Charting in Excel | |||
| I would like to format a dynamic chart title | Charts and Charting in Excel | |||
| Date in a chart title | Charts and Charting in Excel | |||
| add date to a chart title? | Excel Programming | |||
Linear Mode
