Then the blank cells have been ignored in the chart.
Then keep the formula cells selected, click Insert tab, and insert a chart as you need in the Charts group. Select a blank cell next to the values you want to create chart by, and type this formula =IF(ISBLANK(B2),#N/A,B2), B2 is the cell you use, and drag auto fill handle down to the cells you need to apply this formula. To skip blanks directly in a chart, you need a formula before creating the chart.ġ. Click OK > OK to close dialogs, and the blank cells have been displayed as zeros. Then in the Select Data Source dialog, click Hidden and Empty Cells, and in the Hidden and Empty Cells Settings dialog, check Zero option. After creating the chart by the values, right click at the chart and click Select data form the popped context menu. To display blank cells as zeros in chart, you just need to check an option after creating the chart.ġ.
#Why pareto chart option will not show in excel for mac how to#
In this article, I will talk about how to skip the blank cells while creating a chart in Excel. If there are some blank cells in a list, the relative chart of the list will be shown as below screenshot which is not pleasing to the eye. How to skip blank cells while creating a chart in Excel?
0 kommentar(er)
