![]() ![]() Change the major and minor units in order to change the gridline interval. ![]() Press with mouse on "Axis Options" arrow to expand settings.Go to tab "Axis Options" on the task pane.Double-press with left mouse button on with left mouse button on axis values to open the task pane on the right side of your Excel window.ĭouble press with left mouse button on the x axis values if you want to change the interval of vertical major and minor gridlines and vice versa.The following chart shows both major and minor gridlines in an x y scatter chart. Now select the gridlines you want on your chart:.Press with left mouse button on the arrow to expand options.You can choose a lighter color for gridlines in Excel preferences. You can use the Format Cells dialog to apply different borders to the gridlines. Try different settings there, if offered. Press with left mouse button on checkbox "Gridlines". What options have you chosen in Excel's Page Setup Try draft quality (or turn it off if it is already checked) Your printer driver may offer quality settings.Press with left mouse button on "plus" sign.The major gridlines coincide with axis values and major tick marks. Author: Oscar Cronquist Article last updated on October 22, 2018Ĭhart gridlines are great for making the chart data more readable and detailed, Excel allows you to add major and minor gridlines to a chart. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |