Click the Edit button. Enter the new name in the Series name box. Enter the Series values if required. Click the OK button. Open up the Excel spreadsheet where you can find the desired chart.

Splitting data into multiple columns isn't the only way to rearrange data in Excel. For example, you could merge data from two columns into one column, split alternate rows into two columns, or ...

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.

Figure 2: Select the tables you want to import into Excel from the website in the dialog box. When you have selected the tables that you want to import into Excel, click Import. When the Import Data ...