How to display 2 data labels in a bar chart
Hello everyone!
Good day.
I'd like to ask for your help in a task I'm trying to accomplish.
I'm trying to build a bar chart in a dashboard that will show the total amount collected by each team per year and also the number of collections they had. To this end, I have 2 sheets: Sheet 1 contains the raw data - all the entries per team for each year; Sheet 2 contains the total value for each team per year.
I was able to create a bar chart off of Sheet 2 showing the total value with the labels for the sum, but I don't know how to incorporate the number of entries (count) per team. Below is a screenshot of how I want the chart to look like.
Hope you could help me with this task.
Thank you.
Best Answer
-
Paul Newcome ✭✭✭✭✭✭That is not currently possible in Smartsheet although it would be a great feature. Feel free toSubmit a Product Enhancement Requestwhen you are able.
In the meantime, you would need to use either a separate graph of some metrics widgets to show the data.
Answers
-
Paul Newcome ✭✭✭✭✭✭
That is not currently possible in Smartsheet although it would be a great feature. Feel free toSubmit a Product Enhancement Requestwhen you are able.
In the meantime, you would need to use either a separate graph of some metrics widgets to show the data.
-
Thank you for getting back to me on my question, Paul
-
Paul Newcome ✭✭✭✭✭✭
Help Article Resources
Categories
Try setting the criteria to 0.5 instead of 50 as you have the column set to % - right now the formula may be looking for greater than 5000% which obviously won't be found if you're using 0-100%.<\/p>
Let us know if this works or if another solution is required.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]},{"discussionID":111988,"type":"question","name":"IF AND Formula Question","excerpt":"I wanted get the below formula running... but get an an #UNPARSEABLE error. =IF AND(Number@row, {Wave B (EMEA) - L4 Mapping}, CONTAINS({Wave B (EMEA) - Country x2}, \"BE\"), \"True\", \"False\") Any help would be much appreciated.","snippet":"I wanted get the below formula running... but get an an #UNPARSEABLE error. =IF AND(Number@row, {Wave B (EMEA) - L4 Mapping}, CONTAINS({Wave B (EMEA) - Country x2}, \"BE\"), \"True\",…","categoryID":322,"dateInserted":"2023-10-20T21:18:29+00:00","dateUpdated":null,"dateLastComment":"2023-10-21T08:53:03+00:00","insertUserID":164249,"insertUser":{"userID":164249,"name":"Ulrich Anderhub 1","url":"https:\/\/community.smartsheet.com\/profile\/Ulrich%20Anderhub%201","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-21T12:48:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164249,"lastUser":{"userID":164249,"name":"Ulrich Anderhub 1","url":"https:\/\/community.smartsheet.com\/profile\/Ulrich%20Anderhub%201","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-21T12:48:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":38,"score":null,"hot":3395716292,"url":"https:\/\/community.smartsheet.com\/discussion\/111988\/if-and-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111988\/if-and-formula-question","format":"Rich","lastPost":{"discussionID":111988,"commentID":401071,"name":"Re: IF AND Formula Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401071#Comment_401071","dateInserted":"2023-10-21T08:53:03+00:00","insertUserID":164249,"insertUser":{"userID":164249,"name":"Ulrich Anderhub 1","url":"https:\/\/community.smartsheet.com\/profile\/Ulrich%20Anderhub%201","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-21T12:48:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-21T08:53:11+00:00","dateAnswered":"2023-10-20T21:36:57+00:00","acceptedAnswers":[{"commentID":401046,"body":"
