Adjust the Chart Series Overlap in PowerPoint 2013 for Windows
Learn how to adjust the gap between the chart data series within a single category in PowerPoint 2013.
Author: Geetesh Bajaj
Product/Version: Microsoft PowerPoint 2013
OS: Windows 7 and 8
Your PowerPoint charts can look better if they are spaced apart well. You can increase the
Gap width so that there is enough space
between the categories. Also, you can adjust the space between the individual Data Series within a category. Look at
Figure 1 below where you can see a chart with single category consisting of three Data Series. Note that all three Data
Series are placed at the center of the
Category Axis and there is little space between them,
as shown with red arrows within Figure 1.
Figure 1: Chart with single category consisting of three Data Series
Now, look at the same chart within Figure 2 where we have set the Series Overlap to -100%. As you
can notice, the chart within Figure 2 is looking more spaced out than the chart within Figure 1.
Figure 2: Chart with Series Overlap to -100%
Similar to the chart Gap width, Series Overlap is also calculated automatically by default in PowerPoint 2013 based on the chart data and the Plot Area space. However, you can manually make some changes in the gap width as required by quickly increasing or decreasing this width. Follow these steps to explore more:
- Select the chart that you want to change the Series Overlap for. If you don't have an existing chart,
insert a new chart.
- Now, carefully right-click any of the
Data Series -- from the
resultant menu, select the Format Data Series option, as shown in Figure 3. If you do not get the
Format Data Series option within the contextual menu, you might have right-clicked on another chart element -- then,
make sure you deselect anything in the chart, and then right-click on any series (for example, a single column within a column chart).
Figure 3: Format Data Series option
- This summons the Format Data Series
Task Pane, as shown in
Figure 4. Click the Series Options button (highlighted in red
within Figure 4). Here you will find the Series Overlap option (highlighted in
blue within Figure 4).
Figure 4: Series Overlap option within Format Data Series Task Pane
- You can either directly type the required Series Overlap value within the box provided, or click the up/down arrow buttons
to increase/decrease the value by 1% per click, also, you can use the slider to increase/decrease the value. Decrease the value to
increase the space between two Data Series within a category, or increase the value to make the Data Series overlap each other. In
Figure 5 the chart has the Series Overlap set to -100% whereas the chart within Figure 6 has the Series Overlap set to 0%. Compare Figures 5 and 6.
Figure 5: Chart has the Series Overlap set to -100%
Figure 6: Chart has the Series Overlap set to 0%
Figure 7 shows our sample chart with the Series Overlap set to 50% so that Data Series overlap each other.
Figure 7: Chart has the Series Overlap set to 50%
- Save your presentation often.
Have your ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?
Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences E-Book.