|
Graph Data not displaying
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 |
Graph Data not displaying
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 |
Graph Data not displaying
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 |
Graph Data not displaying
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 |
Graph Data not displaying
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 |
| All times are GMT +1. The time now is 03:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com