Excel 2004 Charts not working

M

mapsguy1955

Registered
I am trying to setup a chart in excel (xy chart) and I keep on getting error messages. Normally (pc) I can take data in column 1 and put it into the chart using commas between each cell but it doesn't work. This is for the X coordinates. I am totally confused. I have tried using the otion key, command key, commas... nada. It gives me a formula error. I don't even know how to explain it.
If anyone knows how to setup this type of chart in excel... help!!!

John
 
I just performed a test. I created a text file with an array of numbers separated by commas. I opened this file in Excel 2004. The numbers were placed in successive cells of the first row of the spreadsheet until they were exhausted. How is what I did different from what you are trying to do?
 
I have multiple pages I am pulling from. I figured it out though, after about 4 hours. The chart I was trying to use was the wrong one. It is now working... Yay!

Thank you though!
 
You must log in or register to reply here.
Back
Top