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

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

What Is the Advantage of Using the Chart Function in Excel?. Microsoft Office's Excel application allows users to store, model and manipulate data sets.

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

Microsoft Excel makes great charts, but often they’re not eye-pleasing. Learn how to change formats to yield a professional-looking chart.