Graph Data not displaying

[davethewelder]

Hi, I have a range of 4 values in a spreadsheet and when I select them for a
bar graph I am getting the graph with no bar displayed. The cell references
are correct in the series value tab. I have tried re-entering the data but
no joy.
Anyone any ideas?

All help greatfully accepted.

Davie

 

[Andy Pope]

Hi,

Are the cells formatted as text by any chance?

Cheers
Andy

 

[davethewelder]

I have tried reformatting the cells as number, no decimal places, and
recreated the graph but still no info displayed.

It is only 4 values - 509, 277, 153 and 79.

Normally not difficult to do!

 

[Andy Pope]

put 1 in a cell and copy the cell.
Select the 4 value cells and Paste special - Multiply. Still no bar?

 

[davethewelder]

Andy, just realised I copied the table from a word document and then
formatted the
cells. If I re-enter the cells at a different row the graph works. Thanks
for you comments.