This content is part of one or more learning paths. To unlock, use the Enroll button to enroll in a learning path.
Do you want to know how to programmatically change graphs and charts in Access? This 19-minute video shows how to use VBA to drive charts from a menu form that collects criteria, change data for the graph, set the chart title, x-axis title, and modify scales and formats. To download the database example, go to www.msAccessGurus.com then Free Tools then Graphing in Access.
The menu form is called f_Graph_MENU. It has a button ("Chart") that runs VBA code and opens the graph. The time frame can be changed from Days to Weeks to Months. Appearance is changed by setting format. How data looks and what data is being displayed is based on criteria such as a possible start date or date range. On the right are other properties that are read when the graph is rendered such as Chart Title, format for X and Y axes, X-Axis Title, and Minimum and Maximum Scale for the Y-Axis.
The f_Graph form has what is now called the Microsoft Graph Chart control, and has code behind the form to change where the data comes from and how it looks.
The f_PopupCalendar form is for collecting dates and generally triggered by double-clicking a control with a date. If a date OpenArg is sent, the starting calendar date can be specified if the control has no value.
The sample tables are called t_GraphData and t_GraphTopics.
The qGraph query is the RowSource for the Microsoft Graph Chart control. By defining a query and then modifying the SQL for the query before the chart is opened, you can get exactly what you want.
you also may be interested in
How To Make a Graph with Microsoft Access
if you want to show graphs and symbols in queries, watch:
Show Bar Graphs! in Access Query using Unicode characters
Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too
Subscribe to find out when I post more videos
... and please Like, Comment, and Share ~ thank you
Access analysis Data Data Mining database projects data tools Graphics Improving User Experience Microsoft Access Microsoft Office Microsoft Office 2010 MVP Programming SQL User Experience User Interface VB6 VBA Visual Basic office 2007 Power Users Office
You need to click Enroll to unlock the Learning Path courseware.
You are now enrolled in this learning path. Use the Launch Course or Launch Assessment buttons below to access the courseware.
|Para acceder a este contenido, necesitará un código de acceso. Si tiene un código de acceso, ingreselo aquí y haga clic en Enviar.|
|Palabra clave: Buscar|
|No se encontraron elementos.|