Bar chart doesn't recognize my numeric data

Ashwaq Ali

Hi all,

i am trying to make bar chart out of a numeric sheet but every time i get error that my data is not numeric while it is actually numeric, i heard that i have to apply this Function, =Value(Text) but it never helped.

i have done this many times on the same sheet which i am 100% that all the data that the sheet contains are numeric. please help !

Paul Newcome

Exactly how is your data calculated?

Ashwaq Ali

=RANKEQ([Patient Experience Current Score]1, [Patient Experience Current Score]$1:[Patient Experience Current Score]$8, 0)

I have variable scores of "Patient Experience Current Score" which is the column name and i want to rank the scores so i used the mentioned formula.

Paul Newcome

And is the above formula able to pull the data correctly?

How is the data in the [Patient Experience Current Score] entered?

Ashwaq Ali

yes it works perfectly and i have done this before with other columns and i haven't encountered this kind of issues

Paul Newcome

Try logging out, clearing your cache and cookies, then logging back in. If that doesn't clear it up, you may want to reach out to support.

Ashwaq Ali

i saved the reference sheet as a new copy and deleted unnecessary column which between the primary column and the needed columns for the bar chart, now i have two reference sheets for the same dashboard but it's fixed at least. Thank you.