This tutorial provides a step-by-step example of how to create a chart in Excel and ignore blank axis labels.
Step 1: Enter Data with Some Blank Values
First, let’s enter the following dataset into Excel that contains some blank values for the axis labels:
If we highlight this range of data and insert a bar chart, the x-axis will have several blank values:
Step 2: Modify the Data to Remove Blank Values
In this step, we’ll create a new dataset that removes all of the blank values from the original dataset.
First, type the following formula into cell D2:
Then drag the formula down to the other cells in column D until you encounter a blank value:
Next, type the following formula into cell E2:
Then drag the formula down to the remaining cells in column E:
We have successfully created a new dataset that contains only the rows where the value in the original “Store” column is not blank.
Step 3: Create the Chart with No Blank Axis Labels
We can now highlight the cells in the range D2:E6, then click the Insert tab along the top ribbon, then click the icon called Clustered Column within the Charts group:
Notice that the x-axis of the chart contains no blank labels since we used the modified dataset to create this chart.
The following tutorials explain how to perform other common tasks in Excel: