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!
You should read it
- How to convert negative numbers to positive numbers Excel
- SIMPLE way to format negative and positive signs in Excel
- Instructions to stamp negative numbers in Excel
- How to separate negative and positive numbers in Excel
- 6 acts are considered negative but reality is very positive
- Instructions on how to graph in Excel
- This is the difference between a positive and a negative person
- How to draw a straight line, draw an arrow in Excel
- Detailed instructions on how to graph in excel
- How to Make a Line Graph in Microsoft Excel
- How to Make a Bar Graph in Excel
- How to Add a Second Y Axis to a Graph in Microsoft Excel
May be interested
How to create List, Drop Down List in Excel
SUBTOTAL function - The calculation function for a group in a list in Excel
2 software to find and remove passwords on Word and Excel
Instructions for rounding decimal numbers after commas in Excel
Reduce the size of PDF files with Free PDF Compressor
Draw a mind map in Word