Data shows only as zeros on chart [closed]

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 11 years 开发者_Python百科ago.

I have an excel sheet with data in it:

That drives a chart, but the chart only shows 0 as data:

Each of my cell is a formula.

I tried to write a value in a cell and it shows in the chart

I tried to copy the data and paste values, but it doesn't show on the chart.

Please help.

---

You didn't share the formula, except for very tiny in the screen shot of the formula bar. From the bits I can see (text operators "RIGHT" and "LEFT"), I can tell that it is returning text, that is numbers stored as text. Excel charts text as zeros.

Change the formula to

=VALUE(your current formula here without the equals sign)

To make sure you don't store numbers as text, you should never center align your numerical cells. Keep the default formatting. Numbers are right-adjusted, text is left-adjusted. You can detect a problem instantly.