Turning a query into a PivotChart


show more Turning a query into a PivotChart provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Turning a query into a PivotChart

You will use queries extensively to explore your data and you can visualize your data by turning your queries into pivot charts. Pivot charts allow you to interactively view your query results along two or more dimensions in a visual way. Let's start by understanding our scenario and our goal. I have opened my Orders table and it shows me by date what customer ordered what product, how many bottles, and their order status. And if I go over my navigation pane and down to Queries and I double-click on Order Totals, it now gives me all the same data, but it adds in the column at the end to tell me the grand total for that particular order.

When I look at it in Design View, I can see the calculation in the last column. But when I go up to the View button and I drop down the bottom half, I have some additional options. Let's take a look at the PivotChart View. When we choose it, a blank chart appears with placeholders. I have a field list here on the right. If your field list doesn't ...

Turning a query into a PivotChart
Video duration: 2m 6s 3h 43m Intermediate

Viewers:

Turning a query into a PivotChart provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...