Excel inserts a chart that does not yet track your data correctly. Right-click on the chart. Click "Select Data" to open the Select Data Source dialog box.

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).

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

Excel 1. Open Microsoft Excel on your PC or Mac. 2. Open the document containing the data that you'd like to make a pie chart with. Click and drag to highlight all of the cells in the row or ...