Create a chart from the sum of columns

CLBai

Hi, is there a way to create a chart from the sum of columns in a report? Attached is a screenshot - I just want to chart the Sum row. Thanks!

Screenshot 2023-01-20 120215.png

Samuel Mueller

@CLBai how many source sheets do you have in that report?

If you only have one source sheet, all you have to do is group your report by sheet name, and it will chart only your sum row. If you have multiple sheet sources for the report, you would need to go to each sheet and add a checkbox column or something where you can write a formula to make every row on every sheet checked and then group by that column.