资讯

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.
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.
You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.
Select the two sets of data you want to use to create the graph. Choose the "Insert" tab, and then select "Recommended Charts" in the Charts group.
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.
How to Hide Empty Data in Excel Graphs. If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data.