How to Create Stacked Bar Chart with Negative Values in Excel

Method 1 – Create a 2-D Stacked Bar Chart with Negative Values

Step 1: Insert Stacked Bar Chart

Select range C5:F10, go to the Insert tab >> Charts group >> Insert Column or Bar Chart group >> 2-D Stacked Bar.

Select the 2-D stacked bar to Create Stacked Bar Chart with Negative Values in Excel

You will get the following chart where the positive numbers are stacked on the right side of $0.00 and the negative values are on the left side.

Raw 2-D stacked bar

Step 2: Format the Stacked Bar Chart

Click on the Legend of your Bar Chart, go to the Chart Filters option.

Formatting the Stacked Bar Chart

Click on the Select Data option.

Select Data option for Formatting the Stacked Bar Chart

You will get a Data Source Wizard.
Click on Series1 and click on the Edit button to change your Legend name.

Change the legend for Formatting the Stacked Bar Chart

In the dialog box, select D4 as your Series name and press OK.

write the series name for Formatting the Stacked Bar Chart

Your first Legend will be changed to Revenue (Billions).

write the series name for Formatting the Stacked Bar Chart

Follow the same process to change the other two legends. You will have three Legend names as shown below.
Press OK.

write the series name for Formatting the Stacked Bar Chart

After changing your Chart Title to “Stacked Bar Chart”, you will get a chart as shown in the following image below. You can rename the chart title based on your requirements.

2-D stacked bar chart in excel

Method 2 – Construct a 100% Stacked Bar Chart with Negative Values

Step 1: Generate a 100% Stacked Bar Chart

Select range C5:F10, go to the Insert tab >> Charts group >> Insert Column or Bar Chart group >> 2-D 100% Stacked Bar.

using 100% stacked bar chart feature to Create Stacked Bar Chart with Negative Values in Excel

You will get a raw chart as shown below. We can see that the values in the X-axis are given in percentage scale.

100% stacked bar chart with Negative Values in Excel

Step 2: Format the 100% Stacked Bar Chart

Follow the steps from Method 1 to format the chart.

The final output will be as shown in the following image.

100% Stacked Bar Chart with Negative Values in Excel

Method 3 – Build a 3-D Stacked Bar Chart with Negative Values

Step 1: Generate 3D Stacked Bar Chart

Select range C5:F10, go to the Insert tab >> Charts group >> Insert Column or Bar Chart group >> 3-D Stacked Bar.

using 3-d stacked bar chart feature to Create Stacked Bar Chart with Negative Values in Excel

You will have a 3D Stacked Bar Chart as shown in the following image.

3-d Stacked Bar Chart with Negative Values in Excel

Step 2: Format the 100% Stacked Bar Chart

Follow the formatting steps of Method 1 and you will get an output as shown below.

excel stacked bar chart negative values

You can also use categories in reverse order to move your X-axis data to the top.

Click on the Y-axis data of your chart, Right-click on your mouse.
Select the Format Axis option.

using format axis feature

On the right side of your Excel interface, a wizard will show up.
Select Categories in reverse order as your Axis position.

select categories in reverse order to create Stacked Bar Chart with Negative Values in Excel

The x-axis data will be moved to the top of the chart.

3d Stacked Bar Chart with Negative Values in Excel

How to Create Excel Chart Showing Negative Values as Positive

Select your range of data, D5:F10 for instance.

select the range of data

Right-click and choose the Format Cells option.

Select the format cells

In the Format Cells window, select Custom from the Number. Enter the following format code to the Type:

#,###;(#,###)

Click OK.

Enter the custom code

You will get a list of data where negative values are enclosed by the first bracket.

List of negative data showing as a positive value.

To create your chart, select range D5:F10, go to the Insert tab >> Charts group >> Insert Column or Bar Chart group >> Stacked Column.

Create Excel Chart Showing Negative Values as Positive