How To Make A Percent Finer Sieve Graph In Excel

sadmin

You need 4 min read

·

Post on Feb 06, 2025

48 visitor like this post

Share

How To Make a Percent Finer Sieve Graph in Excel

Creating a percent finer sieve graph, also known as a particle size distribution graph, in Excel is crucial for visualizing the results of sieve analysis. This graph is essential in various fields, including construction, mining, and pharmaceuticals, to understand the particle size distribution of materials. This guide will walk you through the process step-by-step, optimizing it for both clarity and SEO.

Understanding Sieve Analysis Data

Before diving into the Excel process, let's clarify the data required. Sieve analysis involves passing a sample through a series of sieves with decreasing mesh sizes. For each sieve, you record the mass of material retained on that sieve. To create a percent finer graph, you'll need:

• Sieve Size: The aperture size of each sieve (e.g., 4 mm, 2 mm, 1 mm, etc.). This is usually expressed as the diameter of the square openings.
• Mass Retained: The weight of the material retained on each sieve.
• Cumulative Mass Retained: The cumulative weight of material retained on a given sieve and all sieves above it. This is calculated by summing the mass retained on each sieve progressively.
• Total Mass: The total mass of the sample before sieving.

Calculating Percent Finer

To determine the "percent finer" for each sieve size, use the following formula:

Percent Finer = (Total Mass - Cumulative Mass Retained) / Total Mass * 100

This calculation tells you what percentage of the total sample passed through a specific sieve size. This is the key data for your graph.

Preparing Data in Excel

1. Input Data: Create a table in Excel with columns for "Sieve Size," "Mass Retained," "Cumulative Mass Retained," and "Percent Finer." Enter your sieve analysis data.

2. Calculations: Use Excel formulas to calculate the "Cumulative Mass Retained" and "Percent Finer" columns. For example:

   • Cumulative Mass Retained: If "Mass Retained" is in column B, and the first sieve's retained mass is in B2, the formula in C2 would be =B2. In C3, it would be =C2+B3, and so on. This cumulatively adds the mass retained on each sieve.

   • Percent Finer: If "Total Mass" is in a cell (e.g., D1), and "Cumulative Mass Retained" is in column C, the formula in D2 would be =(D$1-C2)/D$1*100. Remember to use absolute referencing ($) for the "Total Mass" cell so it doesn't change when you copy the formula down.

Creating the Percent Finer Sieve Graph

1. Select Data: Highlight the "Sieve Size" and "Percent Finer" columns.

2. Insert Chart: Go to the "Insert" tab and choose a scatter plot. A scatter plot is ideal because it accurately represents the continuous nature of particle size distribution. Choose the "Scatter with Smooth Lines and Markers" option for a clearer visualization.

3. Format Chart:

   • Axis Labels: Label the x-axis as "Sieve Size (mm)" and the y-axis as "Percent Finer."
   • Title: Add a descriptive title, such as "Particle Size Distribution - Sample X."
   • Gridlines: Add major and minor gridlines to improve readability.
   • Data Labels: Consider adding data labels to show the exact percent finer value for each sieve size.

Optimizing Your Graph for Clarity and SEO

• Use a Logarithmic Scale: If your sieve sizes span several orders of magnitude, consider using a logarithmic scale for the x-axis (Sieve Size). This makes it easier to visualize wide ranges of particle sizes. This is especially useful for fine materials.

• Consistent Units: Ensure consistent units throughout (e.g., mm for sieve size, grams for mass).

• Clear and Concise: The graph should be easily understandable at a glance. Avoid clutter.

• Keywords: Use relevant keywords in the chart title, axis labels, and any accompanying text within your document (e.g., "particle size distribution," "sieve analysis," "percent finer," "cumulative passing").

Conclusion

By following these steps, you can effectively create a professional-looking percent finer sieve graph in Excel. Remember that the clarity and accuracy of your graph are crucial for proper interpretation and communication of your sieve analysis results. This detailed guide, optimized for SEO, will help ensure your content is easily discoverable by those searching for this information online. Remember to always double-check your calculations and data entry for accuracy.