Draw a bar graph with positive and negative values ​​in Excel

The following article details how to create a positive and negative column chart in Excel.

Step 1: Highlight all the data you want to create charts -> INSERT -> I nsert Column Chart -> Select the chart type you want.

Draw a bar graph with positive and negative values ​​in Excel Picture 1

Step 2: After selecting the mouse click out of the chart you already have the chart:

Draw a bar graph with positive and negative values ​​in Excel Picture 2

Edit the chart after drawing

1. Change the title of the chart

Double click on the line Chart Title -> Enter the name of the chart corresponding to the content, can choose the background color and font color for the title:

Draw a bar graph with positive and negative values ​​in Excel Picture 3

2. Edit the location of the months accordingly

Because the months on the chart below are hard to see, you should move the months down.

Step 1: Click to select the months -> Right-click and select Format Axis .

Draw a bar graph with positive and negative values ​​in Excel Picture 4

Step 2: A dialog box appears looking for item LABELS -> move to Label Position -> click Low .

Draw a bar graph with positive and negative values ​​in Excel Picture 5

Step 3: Close the Format Axis dialog box found on the chart of the months moved downwards, clearly separated from the chart columns:

Draw a bar graph with positive and negative values ​​in Excel Picture 6

3. Edit the columns showing positive and negative values

You want to distinguish positive and negative values ​​on the chart by changing the colors for the columns, negative values ​​with one color, and positive values ​​with one color. You can also change the width for columns that represent data:

Step 1: Select the columns in the chart -> Right-click and choose Format Data Series .

Draw a bar graph with positive and negative values ​​in Excel Picture 7

Step 2: Click on the Fill & Line (Color icon) -> click on the Solid Fill -> move down to choose the color for the positive chart column above.

Draw a bar graph with positive and negative values ​​in Excel Picture 8

Step 3: Integrate select Invert if begative to select the color for the negative column below -> click select Color color in 2nd icon.

Draw a bar graph with positive and negative values ​​in Excel Picture 9

You can create additional borders for the column values ​​by moving down and click on Solid Line .

Draw a bar graph with positive and negative values ​​in Excel Picture 10

Choose effects for columns in a chart by going to SHADOW -> choose effects suitable for the chart.

Draw a bar graph with positive and negative values ​​in Excel Picture 11

After choosing a color, close the Format Data Series dialog box :

Draw a bar graph with positive and negative values ​​in Excel Picture 12

4. Fill in the legend in the chart

In order for the reader to understand the entire content, you should add comments in the chart.

Step 1: Add to the data table 2 positive and negative columns and the values ​​in 2 columns are equal to 0 in 12 months -> Right click on the chart and select Select Data .

Draw a bar graph with positive and negative values ​​in Excel Picture 13

Step 2: Click the icon to select the data area. Notice the selection of the old data area and both positive and negative columns (Select both headers) -> In the Legend Entries (Series) area select the data fields that you want to note -> OK .

Draw a bar graph with positive and negative values ​​in Excel Picture 14

Click OK, you have created a note:

Draw a bar graph with positive and negative values ​​in Excel Picture 15

In case you have done the above but do not display the note you do the following:

Click on the chart-> click on the Chart Elements icon -> tick the Legend item .

Draw a bar graph with positive and negative values ​​in Excel Picture 16

So with the above steps hopefully you will create a chart as desired and full of components.

Good luck!