Making a chart - uneven X-axis labels

Question

aditya1729 Author

Level 1

8 points

Making a chart - uneven X-axis labels

I want to make a chart where the labels in X-axis are not even. Consider an example:

X Y

1 2

4 3

5 5

6 6

9 7

Now whenever I make a chart with X-axis data in A column and Y-axis data in B column, I get a chart like this:

which is useless for me. I want the numbers in the X-axis to be uniformly distributed i.e. evenly spaced.

OS X Mavericks (10.9.1)

Posted on Feb 16, 2014 8:56 AM

Reply

Answer 1

aditya1729 Author

Level 1

8 points

Feb 16, 2014 9:11 AM in response to aditya1729

What I want is something like this:

Reply

Answer 2

Yellowbox

Level 7

21,939 points

Feb 16, 2014 4:20 PM in response to aditya1729

Hi aditya,

It looks like you have inserted a Category Line Chart. What you want is a Scatter Plot.

You can add connecting lines.

Regards,

Ian.

Reply

Answer 3

Badunit

Level 7

30,342 points

Feb 16, 2014 4:39 PM in response to aditya1729

As Ian, said, you want a scatter chart. Note that with a scatter chart, the X data cannot be in a header column/row (in contrast to the category charts where the X data should be in a header),

Reply