Make the plot area of your column chart better – How to

Make the plot area of your column chart better – How to

Introduction

How to make the plot area of your column chart better.

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.

The Steps

Step 1: Format the data series
Step 1:
  1. Right-click on the column series. The shortcut menu appears.
  2. Select Format Data Series… from the shortcut menu. The Format Data Series box opens.
How to make the plot area of your column chart better - Success!
  1. 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.

Success!

Success!

So, did it work out for you? Pretty easy, huh! But, the chart looks even better than before.


Related

If you want to see all the Excel lessons, then click on the first button below.


Excel lessons  Education home  Techronology home