Skip to main content

Hi there,

 

Is it possible when creating bar charts that you can have visuals like we do on Excel or powerpoint? For example On the X axis I want it to have the month, Y axis to have submissions made but the actual bar to show the each teams who have made submissions for those months. 

Essentially, for one month it will have 3-5 bars which represents teams A-E

 

Thank you 

Does this look right?  I’ve set it up here for you to check out
 

And here’s the setting:

 


Hey ​@ohoward,

 

Adam’s answer above is what your are probably looking for.
 

Re: “On the X axis I want it to have the month”

You’ll have date on the X Axis and you Will probably want to set “Buckets” to monthly :D

 


That does look right, will I need to create another separate table to showcase this? I will have a go at it now - thank you 


Hmm, can’t say for sure without seeing the data I’m afraid.  If you still need help could you provide some screenshots of your data?


This what my bar is looking like with the settings not sure how to change it 

 


This what it looks like, I have them all grouped into studios on this view 

 


Hmm, what’s your ‘Stacking’ set as?

 


I don’t have that option.  Does it matter the fact I have done this from a blank canvas or not?

 


Hmm, yeah, it looks like the Stacking option’s only available on the Dashboard interface type I’m afraid


So I would need to use the template dashboard not a blank canvas? Shame as you can do more within a blank canvas than a template one 

 

Thank you for your help


Using the blank dashboard canvas there isn’t a way to show this type of data? Either in this format or a bar chart?

 


Pivot tables are only available on Dashboards at this point I’m afraid

For the bar chart, you could probably bucket by the date on the X axis and get a stacked select field?


Reply