- Education and Science»
- Geology & Atmospheric Science
How to Create a Sieve Analysis Graph in Excel Spreadsheet? A Step by Step Guide
Gradation Graph: Step by Step Guide
Making reports like such is part of my daily activities at work. So in this topic, I will show you the step by step guide on how to create Gradation Graph also called gradation curve plotted in excel spreadsheet:
1. Establish data series.Consider example below as the resulting data of sieve analysis tests of a soil or aggregates.
2. In the Insert Menu, click Chart.
3. Select XY (Scatter) as chart type and select scatter with data points connected with smoothed lines as chart sub-type, and click Next tab.
4. In the data established, set column A as X-values and column D as Y-values. Click Add tab. Series 1 will appear in the box, it will change if you put a name of your graph. Enter values in X axis by dragging down your mouse shown below at column A from row 3 to row 10.
5. Do the same thing for Y-values and click Next tab.
6. In gridlines tab, tick boxes for X-axis, both minor and major gridlines and major gridlines only for Y-axis. Click Next tab.
7. Click Finish tab.
8. This is how it looks… But we are not done yet. Point cursor in X-axis and right click your mouse. Format axis will appear as shown.
9. In Format axis Tab, tick box Logarithmic scale and set Value (Y) axis crosses at: 0.01 scale, maximum: 100, major unit: 10, minor unit: 10. And click OK.
10. Congratulations, you have now a gradation curve. Modification of the curve is very easy when you know the basic.