Saturday, March 24, 2012

How to Add Gridlines to an Excel Chart


1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add gridlines.
2. Click the chart you want to add gridlines to so it is selected. You can tell the chart is selected because it will have a light blue border surrounding it.
3. Select the 'Layout' tab at the top of the Excel 2007 screen to display the settings in the 'Layout' ribbon. Find the 'Axes' group in the 'Layout' ribbon.
4. Choose the 'Gridlines' button in the 'Axes' group of the 'Layout' ribbon and point to 'Primary Horizontal Gridlines' to display the horizontal gridline options.
5. Use 'Major Gridlines' to display gridlines only at major units, 'Minor Gridlines' to display them at minor units or 'Major Minor Gridlines' to display the gridlines at both the major and minor unit markings.
6. Opt for 'Primary Vertical Gridlines' from the 'Gridlines' button to choose to display either 'Major Gridlines,' 'Minor Gridlines' or 'Major Minor Gridlines' at the vertical units in the chart.
7. Watch as the gridlines are displayed on the selected chart as you have indicated.

Blogger news