Percent of Total in Charts
By Richard Rost

12 months ago

Display Percentages in Queries, Modern Pie Charts

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!

Members

I'll 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.

Extended Cut Video - Silver
Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Aggregate Queries: https://599cd.com/aggregate
DSUM Function: https://599cd.com/dsum

Learn More

FREE Access Beginner Level 1
Access Level 2 for $1.00

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates

Resources

Mailing List - Get Emails When New Videos Released!
Consulting - Need Help with Your Database?

Questions?

Please feel free to post your questions or comments below or submit them via the TechHelp page.

Charting Data Correctly Upload Images Link
James Hopkins
26 days ago

Hey Richard, thank you for the awesome Tech Help Videos. They have been extremely helpful in the process of building my database. But now I am trying to finish up with the last details of my company's database. The problem is that I am trying to complete the custom dashboards for "Company Financial, Customer Information, Invoices, Estimates, and etc. Question is that, should I base the 'Charts and Graphs' on Queries or use VBA Code the generate the Data? Or is there an better way to go about doing this? Please Help...

Adam Schwanz
26 days ago

That's a pretty broad question. I can't tell you for sure without knowing the setup of your database and what information you're going to need to access/calculate. In 99% of cases a query is simpler so I would use that, in some cases the result you're trying to get is really complex and you might need to use VBA to get some stuff, or you might need to use both together. Start with the query and see if there's any information you can't get, then you can come back here with a more specific question that we could look into.

James Hopkins
25 days ago

Hey Adam, Here's an overview the my dashboard.

Show 17 More Replies...