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.
Step 2: After selecting the mouse click out of the chart you already have the chart:
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:
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 .
Step 2: A dialog box appears looking for item LABELS -> move to Label Position -> click Low .
Step 3: Close the Format Axis dialog box found on the chart of the months moved downwards, clearly separated from the chart columns:
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 .
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.
Step 3: Integrate select Invert if begative to select the color for the negative column below -> click select Color color in 2nd icon.
You can create additional borders for the column values by moving down and click on Solid Line .
Choose effects for columns in a chart by going to SHADOW -> choose effects suitable for the chart.
After choosing a color, close the Format Data Series dialog box :
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 .
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 .
Click OK, you have created a note:
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 .
So with the above steps hopefully you will create a chart as desired and full of components.
Good luck!
You should read it
- 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
May be interested
- How to create List, Drop Down List in Excelthe following article shows how to create list, drop down list in excel
- SUBTOTAL function - The calculation function for a group in a list in Excelsubtotal function: a function that calculates a subgroup in a book set or a data table depending on the calculation involving the first parameter.
- 2 software to find and remove passwords on Word and Excelthis article introduces you to 2 software to find and remove passwords on word and excel.
- Instructions for rounding decimal numbers after commas in Excelthe round function in excel helps you round down decimal numbers into natural numbers without commas. so, how do you want to round decimal places after commas?
- Reduce the size of PDF files with Free PDF Compressorthe following article details how to reduce the size of pdf files by free pdf compressor.
- Draw a mind map in Worda simple way to draw mind maps is to use drawing right in word software. the following article details how to draw mind maps in word.