Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Add or remove a secondary axis in a chart in Excel - Microsoft …
When the values in a chart vary widely from data series to data series, you can plot one or more data series on a secondary axis. A secondary axis can also be used as part of a combination chart when you have mixed types of data (for example, price and volume) in the same chart.
Add a data series to your chart - Microsoft Support
Add a data series to a chart on a separate chart sheet. If your chart is on a separate worksheet, dragging might not be the best way to add a new data series. In that case, you can enter the new data for the chart in the Select Data Source dialog box.
Create a relationship between tables in Excel - Microsoft Support
You can create a relationship between two tables of data, based on matching data in each table. Then you can create Power View sheets and build PivotTables and other reports with fields from each table, even when the tables are from different sources.
Learn to combine multiple data sources (Power Query) - Microsoft …
Use Power Query's Query Editor to import data from a local Excel file that contains product information, and from an OData feed that contains product order information. You perform transformation and aggregation steps, and combine data from both sources to produce a Total Sales per Product and Year report.
Import and analyze data - Microsoft Support
You can use Power Query (formerly called Get & Transform) experience to connect to multiple data sources, then use the Query Editor to shape and transform data. Power Query for Excel Help. About Power Query in Excel. Import data from external data sources. Refresh an external data connection in Excel. How data journeys through Excel
Work with a List, Record, or Table structured column (Power Query ...
Table Stores a table that has a secondary relationship with the current data, which is the primary table. A value of Table in the cell indicates a one-to-many relationship with the current or primary table.
Edit titles or data labels in a chart - Microsoft Support
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
Tutorial: Import Data into Excel, and Create a Data Model
In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share.
Use sparklines to show data trends - Microsoft Support
Learn how to use sparklines to show data trends and visually represent your data within a cell of an Excel worksheet.
Change the scale of the vertical (value) axis in a chart
When a chart displays a secondary vertical (value) axis, you can also change the scale of that axis. For more information about displaying a secondary vertical axis, see Add or remove a secondary axis in a chart.