asked on

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?

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ejgil Hedegaard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kelly Ladd

ASKER

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

Subodh Tiwari (Neeraj)

You're welcome Kelly! Glad we could help.

Subodh Tiwari (Neeraj)

Wrong post selected as assisted solution.
The correct one should be ID: 42518365.

Subodh Tiwari (Neeraj)

Question resolved.