excel for mac line chart data labels first and last only

Click Find & Select in the Editing group on the Home tab, and choose Replace.Select the data set (in this case, it's B2:D9).Now, let's use Excel's Replace feature to replace the 0 values in the example data set with the NA() function: You'll still see the category label in the axis, but Excel won't chart the actual 0. However, that's not always practical.Įxcel won't chart #N/A! values. If the data is updated regularly, you might even enter NA() for 0s from the get-go, which will eliminate the problem altogether. Perhaps the most permanent fix is to replace literal 0 values with the NA() function using Excel's Find and Replace feature. On the other hand, if your chart is a one-time task, filtering offers a quick fix. This method is my least favorite because the chart updates, displaying the 0 values, when you remove the filter. Neither displays the 0 value or the category label. Don't worry about that (be sure to remove the filter when you're done).įigure F shows the two charts based on the filtered data in column B. Click OK to filter the column, which will filter the entire row.In Excel 2002, select Custom, choose the Does not equal option from the first drop-down, and then enter 0. Click Vendor 1's drop-down and uncheck 0.In Excel 2003, choose Filter from the Data menu. Doing so will add a filter to all of the columns, not just column B, but you can ignore all but the filter for column B. On the Data tab, click Filter in the Sort & Filter group.In Excel 2003, select the entire range, including the header row. Now, let's add a filter to the Vendor 1 column: Use it when it works, but it won't always work. Like the methods discussed above, it's a limited choice.

If you have a single data series, you can filter out the 0 values and chart the results. Simply close the file and reopen without saving. If you work through the instructions with the example workbook, be sure to undo each solution before you start the next. Your results might vary, depending on your version of Excel and your chart defaults. LEARN MORE: Office 365 Consumer pricing and features About the example dataįigure A shows the data and initial charts that we'll use throughout this article. We'll review a few that offer quick but limited results with minimum effort. When you don't want to display these values, you have a few choices, and some work better than others. Your data and the chart's purpose will guide you in this decision. The steps are similar to what Susan Harkins describes in the following tutorial.Ĭharting 0s 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.

Excel for mac line chart data labels first and last only