{"id":3034,"date":"2018-09-22T15:53:22","date_gmt":"2018-09-22T15:53:22","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3034"},"modified":"2024-04-12T09:44:44","modified_gmt":"2024-04-12T09:44:44","slug":"chart-ignore-blank-cells","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/chart-ignore-blank-cells\/","title":{"rendered":"Chart Ignore Blank Cells in Excel"},"content":{"rendered":"\n
When you create a chart, sometimes you will find blank cells in rows. If you insert a line chart there your data won\u2019t appear the way you intend. The chart will show no data at all.<\/p>\n\n\n\n
In order to ignore blank cells, you have to do the following.<\/p>\n\n\n\n