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.



"Andy Pope" wrote:

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

davethewelder wrote:
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" wrote:


Hi,

Are the cells formatted as text by any chance?

Cheers
Andy

davethewelder wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info