From the course: Access 2016: Forms and Reports

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Display a chart

Display a chart

From the course: Access 2016: Forms and Reports

Start my 1-month free trial

Display a chart

- [Voiceover] The chart control can give insights into your business's metrics by presenting a dynamic graphical view of your data that changes as your database grows. Unlike exporting data to Excel and graphing there, creating your graphs directly in Access maintains the live, always updated link to your data tables and queries. Further, pairing a chart with a query gives you all of the flexibility of adding query criteria to instantly refine the chart's data set. In this movie, we're going to create a chart object, and in the next movie, we'll bring this chapter full circle and incorporate some of the other form controls that will take user inputs to alter the chart's parameters. Now I'd like to mention up front that the chart object uses a rather old interface called Microsoft Graph, and it hasn't been updated in quite a few versions. They can be a little bit wonky to use, and it might take a few tries to get something usable. So with that caveat out of the way, let's go ahead and…

Contents