资讯

How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers. You can give spreadsheet ...
Microsoft Excel 2010 does not plot hidden rows or columns, so you need to hide the empty rows or columns. Strangely, in Excel 2010, unhiding the data is easier than hiding it.
You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.
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.
Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.
Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.