Displaying and formatting gridlines
You can display the major and minor gridlines of a chart that has an x-axis and a y-axis. Gridlines display behind the chart series and are extensions of the ticks on each axis that span the whole chart. Gridlines allow you to clearly see the value of each data point.
You can also change the border style of the gridlines and specify the border’s width and color.
To display a major gridline |  |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
 Axes, and click an axis. |
|
3.
|
|
Click the Grids & ticks tab.
|
|
4.
|
|
Enable the Show major gridline check box.
|
|
5.
|
|
Open the Major gridline picker, and click one of the following:
|
|
•
|
Gridline (only)
|
|
•
|
Gridline with ticks
|
|
•
|
Inside tick (only)
|
|
•
|
Ouside tick (only)
|
|
•
|
Tick on both sides
|
|
•
|
None
|
|
If you want to display the grid on top of the series, enable the Grids on top check box.
|
To display a minor gridline | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click an axis. |
|
3.
|
|
Click the Grids & ticks tab.
|
|
4.
|
|
Enable the Show minor gridline check box.
|
|
5.
|
|
Open the Minor gridline picker, and click one of the following:
|
|
•
|
Gridline (only)
|
|
•
|
Gridline with ticks
|
|
•
|
Inside tick (only)
|
|
•
|
Outside tick (only)
|
|
•
|
Tick on both sides
|
|
•
|
None
|
|
If you want to display the grid on top of the series, enable the Grids on top check box.
|
To display a 3D chart gridline | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click an axis. |
|
3.
|
|
Click the Grids & ticks tab.
|
|
4.
|
|
Enable the Show gridline check box.
|
To change the major gridline color | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click an axis. |
|
3.
|
|
Click the Grids & ticks tab.
|
|
4.
|
|
In the major gridline area, open the Color picker, and click a color.
|
|
You can also
|
|
|
Change the gridline width
|
Open the Width picker, and click a width.
|
|
Change the gridline style
|
Open the Style picker, and click a line style.
|
To change the minor gridline color | |
|
1.
|
|
Click a chart.
|
|
2.
|
|
Click Chart
Axes, and click the axis you want. |
|
3.
|
|
Click the Grids & ticks tab.
|
|
4.
|
|
In the minor gridline area, open the Color picker, and click a color on the color palette.
|
|
You can also
|
|
|
Change the gridline width
|
Open the Width picker, and click a width.
|
|
Change the gridline style
|
Open the Style picker, and click a line style.
|
To change the gridline border style | |
|
1.
|
|
Click a chart, and click a gridline.
|
|
2.
|
|
Right-click the selected gridline, and click Gridline properties.
|
|
3.
|
|
Click the Line tab.
|
|
4.
|
|
Open the Style picker, and click a border style on the border style palette.
|
|
You can also
|
|
|
Change the border width
|
Open the Width picker, and click a border width on the width palette.
|
|
Change the border color
|
Open the Color picker, and click a color on the color palette.
|