The values are so close that some lines obscure the others, which is misleading. Although you can’t see all of the lines, they’re there. Multiple-line chart: This is a messy chart enlarging it doesn’t improve its readability.The months with a zero display only two “stacks” because the Minimum column also returns zero for those months. Stacked bar chart: Shows four stacks for the months without a zero value.Line chart: Drops to zero on the X-axis.If you turn on data labels, you will see the zero listed. Pie chart: It charts the zero, but you can’t see it.Right now, the charts display zero values by default in each chart type: This setup simplifies all the examples we’ll be reviewing in this guide:įigure A We’ll use four chart types to review the inherent behaviors that come with charting zero. The Minimum column returns the minimum value for each month, so April, May and July return zero for the minimum value. The other two charts have three data series: Vendor 1, Vendor 2 and Vendor 3. The pie and single-line charts reflect the data in column B for Vendor 1. How do you exclude zero in data labels?įigure A shows the data and initial charts that we’ll update throughout this article.Choosing from chart settings to chart zero values.Again, you can follow along more closely by downloading our demonstration file. Excel for the web supports most of these techniques. You can do this by simply closing the file and reopening it without saving.įor this demonstration, I’m using Microsoft 365 Desktop on a Windows 1zero 64-bit system, but you can also use earlier versions of Excel. If you work through the instructions with our demonstration workbook file, undo each solution before you start the next. Depending on how much charting you do, you might find more than one of these methods helpful. In this tutorial, I’ll review a few methods for handling zero values that offer quick but limited results with minimal effort. Microsoft 365: A side-by-side analysis w/checklist (TechRepublic Premium) When you don’t want to display zero values, you have a few choices for how to hide or otherwise manage those zeros. On the other hand, there will be times when you won’t want to draw attention to a zero. A drop to zero in a chart can be abrupt, but sometimes, that’s what you want. The steps are similar to what Susan Harkins describes in the following tutorial.Ĭharting zeros isn’t wrong, but you won’t always want to display them in your Excel charts.
For this demo, he uses Microsoft Office 365. Editor’s note: In the video, Brandon Vigliarolo walks you through a couple of ways for suppressing 0 values in Excel charts.
0 kommentar(er)
