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.

To use Excel's scenario manager function, select the cells with the information you're exploring, and then go to the ribbon and select Data. Select What-If Analysis > Scenario Manager.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Once you have your data ready, you can use Excel’s built-in charting tools to generate the Waterfall Chart. Simply select your data, go to the “Insert” tab, and choose the Waterfall Chart ...

Create an Organizational Chart With Excel's SmartArt Tool In Excel, you use SmartArt to create a graphic with an organizational chart layout.

Excel is a powerful tool for managing projects, but there's one key feature it lacks: a built-in Gantt chart. This can be frustrating for project managers who rely on Gantt charts to visualize ...

To create a variance chart, select the data range and use the Alt + F1 shortcut for a basic chart. Customize the chart by changing it to a combo chart for better visualization of different data ...

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.

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.