Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
Stacked Bar Graph - Reflect 3 columns
Can't figure out how to use 3 columns for a staked bar chart in Smartsheet.
Please see attachment. For example, I'd like one column to show all costs for January, with Amy and Joe's costs would be broken out by color. Is this possible? If yes, could you please explain directions?
I can only figure out how to use two columns total.
Comments
-
Hello,
Charts only graph numerical data —any text to the left of the numerical data can be used as a data label. If you have more than one column containing text values, the leftmost column will be displayed in the chart.
To create a stacked bar chart with this data, I created a column for each month (you may want to consider using a separate sheet for this) and entered each person's name in separate rows.
You may also want to consider using cross sheet formula to sum the total travel spend for each person every month. If needed, more information on this can be found in our help articles:
- Cross-sheet formulas: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
- SUMIF: https://help.smartsheet.com/function/sumif
Your chart will look something like the image I've attached.
-
I am trying to create the same kind of chart with 3 variables. However, all the values are not displayed when created in my dashboard. Suggestions?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- Am I the only one missing two of the three AI tools today? I should be seeing: Analyze data Generate formulas Text and summaries But only "Analyze Data" is available.
- In doing some reading it looks like Power Automate may work??? Anyone successful done something similar? Also, do you need to be Office 365 Admin/SmartSheet Admin to accomplish this. Or can you be end…
- to replace data with global update I got the following message. But I am the owner of the source folder… and the Blueprint does have sheets
