Basically im trying to generate a graph in word (using excel) which has reaction time on the left, pH on the bottom and has a series of pH levels running up it in regards to what the result was.
It has to be a graph where I can draw a line through it to then be able to omit certain dodgy results but word/excel defaults to putting my results all over the place.
example, for pH 3 I have
on the graph it lays these results out horizontally which I quite simply dont want. I need these to be centred over 3 at the bottom of the graph and rise up from it vertically to show where the results where.
Any ideas? Really not getting very far with this at all lol
Full results are as follows if thats any use
It has to be a graph where I can draw a line through it to then be able to omit certain dodgy results but word/excel defaults to putting my results all over the place.
example, for pH 3 I have
Code:
0.346 1.02 0.45on the graph it lays these results out horizontally which I quite simply dont want. I need these to be centred over 3 at the bottom of the graph and rise up from it vertically to show where the results where.
Any ideas? Really not getting very far with this at all lol
Full results are as follows if thats any use
Code:
pH Buffer Used Rate of Reaction
3 0.346 1.02 0.45 -
4 1.41 1.0 1.38 1.36
5 1.32 1.70 - -
6 2.56 3.159 4.762 2.51
7 1.96 3.33 1.786 -
8 8.57 3.09 5.0 4.55