ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to draw chart: log scale on X axis, natural scale on y axis? (https://www.excelbanter.com/charts-charting-excel/119038-how-draw-chart-log-scale-x-axis-natural-scale-y-axis.html)

Pratap D. chavan November 16th 06 07:21 AM

How to draw chart: log scale on X axis, natural scale on y axis?
 
How to draw chart: log scale on X axis, natural scale on y axis? sample data
is given below. This chart is used for Civil Engineering?

X axis Y axis
Sieve size % passing
26 mm 100
22 mm 95
16 mm 81
12 mm 75
10 mm 66
4.8 mm 52
2.4 mm 42
1.2 mm 32
0.6 mm 18
0.3 mm 16
0.15 mm 9
0.09 mm 3


David Biddulph November 16th 06 09:03 AM

How to draw chart: log scale on X axis, natural scale on y axis?
 
Right-click on the X-axis, select Format Axis, choose the "Scale" tab, and
tick the "logarithmic scale" box.

You will, of course, need to be using the XY chart (confusingly named
scatter), rather than a line chart.
--
David Biddulph

"Pratap D. chavan" <Pratap D. wrote in
message ...
How to draw chart: log scale on X axis, natural scale on y axis? sample
data
is given below. This chart is used for Civil Engineering?

X axis Y axis
Sieve size % passing
26 mm 100
22 mm 95
16 mm 81
12 mm 75
10 mm 66
4.8 mm 52
2.4 mm 42
1.2 mm 32
0.6 mm 18
0.3 mm 16
0.15 mm 9
0.09 mm 3





All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com