Charting a .csv file in excel 2003

G

gford

I am trying to chart two columns from a .csv file. In the Chart Wizard.
When it gets to the Data Range, the field is blank. So I high lite the two
columns again, and try to hit next button. Microsoft excel says, "A formula
in this worksheet contains one or more invalid references. Verify that
formulas contain a valid path, workbook, range name, and cell reference. It
won't chart my data. What should I do? Is it 2003 excel fault?
If I try to chart a .xml file with the same steps and it works. Also out of
the high lited columns; Data Range field is already filled in correctly with
columns check marked. And then it charts for me! Does excel 2003 chart .csv
files?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top