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 ...

To enter the series 1, 2, 3, and so on as we did earlier, type 1 into a cell. Click in this cell, click the Home tab on the Ribbon toolbar, and click Fill, Series.

Launch Excel. Enter data into the spreadsheet or use an existing one. Right-click any of the bars in the chart and select Format Data Series. Click the Fill and Line tab.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.