Graph Data not displaying

  • Thread starter Thread starter davethewelder
  • Start date Start date
D

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
 
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!
 
put 1 in a cell and copy the cell.
Select the 4 value cells and Paste special - Multiply. Still no bar?
 
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.
 
Back
Top