Logarithmic plotting
 

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

Logarithmic plotting
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dieseldan" wrote in message
...
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