![]() |
Charting a .csv file in excel 2003
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? |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com