Follow the steps below on how to ignore blank cells in Excel: Select a blank cell next to the values that you want to use to create the chart and type the formula =IF(ISBLANK(C2), #N/A, C2).

Inserting a graph in Excel Step 1: You’ll need to add your data into the Excel spreadsheet, with each column having its own dedicated title. If you make a mistake with the column heading order ...

Select the two sets of data you want to use to create the graph. Choose the "Insert" tab, and then select "Recommended Charts" in the Charts group.

How to Graph Linear Lines in Microsoft Excel. Data is rarely so uniform and predictable that plotting data points creates a perfectly linear arrangement.