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
-
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.
-
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
Categories
Check out the Formula Handbook template!