software

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

StageDischarge
0.2910.873
1.23711.6
0.75.16
0.2950.889
0.2880.783
0.2880.811
0.2880.771
0.482.53
0.2840.737
0.3331.12
3.26144.8
0.3781.53
0.3891.63
0.4441.978
0.3250.96
0.3060.932
0.3010.855
0.826.87
0.8347.26
0.8776.57
1.0459.18
1.76418
3.12139.9
4.29768.9
4.52677.6
3.08530.5
0.0870.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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;dieseldanquot; gt; wrote in message
...
gt; Hello I am wanting to do a Log Plot (both Axis) on the following data.
gt; How
gt; do I do this in Excel?
gt;
gt; Stage Discharge
gt; 0.291 0.873
gt; 1.237 11.6
gt; 0.7 5.16
gt; 0.295 0.889
gt; 0.288 0.783
gt; 0.288 0.811
gt; 0.288 0.771
gt; 0.48 2.53
gt; 0.284 0.737
gt; 0.333 1.12
gt; 3.261 44.8
gt; 0.378 1.53
gt; 0.389 1.63
gt; 0.444 1.978
gt; 0.325 0.96
gt; 0.306 0.932
gt; 0.301 0.855
gt; 0.82 6.87
gt; 0.834 7.26
gt; 0.877 6.57
gt; 1.045 9.18
gt; 1.764 18
gt; 3.121 39.9
gt; 4.297 68.9
gt; 4.526 77.6
gt; 3.085 30.5
gt; 0.087 0.061
gt;
gt;
gt;