<

Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

How To Make a Graph with Microsoft Access

Posted on
6,986 Points
186 Views
3 Endorsements
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'.

3
Comment
1 Comment
 
LVL 34

Expert Comment

by:Subodh Tiwari (Neeraj)
You are awesome Crystal! Great video tutorial. :)
1

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Implementing simple internal controls in the Microsoft Access application.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month