Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 open, there's a toggle button up on the upper left-hand side of the grid. Pick up your product and drag it down to the bottom where it says Drop Category Fields Here.
Then drag Size right down next to it. You will see a little dark blue bar and I'll drop it. Now drag your Order Totals to the top header where it says Drop Data Fields Here. Now, you can see how many of each bottle you have sold. I can instantly see that my 32 ounce bottles of Light Olive Oil are far and away my bestseller. This new analysis will be saved right with the query. So once you saved it you can now switch back and forth between your views from Design View to Datasheet View to PivotChart View.
Look at the difference before and after. Creating a PivotChart from your query will allow you to do a visual analysis anytime making it easy to interpret your query results.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97595 Viewers
80 Video lessons · 141082 Viewers
59 Video lessons · 59430 Viewers
52 Video lessons · 72750 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.