1. Click to enter B4 cell with 0 value, enter=NA (), and the cell will return "# N/A" error value after entering. 2. Return to view the line chart, and the 0 point will not be displayed in the chart.
Principle description: The chart will ignore the "# N/A" error value when identifying data, avoiding the situation where the value of 0 touches the X axis. 3. If the data in the rate column is generated by a formula, you can change the formula to:
=IF (original formula, original formula, NA ())
In this way, when the return value of the original formula is 0, the cell returns the "# N/A" error value.
Change the upper and lower limits of the coordinate axis Right click the ordinate area to set the coordinate axis format, upper limit and lower limit to fix the value you want
In Excel, if you want the line chart to ignore empty cells, you need to filter the data first.Click the Data tab, select Filter, and then hide or delete rows with empty values.Then, when creating a line chart, ensure that only columns with data are selected as series, so that blank cells will not appear on the chart.Remember to update the filter criteria every time you add or delete data