Charts referencing cell with formula
Hi, having an issue with charts. I'm thinking there must be an easy solution that I'm missing. I am trying to create a chart in a new dashboard. When I select the data from a sheet or report, the following error comes up "Invalid Data. To create a chart you must use numeric data". The data in the cells I selected are numeric, but are generated using a formula. Is there another way I can get the chart to display without having to lose my formulas? I want the chart to accurately reflect the current totals.