To delete ' Gridlines', click on one of the Gridlines, and press ' Delete' key in the keyboard. Step 7: Close the ' Format Major Gridlines' window, the result of the chart with Gridlines. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis. To add a measure as a dual axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. Step 6: To format major Gridlines: double click on the Gridlines, in the ' Format Major Gridlines' window: Dual axes are useful for analyzing two measures with different scales. Step 5: To change the number of ' Gridlines', right click the Axis (e.g., Y Axis), then click ' Format Axis' in the dialog box, and change the major units (e.g., 4) Step 4: Here is the result of ' Primary Minor Vertical' option:

Step 3: Click ' Gridlines' from the drop-down list, then select the following Gridline types 'Primary Major Horizontal', 'Primary Major Vertical', 'Primary Minor Horizontal' or 'Primary Minor Vertical' Step 2: In the ' Design' tab, click ' Add Chart Element' Step 1: Click anywhere on the chart and the ' Design' Tab will appear in the Ribbon (' Chart Design' tab in Excel 2019)

Please follow the steps below to add the Gridlines to a Chart: