Stacked Bar Graph - Reflect 3 columns

03/18/19 Edited 12/09/19

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.

chart example.png

Comments

  • AlejandraAlejandra Employee

    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:

    Your chart will look something like the image I've attached. 

     

    CommunityPostSC.png

Sign In or Register to comment.