is this what you are looking for?
Simply Create a Dashboard page in your workbook and add those sheets and arrange Legend and Chart accordingly.
ref attached sample book.
Kindly mark as Answered and Helpful if this resolve your problem, so that this can be closed.
For Forum (1).twbx 3.0 MB
1.enter those question into each work sheet's title, and then combine them in a dashboard
2.hold Ctrl and drag number of record onto label to show the percentage
3.combine 3 sheets in the dashboard
4.right click at the x-axis to uncheck show header for better picture
please see my workbook for detail
For Forum_v2018.1.twbx 3.0 MB
Thank you. This is a great way to get it on one sheet. I also like the idea of putting multiple sheets on the dashboard.
Thank you. Very kind of you to help