资讯

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 ...
In this guide, you will learn how to use Histogram Charts in Excel to visualize the distribution of your data. Follow these steps to create and customize your histogram chart: ...
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.
Microsoft Excel 2013 lacks a utility for creating such control charts, but you can manually construct one by properly organizing your data.
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 ...
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.
Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.