I cannot for the life of me make graphs on excel. Every time I do it I struggle HARD, do lots of googling, spend an insane amount of time trying, and either give up or find some guide that I follow that works (but I never memorize). Somehow I made it to senior year without ever getting the hang of it. I'm trying to do my first lab report for Ochem and need to make a graph of my data.
The graph needs to be "Boiling Point" on the Y-axis and "Molecular Weight" on the X-axis. There needs to be three lines on the graph, one for alkanes, one for alcohols, and one for ketones. We're looking at how the molecular weight of molecules in these three different groups affects the boiling point. So we need lines showing how the alkane boiling points changed with increasing molecular weight, how the alcohol boiling points changed with increasing molecular weight, and how the ketone boiling points changed with increasing molecular weight.
I've made several tables and turned them into graphs and they've all been wrong, to varying degrees (I actually got molecular weight to be my X axis and not a line on my graph once, haven't been able to do that since). Can anyone tell me how I'm supposed to plug the data into a table in order to get the graph I want?
The graph needs to be "Boiling Point" on the Y-axis and "Molecular Weight" on the X-axis. There needs to be three lines on the graph, one for alkanes, one for alcohols, and one for ketones. We're looking at how the molecular weight of molecules in these three different groups affects the boiling point. So we need lines showing how the alkane boiling points changed with increasing molecular weight, how the alcohol boiling points changed with increasing molecular weight, and how the ketone boiling points changed with increasing molecular weight.
I've made several tables and turned them into graphs and they've all been wrong, to varying degrees (I actually got molecular weight to be my X axis and not a line on my graph once, haven't been able to do that since). Can anyone tell me how I'm supposed to plug the data into a table in order to get the graph I want?