View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Venkatesh S" <Venkatesh
wrote in message
...
I have a text file de-limited with tab. I need to convert the same file to
excel and use chart options to draw a graph. Though i am able to import
the
text file in to excel file i am unable to draw graph with that data.
Please
help me do it.