After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.

We can chart a regression in Excel by highlighting the data and charting it as a scatter plot. To add a regression line, choose "Add Chart Element" from the "Chart Design" menu.