How to Center a Chart in Excel (2 Useful Methods)

To apply this If you are looking for how to center a chart in Excel, then you are in the right place. In our practical life we often need to make charts and after that center the charts to use them perfectly. In this article, we’ll try to discuss how to center a chart in Excel.


Download Practice Workbook


2 Ways to Center a Chart in Excel

Excel offers a limited way to center charts. To show this, firstly we have prepared a dataset named Sales in Different Branches. It has column headers as Item Name/Branch Name. The dataset is like this.

how to center a chart in excel

Let’s see the ways to center a chart in Excel.


1. Utilizing Format Data Series to Center a Chart in Excel

We can use the Format Data Series window to center charts. To apply this Format Data Series window, we can use the following dataset of Utilizing Format Data Series.

how to center a chart in excel using format data series

Our first task is to create the chart.
To do this, firstly, select the whole dataset > go to Insert tab > Insert Column or Bar Chart dropdown > select 2-D Clustered Column option.

how to center a chart in excel using format data series

Eventually, a chart will appear like this. Here the chart bars are not centered with the bar titles.
Secondly, double-click on any bar on the chart. In this case, we have double-clicked the bar of Vegetables.

how to center a chart in excel using format data series

Consequently, a Format Data Point window will appear.
Thirdly, change the Series Overlap to 100% and press ENTER.

how to center a chart in excel using format data series

As a result, we’ll see that the width of the bars has been increased and all the bars are centered on the bar titles.
Fourthly, change the Chart Title to Center Chart Using Format Data Series.

how to center a chart in excel using format data series

Read More: How to Align Shapes in Excel (5 Simple Methods)


2. Using a 2-D Stacked Column Chart to Center a Chart in Excel

We can center the chart if we use a 2-D Stacked Column chart directly. We need to add that chart to the following dataset of Using 2-D Stacked Chart.

how to center a chart in excel using 2-D Stacked Column chart

Firstly, select the whole dataset > go to Insert tab > Insert Column or Bar Chart dropdown > select 2-D Stacked Column chart.

how to center a chart in excel using 2-D Stacked Column chart

Consequently, our chart will look like this.
Importantly, here the bars are auto-centered to the bar titles.

how to center a chart in excel using 2-D Stacked Column chart

Secondly, change the Chart Title to Center Chart Using 2-D Stacked Chart.

how to center a chart in excel using 2-D Stacked Column chart


Similar Readings


Alignment of Two Charts in Different Positions

We can align two charts in different positions using specific steps. The alignment can be done on the top, bottom, left, right, center, and so on. We need to apply those techniques in the following dataset.

how to center a chart in excel, alignment of chart

Firstly, we have made two charts of the above dataset named Alignment of Chart 1 and Alignment of Chart 2. We can see that the two charts are not aligned properly.

how to center a chart in excel, alignment of chart

Secondly, select the first chart > hold the CTRL key and select the second chart > go to Shape Format > click Align.
Different Alignment options will appear. We just need to select any of them according to our requirements.
Thirdly, for Top Alignment, select Align Top.

 alignment of chart

Eventually, the two charts will Align Top like this.

 alignment of chart

Similarly, we can align the two charts at the bottom by selecting the Align Bottom option.
Again, suppose we have the two charts which don’t have alignment on the sides and we want to align these charts on the left side.

 alignment of chart

To do this, after going to the Align option, select Align Left.

 alignment of chart

Consequently, we’ll see the left alignment of charts like this.

 alignment of chart

Similarly, we can Align Right or Align Center or Align Middle by following the same procedure.

Read More: How to Left Align in Excel (3 Handy Ways)


Things to Remember

  • In the first method, while selecting the bars to open a Format Data Point window, we need to double click the bar. Otherwise, this window will not open.
  • In the second method, by choosing the 2-D Stacked Column bar, the Series Overlap in the Format Data Point window will become 100% automatically, so there is no need to change it manually.

Conclusion

We can center any kind of chart in Excel if we study this article properly. Please visit our official Excel learning platform ExcelDemy for further queries.


Related Articles

Towhid

Towhid

Name: MD SHAJRATUL ALAM TOWHID Date of Birth: 6th September 1996 Religion: Islam Nationality: Bangladeshi

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo