Add Primary Major Horizontal Gridlines To The Clustered Column Chart
A clustered column chart is a type of chart that displays data in columns that are clustered together. It is commonly used to compare data across categories. The chart is made up of vertical bars that represent the values in each category, and the bars are clustered together to make it easy to compare values between categories. However, the clustered column chart can be difficult to read if there are no gridlines. In this article, we will show you how to add primary major horizontal gridlines to the clustered column chart to make it easier to read.
Step 1: Create a Clustered Column Chart
The first step is to create a clustered column chart. To do this, select the data you want to use in your chart and click on the Insert tab. Then, click on the Column chart button and select the Clustered Column chart option from the drop-down menu. The chart will be added to your worksheet.
Step 2: Select the Chart
The next step is to select the chart. Click on the chart to select it. You should see a set of boxes appear around the chart indicating that it is selected.
Step 3: Display the Chart Tools
The Chart Tools will only appear when you have a chart selected. Click on the Chart Tools tab to display the tools.
Step 4: Add Primary Major Horizontal Gridlines
The final step is to add primary major horizontal gridlines. Click on the Layout tab in the Chart Tools. Then, click on the Gridlines button and select Primary Major Horizontal from the drop-down menu. The primary major horizontal gridlines will be added to the chart.
Conclusion
Adding primary major horizontal gridlines to a clustered column chart can make it easier to read and compare data across categories. By following the steps outlined in this article, you can easily add primary major horizontal gridlines to your chart. Give it a try and see how it improves the readability of your chart.