How do I add data from a report to a chart on a dashboard?


I am trying to add data from a report to a pie or bar chart on a dashboard. I am trying to sort the data on this chart by the color (added through conditional formatting) of the row based off the result of the form that was filled out. I do not have any numbers on my sheet but would like the chart to show the number of each color that is shown on the sheet.

Best Answer


  • Michael Hair

    Thanks for the help Ben! I was able to complete what I needed to using your information.