Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Chart with Quarterly Gridlines

Posted by Doug on February 15, 2002 6:54 PM

How can I make the gridlines on my chart show at a monthly, quarterly or annual interval, rather than being spaced a fixed number of days apart? For example, I need them to all be the 1st of each month, quarter, or year, regardless of variations in the number of days in the months, quarters or years.

Re: Chart with Quarterly Gridlines

Posted by Mike on March 04, 2002 8:50 AM

Try using the Time-scale option under the Chart Options, Axes tab. Then go into the Format Axis, Scale tab and configure the Major Unit to Day(s)or month(s).

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.