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.
Thanks!
Comments
-
Is your formula converting the number to a text? Meaning - does the formula if true or false return a number value between quotes in the formula. Is the value on the left or right of your cell. If the number is on the left, it is returning it as text. If so, you might need to use the Value() formula to pull the result in to another cell which you can use for your chart.
-
Yes, it was converting to text. I used the Value formula you suggested and it works now. Thank you!!
-
Excellent. You can also potentially update your formula to remove the quotes, but if it may be more work given this is now working for you.
