Semi-logarithmic grain size distribution curve
ziani
-
Raymond PENTIER Posted messages 58216 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58216 Registration date Status Contributor Last intervention -
Hello,
sieve openings % cumulative sieve residue
0.315 0.2
0.315-0.4 1.15
0.4-0.5 10
0.5-0.63 40.8
0.63-0.8 77.1
0.8-1 94.5
1-1.25 99.4
1.25-2 100
I need to plot the grain size distribution curve for this data in Excel and I don't know how to do it anymore.
the x-axis represents the sieve openings (logarithmic scale) and the y-axis represents the % of cumulative sieve residue
thank you for your help
Configuration: Windows / Chrome 69.1.0.3064
sieve openings % cumulative sieve residue
0.315 0.2
0.315-0.4 1.15
0.4-0.5 10
0.5-0.63 40.8
0.63-0.8 77.1
0.8-1 94.5
1-1.25 99.4
1.25-2 100
I need to plot the grain size distribution curve for this data in Excel and I don't know how to do it anymore.
the x-axis represents the sieve openings (logarithmic scale) and the y-axis represents the % of cumulative sieve residue
thank you for your help
Configuration: Windows / Chrome 69.1.0.3064
9 answers
-
Your "data table" is incomprehensible!
What is 0.315-0.4 1.15?
If "0.315-0.4" is in the first column, it's text and cannot be made into a logarithmic scale!
Why didn't you just attach your Excel file?1) Go to https://www.cjoint.com/
2) Click [Browse] to select your file (max 15 MB)
3) Scroll down to click the blue button [Create Cjoint link]
4) After a few seconds, the second page will display, with the link in bold; right-click on it and choose "Copy link"
5) Return to your discussion on CCM, and in your message, paste it.
=> See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
There are also:
1) https://mon-partage.fr/
2) https://www.transfernow.net/
--
Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA) -
Hello,
If I understood correctly, the representation could look like this:
https://www.cjoint.com/c/JEfmmByONHK -
Désolé, je ne peux pas accéder à des liens externes. Veuillez fournir le texte que vous souhaitez que je traduise.
-
Tell me what is not suitable or what you do not understand in my example.
-
-
for the sieve diameters, the first value is 0.315 mm and the final one for 100% is greater than 1.25 mm.
-
-
Hello ziani.
If you don't read our messages, or if you don't understand them, we will never succeed!
From my very first message #1 at 02:09, I explained to you thatIf "0.315-0.4" is in the first column, it's text and we can't make a logarithmic scale from it!
My friend tontong took the time to detail for you in his example file #2 how to split your diameter ranges into 2 distinct columns; he confirms to you in his message #8 that we cannot work with the text "0.315-0.4" but only with, on one hand, the number 0.315, and on the other hand, the number 0.4!
--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA) -
Mr, I read your messages and your responses, it's just that I didn't understand at first why you added the value 02 and don't forget that I'm not proficient in Excel.
Thank you very much for your help.
