How To Make a Graph with Microsoft Access (Classic Chart)
ฝัง
- เผยแพร่เมื่อ 13 ส.ค. 2014
- Do you want to know how to make a graph with Microsoft Access? 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.
This was the way to make charts and graphs before the "Modern Chart". I now call these Classic Charts. They're still in Access and work great.
Related video: How to manipulate graphs with VBA:
Tool and Code: Graphs and Charts in Microsoft Access (cc)
• Tool and Code: Manipul...
www.AccessMVP.com/strive4peace...
~~~
To learn about Access, read my free Access Basics book
www.AccessMVP.com/strive4peace
and watch the videos here (then others):
Learn Access Playlist on TH-cam
th-cam.com/users/view_play_list...
** Original Music **
JD Live (Jerome Dixon, Houston)
* myspace.com/jdlivepro
* / jdlivepro
happy graphing!
* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!
visit MsAccessGurus and contact me today!
msaccessgurus.com
I look forward to hearing from you ~
warm regards,
crystal
Remote Programming & Training -- connect to me, let's built it together
~ have an awesome day ~ - วิทยาศาสตร์และเทคโนโลยี
Thanks for this. I did a lot of work with graphs in the late 1990s, including manipulating them with VBA. None of my clients wanted graphs after that and I'd forgotten a lot. Your video has got me going again.
Excellent! Keep it up ~ I can't imagine anyone not loving charts!
Thank you Crystal! I was told I had to copy table data to Excel to make the charts. This will be such a time saver!
you're welcome and thank you, John!
The trick to make the real chart appear is the best. Thanks!
you're welcome and thanks ~ not realizing this probably throws a lot of folks off
Very clear and to-the-point. Thank you.
thank you!! :)
Thank you my beautiful teacher👏
Very helpful and easy to follow. Thanks Crystal
thank you, Joe!
You made this look so easy. Thank you.
you're welcome and thanks ~ hopefully this will be a good reference for you. The trick is figuring out the syntax because there is not much documentation
Thank you so much! Good Job!!! Very useful!
you're welcome, and thank you ~ happy to help
Thanks. This was so much helpful. Thanks again..!!!
+Ajith Etulgama thank you, Ajith ~ happy to help
Great show. Very nice and usefull.
you're welcome and thanks for commenting
Great video, thanks
thanks and you're welcome! I love the flexibility and power of classic charts -- and you can make them look nice too :)
O......M......G..... Crystal thank you so much. this was very helpful.
you're welcome, joaquin ~ happy to shed some light on such a bright feature of Access ~
Really reallyl helpful! Thanks!
thank you and you're welcome ~ happy to help
Really good teacher ! ;-)
thank you!! :)
Hi Crystal!
Thanks for another wonderful tutorial.
Question: Is it possible to make Sundays become Red in "X" axis date?
thanks, Ozair! Good question. It seems you could use VBA to iterate through the labels but maybe not, I've never tried it.
Thanks from Taiwan.
thanks and you're welcome!
Thank you for your video.. but I have a problem: I want to make a combined chart in Access but with certain conditions.. i.e. I want to apply the chart colors according to the result.. can you help me? And thank you in advance ❤️
hi Nawres, great question! Classic charts let us iterate through points at runtime. While we can change whether to show a point or not, we cannot change the color at runtime ... however you CAN choose colors beforehand and hide points -- so you can correlate a subform, for instance, to match the colors.
thanks
You're welcome! thanks for your comment
Crystal, I have created my chart in my database, but when I view it has more than one sheet and it should be only one report. Any suggestions.
hi Mary, Do you mean you are getting multiple charts? If so, perhaps you put the chart in the detail section of a form or a report that has a Record Source -- so a chart will be displayed for every record. The solution, if this is the case, is to remove the Record Source (or make sure it only has one record), or put the chart in another section. If the problem is that the chart is too big, then you can resize it by dragging the handles on the edges. Be sure to also close up the extra space in the section from the bottom, and drag the form/report right boundary to the left too.
good morning .. i also have that issue .. whenever i make graph the chart is emplty. what should i do? pls help
+jherril santos if the chart is empty, then so is the query that is feeding the chart -- choose different criteria. Perhaps the SQL is not good -- check it buy using it to create a query and see if you get records
How do you add additional Series to the chart?
thanks for asking, Roger ... simply add the additional series to the RowSource and then make changes if desired to the design as well
How can I create a stacked column using two fields?
Samantha, you actually need 3 fields ... one for x, one for y1, and one for y2. Make the query that gets the data, then assign that to the RowSource and set the chart type to stacked column
I am still using Access 2000. I developed query with data I want to chart. I am using price banding (0-50, 50-99, 99-150 etc) for 2 categories of data. Categories are marked as A or as P. My prior charting experience only showed those in A status, but now I am trying to include P status alongside the A status in each price band. I can't for the life of me figure out how to add another set of data to display in a secondary bar in each price band. I also have a whopper of a headache, which might explain a lot. Anyway, any guidance would be welcomed highly. Steve at CountyRealty dat com.
Hi Steve, its really easy! ... once you've done it once anyway ... just make another column in the RowSource for the chart!
Could you post the file too?
Thank you,
you can find it here: www.accessmvp.com/strive4peace/Access_Graphs.htm
Me: *clicks on this video*
Her: Do you want to know how to make a graph with Microsoft Access?
Me: Naaaaaaaaaaaw
Great video, thanks
you're welcome, and thank you, Tom!