From the course: Access 2019: Building Dashboards for Excel

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Build PivotCharts

Build PivotCharts

- [Instructor] If you build pivots and you're building dashboards, then you're likely going to build some pivot charts. Let's build some into our dashboard file. Okay, so let's go to our department minutes and averages and let's start here. This data is perfect, perfect for a combo chart. So I'll go to my insert tab, I'll go to pivot chart and I'll choose pivot chart. And then I'll go to my combo, and I see my total minutes as a clustered column and then my average minute, okay? So this would be better on my secondary axis, perfect. So now I can see the total minutes consumed by each department and then the average amount of time that they spend. All right, I'll go ahead and click okay. And perfect. Now I want to move my legend, so up top, I'm going to go to the design. I'll go to my chart elements, I'll go to my legend, and I'll display it across the bottom. Okay? Go ahead and go over to my manager minutes…

Contents