View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default I need to chart some data points!

A couple thoughts:

1 - Do you have headers for every column?

2 - Have you tried saving as .xls first?

"gford" wrote:

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?