This has been very helpful, Jon. Thank you so much. However, each time I
change the setting, it defaults back to its original setting. Is it how I'm
formatting the data source?

I have the data in there with dates (which I don't want to show up), and I
have a fiscal month next to that (which I DO want to show up - and just have
the date information as tick marks on the x-axis). Does that make sense?

"Jon Peltier" wrote:

Use a Line chart with dates as the X values. Double click the X axis. On the
Scale tab, set the X axis minimum to occur on the 1st of a month. Set the
Base Unit to Day(s), the Major Unit to 1 Month(s), the Minor Unit to 7
Day(s). On the Patterns tab, choose whatever for Major Ticks and something
besides None for Minor Ticks. Click OK. On the Chart menu, choose Chart
Options, and on the Gridlines tab, check the box for Category (X) Axis Major
Gridlines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Judi" wrote in message
...
I'm trying to make a chart that will have small tick-marks along the
x-axis
for a fiscal week, and a long tick-mark separating the fiscal month. I
think
I'm not formatting the data properly in the worksheet. Any ideas?