How to create a chart for accrued hours by 3 individual
Good day everyone,
I am currently trying to create a graphical / numberical represenstation of accrued hours by 3 individuals to visually representing their total accrued hours in a sheet.
Basically, the sheet/form is running accordingly with manager's approval and all the factors.
How can I create a Dashboard (with bar graph or just a number) to reflect the total hours these 3 individuals as accrued in simplest form of
Mr. A = xxx Hours
Mr B = xxx Hours
Mr C = xxx Hours
Best Answer
-
I would suggest creating a row report that references the sheet. You can then group by name and then use the report summary feature to get your totals. Finally, you would use this report as the source data for a bar chart.
Answers
-
The form is something like this.
-
I would suggest creating a row report that references the sheet. You can then group by name and then use the report summary feature to get your totals. Finally, you would use this report as the source data for a bar chart.
-
Yes that works!! Thank you so much for your tips.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives