Representing Percentage of the Total in a Chart
Hello. This may be a very silly question, but I am having trouble representing the following data:
1.PNG
I was able to create this chart:
2.PNG
It uses data from a pivot table to show number of countries to total hours per week.
However, I would like to create another chart that shows the user what percentage of countries work 40hrs per week, 48hrs per week, etc.
If this can be done, can I please get some guidance on how to do this?
There are probably a couple of ways to do this, but I would use a pivot table with a chart.
Use column B as the Axis Category with Count of Countries as the values.
In the pivot table, show values as % of Parent Row Total
HTH
Regards, Jeff
Hi Jeff.
Your suggestion suits my needs perfectly.
3.PNG
Thank you very much.
Glad it worked out for you and happy to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks