How To Make a Graph with Microsoft Access

Sign in to queue

Description

Do you want to know how to make a graph with Microsoft Access? The easiest way is to 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.

The trick to getting the chart to show exactly what you want is to set the RowSource for the chart object after the wizard is done.

To format the graph, double-click the chart object in the form design -- then right-click on what you want to change to get a context-sensitive menu.

Tp programmatically manipulate a chart, watch:

Change Graphs and Charts in Microsoft Access using VBA 
https://channel9.msdn.com/Blogs/MVP-Office-Dev/Change-Graphs-and-Charts-in-Microsoft-Access-with-VBA

and it you want to make bar charts for each record of a query (yes, you can do this!), watch:

Show Bar Graphs in Access Query using Unicode characters 
https://channel9.msdn.com/Blogs/MVP-Office-Dev/Show-Bar-Graphs-in-Access-Query-using-Unicode-characters

to add Triangles and Circles! watch:
https://channel9.msdn.com/Blogs/MVP-Office-Dev/Triangles-and-Circles-in-a-Microsoft-Access-Query-Get-Previous-Record-too

~~~

please Subscribe, Like, Comment, and Share 

thank you

 

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents