How To Remove Gridlines In Excel Graph

To make the data in a chart/graph easier to read, it helps to add together horizontal and/or vertical gridlines.

Gridlines are lines that get horizontally and vertically across your chart plot to prove divisions in the chart axes (below is a chart that shows horizontal gridlines).

These gridlines usually marshal with points on the chart's axes, so it is easier to trace the value respective to a point on the graph.

They are particularly helpful when you have large and complicated charts, or when data points on the chart are unlabeled.

Excel lets you brandish 3 kinds of gridlines:

• Horizontal gridlines
• Vertical gridlines
• Depth gridlines (for 3-D charts)

Gridlines can also be displayed for both major and minor units.

Those that align with major tick marks on the axes are called major gridlines. Minor gridlines dissever the units defined by the major gridlines and as such let yous mark the finer details in your chart.

In this tutorial we volition testify you how to add major and small gridlines to your nautical chart and how to format them:

• Using the Nautical chart Elements button
• Using the Nautical chart Tools carte du jour

We will likewise show you how you can hide or remove gridlines from your nautical chart if you lot need to.

• Two Ways to Add together and Format Gridlines in Excel
  • Method 1: Using the Chart Elements Button to Add and Format Gridlines
    • Adding the Gridlines
    • Formatting the Gridlines
    • Editing the Gridlines
  • Method 2: Using the Chart Tools Menu to Insert and Format Gridlines
• Removing Gridlines in Excel

Ii Means to Add and Format Gridlines in Excel

Let's say you take the following chart:

Discover that without gridlines it's hard to tell what value each of the bars corresponds to.

And so nosotros need to insert some gridlines into the chart to make information technology easier to read the values the bars represent.

Of class, you have the choice to add together data labels as well, but in many cases, having too many data labels can make the chart wait cluttered. And then having gridlines can exist useful in such cases

Let us at present see two ways to insert major and minor gridlines in Excel.

Method 1: Using the Chart Elements Button to Add and Format Gridlines

The Chart Elements button appears to the right of your chart when information technology is selected.

This button allows you to add, change or remove nautical chart elements similar the championship, legend, gridlines, and labels.

Here's what the button looks like:

Adding the Gridlines

To add the gridlines, here are the steps that you need to follow:

1. Click anywhere on the chart
2. Click on the Chart Elements button (the ane with '+' icon).
3. A checklist of chart elements should announced now. Make certain that the checkbox next to 'Gridlines' is checked.

4. This will brandish the major gridlines on your chart.
5. When you hover over the Gridlines checkbox, yous volition notice a small arrow to its right, as shown below.

6. Click on this arrow to see additional options for the gridlines. These include:

• Primary Major Horizontal – select this if you desire to display major horizontal gridlines
• Primary Major Vertical – select this if you want to brandish major vertical gridlines
• Main Modest Horizontal – select this if you lot want to display small-scale horizontal gridlines
• Primary Minor Vertical – select this if you want to display modest vertical gridlines
• More Options – select this selection if you want to format the gridlines.

Select checkboxes next to the gridlines that you lot desire to brandish on your chart.

Formatting the Gridlines

Select 'More than Options' if you desire to format the gridlines.

This will open a sidebar to the right of the Excel window that lets yous format your chart elements. Format your selected gridlines as you lot see fit.

Once you're done, y'all can close the sidebar.

Editing the Gridlines

The next time you demand to edit the gridlines, double-click on the axis corresponding to the gridlines that you lot desire to alter.

For case, if you want to modify the horizontal gridlines, double-clock on the x-axis.

In other words, select the axis that is perpendicular to the gridlines that you want to change.

This will open the Format Centrality sidebar to the right of the Excel window.

Select the dropdown pointer next to 'Centrality Options'. Select the gridlines option that you want to change. For example, if yous want to alter the format for the major horizontal gridlines, select the 'Vertical (Value) Axis Major Gridlines' option.

Hither, you lot'll find two tabs:

• Fill & Line : This tab lets you ready the outline and fill colour/pattern of the selected gridlines.

• Effects : This tab lets you prepare furnishings similar Shadow, Glow and Soft Edges to the selected gridlines.

Use the tabs to change your gridline formats to whatsoever you lot need.

Note: If you want to run across or change the number of gridlines displayed on your nautical chart, you lot can take a expect at the Major and Pocket-sized input boxes (under the Units category of the Axis Options tab). Effort increasing or decreasing these numbers to change the number of gridlines displayed.

Method 2: Using the Chart Tools Menu to Insert and Format Gridlines

The Chart Tools ribbon can be seen in the main menu when you click on your chart. This carte consists of ii tabs – Design and Format.

So, a second way to add and format gridlines is to use the Pattern tab from the Chart Tools. Here's how:

1. Click on your nautical chart.
2. You should see the Chart Tools menu announced in the main menu.
3. Select the Blueprint tab from the Chart Tools menu.
4. Click on 'Add Chart Element' (under the 'Chart Layouts' grouping).

5. A dropdown menu should appear, with different chart element options.

6. Hover over 'Gridlines'.

7. A submenu consisting of different options relating to gridlines should appear. Select the type of gridlines that you want to add. You lot can add more than one type of gridlines in your chart.

8. The gridlines should now appear on your chart.

Note: Notice the vertical axis is categorical and basically has no minor divisions. So fifty-fifty though there is an option to display minor vertical gridlines, they will not show on this chart when selected. Modest divisions don't make sense for category axes.

Removing Gridlines in Excel

To remove gridlines, follow the steps demonstrated below:

1. Click anywhere on the chart.
2. Click on the Nautical chart Elements button.

3. If you want to remove all the gridlines, and then uncheck the box next to 'Gridlines'.

4. If you desire to remove a specific gear up of gridlines, and then hover over the Gridlines checkbox.
5. Click on the small arrow to its right.

6. Uncheck the box next to the gridlines that yous want to remove/ hide.

Hither's what the chart would await like with the only minor horizontal gridlines removed:

Another quick way to remove gridlines (or any chemical element in an Excel chart) is to select them and hitting the delete push button. In the case of gridlines, you volition see that all the gridlines have been selected (and hitting the Delete button will only delete the ones that were selected.

In this tutorial, we showed you ii ways to add and format gridlines in Excel.

Nosotros likewise showed y'all how to quickly remove the specific gridlines and what to practise if yous want to edit the formatting of gridlines s(like color, style, etc.)

We hope this tutorial was useful for yous and easy to follow.

Other Excel charting tutorials yous may also find useful:

• How to Insert Chart Title in Excel?
• How to Create Bar of Pie Chart in Excel?
• How to Movement a Chart to a New Sheet in Excel
• How to Print Gridlines in Excel (3 Like shooting fish in a barrel Ways)
• How to Make Box Plot (Box and Whisker Nautical chart) in Excel?

Source: https://spreadsheetplanet.com/add-gridlines-in-chart-excel/

Posted by: clarkcasits.blogspot.com

Share this post