| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| How do I create a graph displaying two parameters for one item | Charts and Charting in Excel | |||
| Displaying graph and charts on events | Excel Discussion (Misc queries) | |||
| Add data labels without displaying data points? | Charts and Charting in Excel | |||
| Displaying values from zero on graph | Excel Discussion (Misc queries) | |||
Hybrid Mode
