24. (Advanced Programming In Access 2013) Adding Charts & Graphs To Reports 🎓
ฝัง
- เผยแพร่เมื่อ 29 มิ.ย. 2024
- Adding Charts & Graphs To Reports video in the "Advanced Programming in Microsoft Access 2013" series hosted by Steve Bishop. In this free advanced video tutorial series Steve will be going over Microsoft SQL Server installation, Database Migration, creating a better User Interface, using external data sources, complex Visual Basic For Applications (VBA) concepts and distributing your application.
Click here for the full playlist of "Advanced Programming in Access 2013":
• 1. (Advanced Programmi...
Click here for the Work Files of this series:
github.com/Xipooo/AdvancedPro...
----------
Become a member today for only $5 a month!
/ @programmingmadeez
When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
----------
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.
Coffee With Steve: / @coffeewithsteve
![[LIVE] : ONE ลุมพินี 68 | คู่เอก "พระจันทร์ฉาย vs โจนาธาน"](http://i.ytimg.com/vi/F3IM3w-XchI/mqdefault.jpg)
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.
Coffee With Steve: th-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
I know im asking randomly but does any of you know a tool to get back into an Instagram account??
I was dumb lost my password. I love any help you can give me
@Zain Kendrick instablaster =)
@Kendall Creed I really appreciate your reply. I found the site on google and Im trying it out now.
Takes quite some time so I will get back to you later with my results.
@Kendall Creed it worked and I actually got access to my account again. I'm so happy!
Thank you so much you really help me out :D
@Zain Kendrick happy to help =)
Thank you Steve, for such a wonderful, comprehensive and well-explained tutorial! You cover some really useful details in a very easy-to-understand manner. I learned a great deal watching your videos; your content is among the top educational content on TH-cam!
Thanks - that was great. I spent about 3 days trying to get my chart linked with the right data. This was easy and MUCH simpler than all the things I was trying!
Really good. Thanks for showing that. I have picked up on about 4 errors I make. Your clear explanation has sorted this for me.
nice video, Steve! I've made a note of your channel so I can watch more. Glad to see you sharing ~ crystal ~ have an awesome day ~
This was fantastic... definitely going to try and incorporate Thanks
Hi, thanks a lot for your incredible videos. They're very clear and elegant. By the way, your voice is very comfortable to the listener:) Keep going!
very nice tutorial, it is very helpful to understand
That is an excellent video. Very clear and concise.
Thanks a lot, really helpful.
The best professional tutorial acsess i
have seen
Thank you!
Very helpful!!
great job Sir!
Thanks Sir ,for this lovely and informative Video on charts. What is the way to do this using VBA and pulling out data from SQL server .I want to make a dashboard with 20 graphs on a form ,how to do it ?Many thanks
It is great , thank you
Shakeel Kashif I'll be going over using graphs on forms in the next video, but all you have to do is set the "rowsource" property on the graph object, then use the requery method on the object to apply the change.
Great video. Could you show us how to edit the color scheme to be the same for one product throughout the report and also how to add the quantity in the pie segments.
It's nyocky not gunocky. jk. great video. lots of good stuff to check out here. Great job walking through everything you were doing. Drives me batty, but you're doing it right. Good job putting in the bound company field. One thing I'd recommend is putting in the products Descending in your query. That way you can avoid that problem of 'I don't know what the big blue chunk is'. Nice to see top products first too for most uses. Another nice update is a 'view details' link that pulls up the query or a report view filtered for that product. You're right the execs want pictures. But there's always that guy that wants to drill down.
Hi Steve
Excellent Tutorials, Thanks a lot Steve for uploading this videos, it’s really helpful, never
found such good videos.
it is really helpful and very well explained. I have a question on how to add numbers on the chart or how to show percentage on each part of the pie chart. thanks in advance
A very clear and more professional way of teaching. Very helpful and i will continue to view more of his video lectures
Awesome tutorial! Is there a way to take this type of report and turn it into a dashboard that allows someone to select the different companies/products and updates in real time?
Thanks Steve. How can I insert the attachment from form and store it in the SQL database table?
Steve, thank you very much for the video series. They are so very useful. I am using them to teach myself Access VBA coding.
I have a question on adding PI charts to a report. How to determine and show the percentages on the PI charts?
PI charts can only show a single value: 3.141592653 .,..😀
Hi, Nice video. I'm trying to change the colour of the Data Series but the bar chart needs to represent the colours of our company brand standards. However the colour palette is limited to 40 colours and no option to choose a custom colour by setting RGB values. Is there away around this?
Nice tutorial, I need another tutorial on how can I prevent my access from crashing everytime I need to change any formatting.
Thank you.
+Pang Bard You're welcome.
Hello ,I need to customize MS Chart view as per the date, means it should change and compare data between date.
Thank you in Advance
Hello Steve. I have a question regarding charts in reports. I have a table that logs when a product is sold (Field name -> DateSold, Datatype: Date/Time). How can i create a chart (bar or pie) that gives me an indication by month? For example to show me, January X products sold, February Y products sold etc etc. so i can compare which month had the biggest sales ? Thanks in advance.
Thank you for the informative tutorial. I have one question and it's about the error I got when building chart. It is giving an error "Animation error Library not authorized". Can someone help me what that means? Thanks.
Thanks Sir.
HOW TO OPEN Crystal Report WITH FORM Access .
Hi,
Way of explanation is very nice
I have one requirement
1.graphs and data should be shown base on multiple fields selection
Is possible above requirement
How do you edit a chart once it is created. Say you want to change Products Sold to Products Purchased. Do I have to start over?
hi dear i need help
i work on different PC/Laptops thru the day and i take backups so i continue my work, but most of the times i keep facing the #NAME? issue when i open a file on a different device and still dont know whats going on so i have to wait till i reach the device where i stopped and continue.
did you ever faces this issue? could you suggest some help or a fix for this issue? bearing in mind i dont change anything in the formula and i did compact and repair many time but nothing wokred
Mr. Bishop, do you do live help? I am developing my database and really having some problems with the graphs and this database has several graphs.
Hi, how do I edit the individual segment colours please.
great tuto, txs for sharing.
is it possible to convert pie into bar chart, in a real 2D, evenly along the x-axis?
Yes.
The charts are blank if we have more than one grouping level. Could you please give an example where you have more than 1 grouping level like company, then country name (may be) and then the chart?
Great video sir. I have one question though, I used parameter queries to filter the graphs according to date and also added a label on top of the graph to show to the user the date of the data being shown, I've also used the method you taught of increasing navigation control layouts speed in tutorial 21/22. My problem now is I get 3 pop ups of the parameter query and I feel it could be annoying to my customers, isn't there a vba code I could use to control the parameter pop ups, so that the pop up comes only once?
You shouldn't be getting parameter pop ups unless you are intending for it. If the popups are happening because they are referring to a form which isn't visible, then store the data from that form into table instead. That way you eliminate popups for parameters.
Hi Steve, thx for the tutorial. I would like to go one step further and not only group by one criterium (like company) but two (e.g. company and country). How does the architecture of the report have to change??
You just add them as groups to the report.
It's good abit understood I want to create lab system information data base involving patients tests and payments in different insuarances and finally report
I have some problem tackling the issues in that
The riport on tests/investigations , payments and total bellow the report footer
Hello Steve,
I'll take some time to thank you for all your efforts, I'm really graceful for your videos because it helped me throw my studies.
Still, i would love to ask you bout an idea of making a dashboard on Access, and how can I realise that ?
Thank you.
I would make your dashboard from a form, not a report.
do You mean as it is shown in video 25 ?
No, I just mean you can add charts and graphs to forms as well as reports. A form is a bit more interactive though so a user can easily look at data and make selections.
When I design a chart in a Report, the information is correct but when I vie my report, instead of just one sheet I get multiple sheets with the exact same information and not sure how to get it to display only 1 report. Your help would be appreciated.
Hello Steve,
Thanks for a Great video! I've made several attempts to add a simple chart to a report, following your instructions. In Print Preview, i'm getting just a box with the title, the content of the chart does not display.The data is good, I've linked the common data fields (keyID). I'm using Access 2010, is this an issue?
+jacqui evanchik Not really sure why.
How would you create a pie chart at the end, or start, that shows the overall distribution of products? Idea would be to have the breakout by company and then show overall sales by product. Nice to have on a single report
+Scott Hiltonen Create a sub report with the data you want in the pie chart, then embed the sub report in this report.
Hi Steve, after I pick a chart and hit next to chard wizard tells me "You must add field Prov# to your record source if you want to use this link. " and Prov# is primary key in my database . do you have idea why is that? Thank you.
+Bilal Kareem Make sure that the query you are basing your chart on has that primary key displayed in it.
realy a nice video ;-) It did great help making a report better overviewing. But do you also know how to make pivotcharts?
Ewoud Visscher Pivot charts and pivot tables have been removed in Access 2013. Yet another useful feature Microsoft, in all their infinite wisdom, decided to take out. Their excuse for this is because pivot chats and pivot tables are not supported for the web version of Access. It seems pretty clear the Access team has a directive to turn Access into web only solution in the near future.
+Programming thanks for this new info. I didn't know! maybe you van help us answering 'how to make the tables and graphs interactieve?' like deepening in information... 'something like zooming in on a financial year report?' maybe you know a 'slider' something solution? thanks alot.
Ewoud Visscher Did you watch the next video? I discussed how to tie charts to selections made on a form to make it interactive.
How would I go about changing SKUs to their UPC when another user imports an excel spreadsheet (containing SKUs). The company will randomly change SKUs and this is problematic for maintaining synced data. I've tried adding a button for employees to download the current inventory list for them to make the proper changes. It worked as well as dribbling a hockey puck.
Hi Jacob Ely, thank you for your question. However I am afraid it is too specific to your situation for me to properly help in the comments section. Also please consider the time it would take to collect all the necessary information to help you. If you're looking for one-on-one help with a problem you can sign up as a member for $5 a month and submit questions directly to me with screen shots or even copies of your application. If necessary I will initiate a virtual meeting with you so you can screen share and work through the problem together. Unfortunately I cannot offer this service to everyone for free. I hope you understand.
If you are looking for a free option to get help with this issue, you can always try one of the access forums such as www.accessforums.net/ or www.utteraccess.com/forum/ . The folks on those forums do a terrific job of helping people in their free time.
Great video but im running into a problem. After i have established my company name(txt) in the properties box and then look at print preveiw. I'm only pulling in one account. Do you know what might be my error?
The error was my human error. I figured it out. Great Video!
What if I am getting the data from an external database? How do I set the queries before plotting the chart? I split them into front end/backend to minimize the chance of corruption.
I cover this later in the series.
Hey steve or anyone can i create a chart with one table?
I am trying to create a chart for a group of air planes that show me what the average is over the course of a 10 hour day what planes were up and what are down and have a line chart that shows me the when over the course of the day when the status changes for my group of aircraft. I am not sure how to do this is Access properly using time as a filter. I have the data but dont have the time figured out. I am not sure how to capture and record when a field is updated for a given field. Any help would be appreciated.
Do you have a date/time field in your data?
Yes
Thank you very much for the beautiful video, I did it! now , if I would like to send each customer his own Product sold chart report by Email how can I do it as an Encrypt file? I have 1000 customers.
Our customers want us to send the P&L report as an encrypt file, How can I do it? , as I said I have 1000 customers, and I use the Docmd.SendObject and I have send it as PDF but it's not encrypt...
You cannot do this with the SendObject command. You have to create an Outlook email through the Outlook library, then encrypt that email.
Can you be more specific and tell me the command that make the encryption or guid where can i find help for that issue. Again thanks a lot for all the help
www.emailarchitect.net/forum/yaf_postsm176_VB6--VBA---Encrypt-Email---S-MIME.aspx
How to count the number of companies we have?
+Jaya Bhatia This is covered in the basic series.
+Programming can you send me the link. I have to work with 2.8 million data and I know nothing about access
If you are trying to perform complex VBA tasks without knowing VBA, then I think you're in deeper than you realize. Just copying and pasting some code isn't going to help you. You really should go through the whole series so that you know what you're doing and won't break anything because you were unaware.