Display Percent of Total in Queries, Pie Charts in Microsoft Access and Excel. Modern Charts.
ฝัง
- เผยแพร่เมื่อ 29 มิ.ย. 2024
- Learn how to display percentages in your queries, and in the new Modern Charts in Microsoft Access.
Brent from Santa Ana, CA (a Gold Member) asks: I'm trying to create a pie chart in Microsoft Access using these new Modern Charts. I cannot figure out for the life of me how to see a percentage value for the data label. I can do it in the old Access charts, and I can do it in Excel, but I can't figure it out in these new Modern Charts. Help!
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to automate the chart type selection so your users can pick from a list to change the chart to pie, line, column, or bar.
MEMBERS ONLY VIDEO:
• Display Percentages in...
BECOME A MEMBER:
/ @599cd
LINKS:
Aggregate Queries: 599cd.com/aggregate
DSUM Function: 599cd.com/dsum
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/TechHelp
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, percent, percentages, show percent, modern chart, pie chart, access charts, percent of total in query, charttype, dsum
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
I am so glad that you post these videos. I have joined your site and it is every bit worth the money!!
Thanks! :)
Awesome !!! Please keep sharing your valuable inputs, Kudos !!!
Thank you! Will do!
Thank you Instructor! ❤️ you have helped me a lot to develop my business systems
Happy to hear that!
Thank you so much. I was having a problem and you made it so easy to add the percentage. Big Up Yuself
Glad it helped
Dear sir hopefully Access will share how to change the color pie. It will be more easy to analyze for the reader or viewers. Thanks a lot.
welcome
First! Well done Rich!
Thanks. People still do the "First!" thing, huh? LOL
Is there a way to get access to add those numbers together? Mine shows a bunch of money values and I would love to have the total at the bottom. Thanks!
599cd.com/QQ
I follow the formula but it didnt come out as 0.xxxxx but instead it comes out 6.68 and even 0.358e-02 and when i total up ,it does not add up to either 1 or 100, may i know why does it show this, this is regarding the doing of modern chart and wanting the amount to be percentage
Try again.
❤❤❤
:)
how do i access the extended cut for this particular topic?
Link is in the description below the video or on my website
@@599CD Thanks Rick. You are my favorite!