The charting engine in Access is the same as that used in Excel -- the user interface, however, is not as intuitive -- mainly because it is not as clear how to change the data. I have a video playlist for using graphs in Access that shows how to create a chart as well as change it using VBA.
Graph with Access!
How to create a chart and how to change it with VBA
http://www.youtube.com/watch?v=YhgNX6BWWmk&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0
How to create a chart and how to change it with VBA
http://www.youtube.com/watch?v=YhgNX6BWWmk&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0
Warm Regards,
Crystal
Contact Template for Access
http://msaccessgurus.com/Contacts.htm
http://msaccessgurus.com/Contacts.htm
*
(: have an awesome day :)
*
On Thursday, October 23, 2014 8:53 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Based on the minimal information you supplied, I would suggest using Excel connected to your Access tables.
Duane Hookom MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Oct 2014 20:42:37 -0700
Subject: [MS_AccessPros] How to create graph based on selected field in the form?
Hello,
Currently I am creating engineering database using MS Access 2007. User can select model and all specification of the respective model will be shown. I am using combo box and sub form for that application.
I also want to create a function that the user can select any specification and compare between the models in form of graph.
I should using VBA codes or simply use pivot chart?
Thank you for your help and guidance.
Duane Hookom MVP
MS Access
From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Wed, 22 Oct 2014 20:42:37 -0700
Subject: [MS_AccessPros] How to create graph based on selected field in the form?
Hello,
Currently I am creating engineering database using MS Access 2007. User can select model and all specification of the respective model will be shown. I am using combo box and sub form for that application.
I also want to create a function that the user can select any specification and compare between the models in form of graph.
I should using VBA codes or simply use pivot chart?
Thank you for your help and guidance.
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar