# How to Add the Grand Total to a Bar Chart in Excel – Easy Steps

The sample dataset showcases 4 different products and their sales in 3 quarters.

### STEP 1: Insert a Spacing and a Grand Total Column

• Insert 2 extra columns.
• In the first column (Spacing), enter 10,000 for every product.

In the Grand Total column, add the sales to find the total:

• Select G5.
• Enter the formula:
=SUM(C5:E5)
• Press Enter.
• Use AutoFill to see the sales summation of other products.

### STEP 2 – Insert a Bar Chart in Excel

• Select B4:F8.

• Go to Insert ➤ Insert Column or Bar Chart ➤ 2-D Stacked Bar Chart.

• The bar chart will be displayed.
• Click the chart.
• Select Chart Design ➤ Switch Row/Column.

• This is the output.

### STEP 3 – Modify the Bar Chart to Add the Grand Total

• Right-click Quarter 1.
• Repeat the steps for the other parts of the chart.

• Data labels will be displayed.

• Right-click Spacing (10,000).
• Select Format Data Labels.

• In the Format Data Labels pane, choose Inside Base in Label Position.
• Check Value From Cells in Label Options.

• In the dialog box, choose the Grand Total range in Select Data Label Range.

• Click OK.
• This is the output.

• Rght-click Spacing.
• Choose No Fill in Fill.

• Delete the y-axis lines.
• Delete the Spacing legend.

### STEP 4 – Change Spacing Column Values

To change the Spacing column values:

• Enter 0 for every product in the Spacing column.

### Final Output

• Choose a format for the Grand Total data labels.
• This is the final output.

## Related Articles

<< Go Back to Excel Bar ChartExcel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF