Stacked Bar Graph

katebrew

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.

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?

katebrew

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

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.