-1

I have an excel sheet with data in it: enter image description here

That drives a chart, but the chart only shows 0 as data: enter image description here

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.

pnuts
  • 58,317
  • 11
  • 87
  • 139
Olivier
  • 309
  • 2
  • 8
  • 22

1 Answers1

8

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.

Jon Peltier
  • 5,895
  • 1
  • 27
  • 27
  • 1
    +1 even though I strongly disagree about "never" changing the alignment. You should set the alignment to whatever makes the data easier to visualize. Though I agree you should know the difference between text and numbers before doing so. – Jean-François Corbett Jul 12 '11 at 07:37
  • 2
    The source data for a chart is not what you should be using to visualize tabular data. So keep the chart source data in the default horizontal alignment. For the viewable tabular data, link to the source data, but apply whatever alignment and formatting enhances the table. – Jon Peltier Jul 19 '11 at 02:04