<\/figure>\n\n\n\nThe chart is displayed:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nSelect and delete the blue series<\/strong> which show the increasing and decreasing percentage<\/strong> values so that we remain only with the series that express the positive and negative values<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nModify and Refine the Chart<\/h2>\n\n\n\n The following are some of the things we can do to make the chart appear just the way we want it:<\/p>\n\n\n\n
\nRight-click on the Axis Labels<\/strong> and select Format Axis\u2026<\/strong><\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Format Axis<\/strong> pane that pops up, check the Categories in reverse order <\/strong>checkbox and select Low<\/strong> in the Labels Position<\/strong> drop-down list:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe chart will be displayed as follows with the order of categories reversed and the labels moved away from the axis:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nOn the chart elements remove the horizontal or the X-axis<\/strong> by unchecking the checkbox next to Primary Horizontal<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRemove the vertical grid lines by unchecking the checkbox next to Primary Major Vertical<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRight-click on any data series<\/strong> and choose Format Data Series\u2026<\/strong> from the context menu<\/strong> that pops up:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Format Data Series<\/strong> pane, adjust the Series Overlap<\/strong> to 0% and the Gap Width<\/strong> to 30% or another percentage that suits your situation.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe chart now looks as follows:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nRight-click on the negative series and click Add Data Labels >> Add Data Labels<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe negative percentage labels are displayed next to the negative series as shown below:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nRight-click on the positive values series and select Add Data Labels >> Add Data Labels<\/strong> from the context menu that comes up:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe chart now appears as below:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nSelect each of the #N\/A values <\/strong>and delete them so that the chart now looks as below:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nAdd the horizontal grid lines by clicking Gridlines >> Primary Major Horizontal <\/strong>on the Chart Elements dialog box:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe final Excel chart with positive and negative numbers<\/strong> finally looks like the one below:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe can use the Chart Elements<\/strong> feature to adjust other chart elements such as adding the chart title, axes titles, legend, series colors, and so on.<\/p>\n\n\n\nConclusion<\/h2>\n\n\n\n In this tutorial, we have covered all the steps we need to take to come up with an Excel chart with positive and negative numbers<\/strong>.<\/p>\n\n\n\nThe first step is to ensure that our data is laid out correctly. This is achieved by adding helper columns to our data set and arranging it in such a way that we have a column that contains the positive values and another that contains the negative values.<\/p>\n\n\n\n
The next step is to generate the chart we want. We used a clustered bar chart<\/strong> in our tutorial because it is used to compare values across a few categories.<\/p>\n\n\n\nThe final step is to adjust and modify the chart <\/strong>so that it looks exactly the way we want it.<\/p>\n\n\n\nThe process of creating an Excel chart with positive and negative numbers<\/strong> can be challenging at first and time-consuming but it becomes easier with practice.<\/p>\n","protected":false},"excerpt":{"rendered":"Sometimes you may want to create an Excel chart based on a dataset that has positive and negative numbers. In this tutorial, we…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Chart with Positive and Negative Numbers in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n