Logarithmic plotting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I am wanting to do a Log Plot (both Axis) on the following data. How
do I do this in Excel?

Stage Discharge
0.291 0.873
1.237 11.6
0.7 5.16
0.295 0.889
0.288 0.783
0.288 0.811
0.288 0.771
0.48 2.53
0.284 0.737
0.333 1.12
3.261 44.8
0.378 1.53
0.389 1.63
0.444 1.978
0.325 0.96
0.306 0.932
0.301 0.855
0.82 6.87
0.834 7.26
0.877 6.57
1.045 9.18
1.764 18
3.121 39.9
4.297 68.9
4.526 77.6
3.085 30.5
0.087 0.061
 
With the data in A1:B28:
First select all the data (and headers) and use Data|Sort to sort by Stage
Now select A1:B28 and make an XY chart
Double click x-axis, open Scale tab and check the Logarithmic box
Repeat with y-axis
Done
best wishes
 
Back
Top