Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

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.

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.

You may think you already know all about them, but Excel keeps adding more, including some that can handle complex information. To experience the breadth of Excel’s data visualization offerings, let’s ...

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

Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart. Click "Select Data" to open the Select Data Source dialog box.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

Open up the Excel spreadsheet where you can find the desired chart. Then, select the chart in the spreadsheet and right-click on it. In the context menu, you will see an option called Select Data.