jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
After coping a chart to another sheet, The new chart seems to have the same "look" as the copied one, except the Horizonal (Category) Axis which is dates (Excel numeric) show as 5/15, 5/22, 5/29 on the Original Chart, but
5/15/2011, 5/22/2011, 5/29/2011 on the New Chart.
I have on the New Chart selected the Horizonal (Category) Axis 50 times,
Done a right click, selected Format Axis... Numbers Tab, and ALTHOUGH GREY-OUT it shows Date 3/14 Style....
How can I change this?
I'd love to be able to change it in the immediate window with a one line command.
Any help appreciated.
Jim
5/15/2011, 5/22/2011, 5/29/2011 on the New Chart.
I have on the New Chart selected the Horizonal (Category) Axis 50 times,
Done a right click, selected Format Axis... Numbers Tab, and ALTHOUGH GREY-OUT it shows Date 3/14 Style....
How can I change this?
I'd love to be able to change it in the immediate window with a one line command.
Any help appreciated.
Jim
