Let me save you the trouble of typing 1, then deleting it later. Copy a blank cell,
then do Edit menu Paste Special Values + Add.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Nick Hodge wrote:
Maybe the 'numbers' in the data are being seen as text, try entering 1
anywhere on the sheet and copying it. Then highlight the 'numbers' and do
EditPaste special...Values+Multiply
This should kick the text numbers to actual ones and you should then be able
to chart it