Help with adding x-axis major gridlines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judi - 27 Dec 2006 23:46 GMT

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?

Reply to this Message

Jon Peltier - 28 Dec 2006 00:40 GMT

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
_______

> 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?

Reply to this Message