Chart creating not behaving as expected.

I'm trying to create a chart in Excel using scientific data.  The charts I create are not behaving as expected.  It is using all 4 columns of data for the Y axis and leaving the X axis blank.  I want it to use the first column as the X axis.  I know I can manually go in and change it, but I don't understand why.  I usually don't have to do this.  I've formatted the numbers of the 1st column to read as text, and still it won't use the first column as the X axis, or at least as a different axis from the other data.

Any clue?
Kelly LaddAsked:
Who is Participating?
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Have you tried sorting your data on first column in ascending order and then creating a chart?
Ejgil HedegaardConnect With a Mentor Commented:
Formatting as text is not enough.
Excel tries to help you, so if it look as numbers it is used as numbers, and then used as data.
Make a ' in front of the numbers, to define them as text.
Kelly LaddAuthor Commented:
Thank you.  I tried both of those things and they each worked like a charm.  Also, I found removing the column heading from the 1st column made Excel recognize that column as the X-axis.  It's nice to know there are methods for working around in case I want to use a header on the colum
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Kelly! Glad we could help.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Wrong post selected as assisted solution.
The correct one should be ID: 42518365.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Question resolved.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.