<

How To Make a Graph with Microsoft Access

Posted on
6,722 Points
122 Views
1 Endorsement
Last Modified:
Experience Level: Beginner
8:01
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formatting, chart type, titles and legend.

"A picture is worth a thousand words"

Video Steps

1. Make a query to show what you want on the X-axis (Category) and Y-axis/es (Values)

2. Create a Chart object on a form or report using the Chart tool

3. Follow wizard steps, but don't worry about the data

4. Set the RowSource for the chart object to be the data that you want

5. Resize and Format the chart -- and set/change other properties such as text for Title(s)

6. To progammatically modify the chart, watch the next video in this series, 'Manipulate Graphs in Microsoft Access using VBA'.

1
Comment
0 Comments

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Join & Write a Comment

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month