Learn how to ignore zero values in Excel charts with step-by-step tips to create clean, accurate, and professional visuals. Skip to content ... The stacked bar chart plots zero values.

A typical bar chart would start a 0 for each person, but we want to chart both values. By starting each bar at the minimum point on the Y axis, you create what appears to be floating bars.

How to Make a Graph in Excel With Word ... Adding a Series to an Excel Chart. Microsoft Excel 2013 charts are ... How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?.

Click on the type of bar graph you want. The graph menu will disappear as your graph is now part of your document. 7. To change the title of your graph, click on "Chart Title" at the top of the chart.