Stacked Bar Graph

I am trying to create a stacked bar graph using data from a sheet summary report however I have not get the report data to pull into rows as I select the field to be added to the report they are popluated as columns only.

Answers

  • Werner Gerstacker
    Werner Gerstacker ✭✭✭✭✭

    Did you see that there's an option to switch rows/columns in the Charts & Data section of the 'Edit Chart Widget' window?

    Or did I not understand your question properly?

  • Thank you Werner! I do see that but I am still not getting the results I want. I don't understand why I cannot select data to be pulled into addition rows from a summary report when I select fields I can only add new columns not rows.

  • Werner Gerstacker
    Werner Gerstacker ✭✭✭✭✭

    Sorry, haven't really worked with Summary Reports and therefore do not understand if they need to be treated differently - I would have thought that all rows visible in a report would be available to show them in a graph.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!