One way to make the plot area of your column chart better is by reducing the space between the columns. Overall, the vertical spacing of the above chart is great.
So, all we really need to do is increase the width of the columns. Thus, we will improve the spacing of this chart, in the plot area. And, that is what this quick lesson is all about.
Note: This is an Excel 2007+ lesson, which we use a Windows PC to perform all the tasks. However, feel free to follow along on any device that has Excel.
Steps to make the plot area of your column chart better
Follow the steps below to make your chart thicker and better.
Step 1: Format the data series
- Right-click on the column series. The shortcut menu appears.
- Select Format Data Series… from the shortcut menu. The Format Data Series box opens.
- Under Series Options, change the Series Overlap and Gap Width to your liking. So, we put 0% for the series overlap, and 50% for the gap width. Of course, you may need to play with it a little to get the results you want.
Afterward, your chart should look thicker and better looking.
So, did it work out for you? Pretty easy, huh! But, the chart looks even better than before.
- Add an average line to a column chart – How to
- Add data labels to a chart in Excel – How to
- Creating a basic column chart in Excel – How to
- Show developer toolbar in Excel – How to
If you want to see all the Excel lessons, then click on the first button below.