bnicole
Joined: 10 Jul 2017 Posts: 10

Posted: Mon Jul 10, 2017 11:53 am Post subject: X axis as categories in Points graph 


Dear all,
apologies for the simple question  I am completely stuck.
I would like to make a Points graph where the x axis is categories, and the data that is plotted is the data corresponding to a sample that belongs within that category.
For example, I would have a dataset that looks like this:
Sample rivertype data
A downstream 1
B mouth 2
C black 3
D white 4
E downstream 5
F black 6
Then, when I plot data vs river type I would like a point for each sample's data plotted on the Y based on their data value, and on the X based on its category.
So on the X axis it would say:
downstream, mouth, black, white
and the values for downstream (1 and 5 would be plotted above that category), Black (3 and 6) and so on.
This is what I am trying now and it is not working:
I have mapped the category to a numerical value  1 for downstream, 2 for white, 3 for confluence, 4 for mouth, 5 for Black.
Then, under the axis settings, I have chosen the X tick marks as categories and the labels as the category in my datable.
Then, I can choose to plot category (because it is now mapped to a numerical value) vs data in a Points plot, but what I get on the X axis is:
Downstream, White, Confluence, Downstream, Mouth.....
And Im not entirely sure what is being plotted with it.
Could someone please help me out on this? I would really appreciate it.
Ive tried to attach a screenshot of my setup for help.
Thanks a lot for any help.
[/img] _________________ ~BNicole 
