I need to chart some data points!
 

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?

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?

I need to chart some data points!
 

Hello Sean, Thank you for responding to me! Yes there are headers for every
column. I am a realtor exporting data out of MLS and it only exports in .csv
files. The headers I am trying to graph are sold price vs. sold date. And
there is a string of numbers below each header. I highlight both headers and
then hit the chart icon. The data range field is blank. At this point I try
to re-highlight and I still get the same error message. Have any ideas?
Thank you,
Greg

"Sean Timmons" wrote:

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?

I need to chart some data points!
 

Sean asked two questions, but you answered only one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"gford" wrote in message
...
Hello Sean, Thank you for responding to me! Yes there are headers for
every
column. I am a realtor exporting data out of MLS and it only exports in
.csv
files. The headers I am trying to graph are sold price vs. sold date.
And
there is a string of numbers below each header. I highlight both headers
and
then hit the chart icon. The data range field is blank. At this point I
try
to re-highlight and I still get the same error message. Have any ideas?
Thank you,
Greg

"Sean Timmons" wrote:

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?

I need to chart some data points!
 

Perhaps I don't know the definitions? Which question did I not answer?
Please specify. MLS only exports in .csv files. Can I convert them? I
thought that I identified what a header was. Sold price vs. sold date. If
not please specify.
Thank you, Greg


"Jon Peltier" wrote:

Sean asked two questions, but you answered only one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"gford" wrote in message
...
Hello Sean, Thank you for responding to me! Yes there are headers for
every
column. I am a realtor exporting data out of MLS and it only exports in
.csv
files. The headers I am trying to graph are sold price vs. sold date.
And
there is a string of numbers below each header. I highlight both headers
and
then hit the chart icon. The data range field is blank. At this point I
try
to re-highlight and I still get the same error message. Have any ideas?
Thank you,
Greg

"Sean Timmons" wrote:

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?

I need to chart some data points!
 

"2 - Have you tried saving as .xls first?"

Use Save As for any open file of any format to save with a different name or
format.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"gford" wrote in message
...
Perhaps I don't know the definitions? Which question did I not answer?
Please specify. MLS only exports in .csv files. Can I convert them? I
thought that I identified what a header was. Sold price vs. sold date.
If
not please specify.
Thank you, Greg


"Jon Peltier" wrote:

Sean asked two questions, but you answered only one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"gford" wrote in message
...
Hello Sean, Thank you for responding to me! Yes there are headers for
every
column. I am a realtor exporting data out of MLS and it only exports
in
.csv
files. The headers I am trying to graph are sold price vs. sold date.
And
there is a string of numbers below each header. I highlight both
headers
and
then hit the chart icon. The data range field is blank. At this point
I
try
to re-highlight and I still get the same error message. Have any
ideas?
Thank you,
Greg

"Sean Timmons" wrote:

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?