spot_img

Chart with negative values

What to do when you have negative values? Read this tutorial to teach yourself how to insert a chart with negative values in Excel. Select you data and go to Insert -> Insert Column Chart.

 

insert column chartClick insert column chart and select clustered column chart.
clustered column chartA graph will appear in the Excel sheet. Axis can be adjusted by right clicking on the axis and selecting format axis. (Axis adjustment shown in the next steps).

Axis adjustment

Scales can be adjusted by right clicking vertical axis and then selecting format axis. A dialog box will appear. Now adjust the vertical axis accordingly.

dialog box

You will see the changes in the graph.

chart with negative values template

Template

You can download the Template here – Download
Further reading: 
Summing only negative/positive values
How to convert negative values to positive?
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR