Presumably you have a date-scale axis, with the base unit in months. Double
click the axis, change Base Unit to Days, change Major Unit to 1 Month, and
change the Minimum to the first of a month.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Jo" wrote in message
...
I have a formatted chart in excel and the major tick marks and month data
is
showing in the actual middle of the month. How do I make the tick label
and
mark show at the beginning of the actual month?