Select Insert from the menu, and in the charts group, select the type of chart you want to add to the report sheet. In the Chart Design menu, in the Data group, select Select Data.

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

To add data labels, select the chart, navigate to the Chart Design tab, and click Add Chart Element > Data Labels > Outside End. In our example, the numeric labels appear at the top of each column.

Charts in Excel can also be altered after they have been initially generated, by selecting a chart and choosing from the available options to amend the chart type, data or other details.

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

Select "Chart Filters," and then choose "Select Data" to open the Select Data Source dialog box. Select the series in the Legend Entries (Series) box, and then click "Edit" to open the Edit Series ...

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.

When you create a bubble chart in Excel, you do not select the labels, as Excel would not know what to do with them. Instead, you need to add the chart labels after you create the chart.