Sabtu, 25 Oktober 2014

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

 

thank you, Bill ~ your kind comment made my day!

adding on another 2¢ (maybe more) ... I think Access charts get a lot of bad press because it is hard to change the data they are graphing.  Another wizard or a few more dialog boxes would be nice.  Aside from RowSource*, once you have a chart object and you get inside it (double-click it in design view of the form or report that hosts it), changing things like format and style and colors works just like Excel if you rely on the right mouse button instead of the ever-changing menus and toolbars and ribbons

* the chart object is like a combobox in that it shows stuff based on a RowSource, which you can (and should, in my opinion, most of the time) change! Click on the builder button in the Property Sheet -- get EXACTLY what you want.  The wizard assumes you want to use a domain aggregate function on your data ... that is like saying EVERY query is going to be grouped ... and what percentage actually are? 

Analogous to the SourceObject of a subform object, the RowSource of a chart is defined at the control level.  Once you are inside it, unlike a subform object since you can set RecordSource there, with a chart object, there is no way to change the data (unless there is an icon you can add -- I haven't explored that).  Also, the design view shows that last thing you actually previewed even if it knows the right data.  If you haven't looked at the chart in form view or report view or print preview yet, you see sample data, which can be very confusing.

Obviously different sets of people developing features.  Manipulating the Chart object in Access using VBA is not well documented -- another problem when learning.  Usually one can use Excel's macro recorder to do stuff and then just translate that to Access -- especially since Access and Excel both use MS Graph.  With Charts, that doesn't work so good -- you can mostly just use that code as a go-by to find the right code for Access -- either by searching or trial-and-error.  I have done a lot of the second because there is just not much out there.  If someone else has a site for charting with Access like Jon Peltier ( http://peltiertech.com/Excel/ChartsHowTo ) has for Excel, I'd love to know about it.

btw, the code for my charting sample is posted here: http://www.AccessMVP.com/strive4peace/CodeDocumenter__GraphExample_Crystal_140817.HTM ... for now

guess I'd better make a generic link for this because as my Code Documenter gets better, I regenerate the web pages...  well when I start changing names, I will probably post a CODE link with an index ... it would be nice to have a few days where I can run my Code Documenter on a lot of my tools and post the VBA for others to look up ... time, where does it go?


Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *



On Friday, October 24, 2014 2:58 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:




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: Crystal <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Posting Komentar