Connect to Other Data

When you click on Choose Connection, you will see a list of data connections. By default the list shows All Connections.

 

The Existing Connections can include:

All Connections

Connections files in the Workbook

Connection files on the Network

Connection files on this computer

 

If you don't see you data source listed, you can Browse for More.

 

2. Try it: Browse for More

At the Existing Connections window.

Click on Browse for More.

Keep going...!

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Use an External Data Source

Insert-> Table-> PivotChart->Use an External Data Source