Jumat, 24 Oktober 2014

Re: [MS_AccessPros] How to create graph based on selected field in the form?

 

Crystal


Thanks for all the hard work you put into your videos. They are all terrific and "Crystal" clear. I hate graphs in Access and rarely have the call to use them (I guess it's just the nature of my applications), but even an old dog like me can learn a lot about them from you.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@yahoo.com> wrote :

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
 
Warm Regards,
Crystal

Contact Template for Access
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.




 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Tidak ada komentar:

Posting Komentar