Chart Widget help
Hello! I am trying to build a dashboard with a chart widget that displays only the Total Sum of my summary report. Essentially there are 4 sheets this summary report is pulling from. I am only looking to display a chart of the summed monthly totals and not have the chart bars divided out by Sheet. I appreciate any insight into getting the widget to display the totals; this is my first dashboard. I would also like the vertical axis to display only whole numbers, no decimals. Thank you!
My Summary Report:
What I am getting (with each sheet showing as a separate bar):
What I want (with only a sum total displaying as a single bar):