Format Date in Chart Title

M

Michael Singmin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

controlling chart location 1
Assign Chart Title w/ VBA 1
No Chart Titles 1
Update "centerheader" code running slowly need help speeding up 7
Store Current Selection As Range Variable. 3
change all range in chart 1
Want Macro to save to .xlsx 2
Create several charts in one go using VBA 4

Top