Non-numerical data

[OldBirch]

Hello,
I need to make a graph for a set of data shown below

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]20 degrees[/TD]
[TD]Liquid[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]semi liquid[/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]semi solid[/TD]
[/TR]
[TR]
[TD]80[/TD]
[TD]solid[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]solid[/TD]
[/TR]
</tbody>[/TABLE]

I have tried countless different methods and cant find a way. The right hand column needs to be on the y-axis.

Cheers for any help
OldBirch

 

[RoryA]

Welcome to the forum.

What kind of chart and why does the non-numeric data need to be on the value axis? If it really does, what level should it plot at? You basically just need to assign number values to those states, but what should they be?

 

[OldBirch]

I am open to what you would suggest for the chart, it was for a science practical analysing the effect of the temperature of pineapple juice on how well the jelly forms (solid-liquid)

cheers

 

[VBA Geek]

One idea could be:

 

[OldBirch]

One idea could be:

Thank you how would I make this graph in excel?
Cheers

 

[VBA Geek]

I will try to upload the file later today so you can download it

Thank you how would I make this graph in excel?
Cheers

 

[VBA Geek]

Thank you how would I make this graph in excel?
Cheers

You can get the file here: Download the file