British Technology Awards What is the tolerance for compression test results of concrete, according to the standards? it knows every detail of soil characteristic, minerals, permeability, etc., but does not show the groundwater quality that might be contaminated with leachate. However, the proctor results seem reasonable for this material. The data collected from this lab refutes this hypothesis because the results were unexpected. Plot all 4 series of data on the same Excel figure. To do so manually, enter =NA(). Weight of cylinder + compacted soil the highest discharge flow rate reached up to 3 l/s. In other words, after removing this option, the charts are the same as they were in Figure A. if one beaker had more than another, there would be more solution to act on the meat. Click Find & Select in the Editing group on the Home tab and then choose Replace from the dropdown, or press Ctrl + H. If necessary, click Options to display more settings. The Westminster Awards, Indian Power 100 For each of the initial points, the mass and the unit weight of the soil will increase as the additional moisture lubricates particles and allows them to be consolidated into a denser state (fewer air voids) using the same compactive effort. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. As for now, weve inserted a Scatter Plot using the reciprocals. 6.12. The IF() function returns #N/A if the result is zero (Figure I): The examples contrived, but dont let that bother you. In a perfect world if you knew the exact figure for the entrained air voids, say 2.36% e.g., then your plotted voids line would go through each wet point of the proctor curve, however, it still wont be precise because the proctor curve is simply a line of best fit through four or more data points which each have their own vagaries of precision. 3. material placed dry will collapse under high overburden. Explains how they calculated the density of the unknown metal by taking the mass and dividing it by the volume. the other best fit lines also have r2 values close to unity. Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a parts function at the center of their design considerations. Or does this invalidate the proctor curve? The setting for the secondary vertical axis only affects the secondary horizontal axis. The modified Proctor test was introduced in 1958 as ASTM D1557 and AASHTO T 180 to help with these applications at higher loads. Zwizek Komunalny Gmin "Komunikacja Midzygminna" w Olkuszu. Sharing best practices for building any app with .NET. The approximate optimum moisture of most cohesive soils can be estimated by manually squeezing a portion into a lump that will stick together yet break cleanly into two sections when bent. You should be somewhere around 90 percent saturation. The Format Data Series pane appears. Explains that the current waste disposal site of tunceli, turkey, is not suitable for this purpose. NOTE: There are variations of test procedures noted in both the standard and modified test methods that are dictated by the maximum particle sizes of the soil samples. Height of cylinder = 11.6 cm At the same time, field compaction equipment was becoming larger and more efficient, making it possible to compact soils to higher densities at lower moisture contents. Plot the line of optimums. The results are plotted with moisture on the horizontal axis and dry unit weight on the vertical to form a curve that defines maximum dry density and optimum moisture content. For standard Proctors, the hammers weigh 5.5lb (2.5kg) and drop 12in (305mm). Choose a preferable plot design. Draw the graph between Dry Density VS water content, calculate the dry density from the compaction test results, and Zero Air void . Also, plot the 70%,80%, and 90% saturation curves. Explains that it can be shown that h v0.8 for sufficiently high fluid velocity. 32 641 39 14; sekretariat@zkgkm.pl; Al.1000-lecia 2c 32-300 Olkusz; Dostosuj wygld: Menu gwne. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. dry unit weight vs moisture content for the soil. Excel Map Chart Not Working (11 Possible Solutions), How to Create Scatter Plot Matrix in Excel (With Easy Steps), How to Draw 3-Axis Scatter Plot in Excel (with Easy Steps), SUMIFS to SUM Values in Date Range in Excel, Formula for Number of Days Between Two Dates. lettre d'adieux avant de mourir . The degree of saturation is a variable, (both from material to material and at different %compaction in the same material), and as such is not a reliable way of checking a proctor curve. Now in order to create a scatter plot for this data in Excel, the following steps can be used: Select the dataset and click on the 'Insert' tab. Density Determination No. 7.5 The Zero Air Voids Line. Stacked bar chart: Shows four stacks for the months without a zero value. When the required densities are hard to reach in the field, the moisture content should be compared to the optimum moisture content from the lab tests. c. Height of rammer fall = 30 cm d. Volume of cylinder = 944 cc Changing The Line Soils are the most basic and least expensive construction materials available. Now, lets make this work and use Excels Replace feature to replace the zero values in the example data set with the NA() function: Figure G above shows the settings and the results. Read More: Plotting Row Number Instead of Value in Excel (with Easy Steps). In the Show empty cells as: options box, click Gaps, Zero, or Connect data . The modified Proctor method uses a 10lb hammer with 18in (457mm) drop height for compaction. A Lineweaver Burk Plot is the graphical representation of the Lineweaver Burk Equation. The zero air void line doesnt intersect the curve attained on Dry density v/s Water content graph because soil can never achieve zero void condition with any kind of compaction. Select the data set. Any soil that is compacted will not be fully saturated - hence, as you are plotting dry unit weights, you must have air in many of the voids. Select a countryland IslandsAfghanistanAlbaniaAlgeriaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelauBelgiumBelizeBeninBermudaBhutanBoliviaBonaire, Saint Eustatius and SabaBosnia and HerzegovinaBotswanaBouvet IslandBrazilBritish Indian Ocean TerritoryBritish Virgin IslandsBruneiBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos (Keeling) IslandsColombiaComorosCongo (Brazzaville)Congo (Kinshasa)Cook IslandsCosta RicaCroatiaCubaCuraaoCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHeard Island and McDonald IslandsHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIsle of ManIsraelItalyIvory CoastJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKuwaitKyrgyzstanLaosLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacao S.A.R., ChinaMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNetherlands AntillesNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth KoreaNorwayOmanPakistanPalestinian TerritoryPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalQatarRepublic of IrelandReunionRomaniaRussiaRwandaSo Tom and PrncipeSaint BarthlemySaint HelenaSaint Kitts and NevisSaint LuciaSaint Martin (Dutch part)Saint Martin (French part)Saint Pierre and MiquelonSaint Vincent and the GrenadinesSan MarinoSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth Georgia/Sandwich IslandsSouth KoreaSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan MayenSwazilandSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks and Caicos IslandsTuvaluUgandaUkraineUnited Arab EmiratesUnited Kingdom (UK)United States (US)UruguayUzbekistanVanuatuVaticanVenezuelaVietnamWallis and FutunaWestern SaharaWestern SamoaYemenZambiaZimbabwe, By registering, you agree to the Terms of Service and Privacy Policy .*. On the Data tab, click Filter in the Sort & Filter group. d = G w 1 + e. From above formulas, it can be concluded that. All Rights Reserved. How to Make a Lineweaver Burk Plot in Excel (with Easy Steps), Step-by-Step Procedures to Make a Lineweaver Burk Plot in Excel, Step 3: Modifying Scatter Plot to Make a Lineweaver Burk Plot in Excel, How to Create a Chart from Selected Range of Cells in Excel, Plotting Row Number Instead of Value in Excel (with Easy Steps), How to Plot Multiple Lines in One Graph in Excel, Plot Graph in Excel with Multiple Y Axis (3 Handy Ways), Automatic Ways to Scale Excel Chart Axis (2 Suitable Ways), [Fixed!] Explains that soils consisting of clay or silts size particles are rarely encountered. Some methods and materials require adding coarse native material back into the final specimen. The zero Air Void line is obtained when there is no presence of the air in the pores of a soil mass and totally filled with the water and soil mass get saturated. 2. material placed dry of optimum will swell under low overburden. Describes the hydrometer test using 50 g of air dry soil mixed with dispersant solution in a mechanical shaker for 4 hours. Sample Field moisture can be adjusted by aerating/discing the soil or by adding water. Global Britain Awards After about the third point (if youre lucky and your estimates were correct), the mass of the sample will decrease as the volume of water reaches a point where it displaces soil particles in a given volume. Conclusion. I need to figure out a way not to plot those errors and zeros. For this demo, he uses Microsoft Office 365. Go through the following steps to make a Lineweaver Burk plot in Excel. Click on Hidden and Empty Cells in the bottom left of the Select Data Source dialog that appears. In-place measured densities of the compacted fill are compared to the Proctor test results to determine the degree of soil density. Successful IT departments are defined not only by the technology they deploy and manage, but by the skills and capabilities of their people. -- Select 'Design' -- that . The zero air voids (ZAV) line is the combination of moisture and density that produce complete saturation of the soil or the d obtained when there is no air in the void spaces. Since S = 1 when the saturation is equal to 100 percent, the relationship: Gsw=e can be substituted into the above equation (7.6) to yield the final equation for the ZAV line: Great British Brands Awards This is the best alternative to toggling back and forth with one data set. In this article, we demonstrate step-by-step procedures to make a Lineweaver Burk plot in Excel. Is this normal with very poorly graded clean fine sands? The dry density at 100% saturation being a non - linear function of the void . Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. The moist density, or unit weight, of each compacted specimen is computed by dividing the mass of the soil (minus the mold assembly) by the volume of the mold. Figure 4.2 shows the result of liquid limit. Experts are tested by Chegg as specialists in their subject area. In biochemistry, the Lineweaver Burk Equation of energy kinetics results in a Lineweaver Burk Plot also known as a Double Reciprocal Plot. However, Excel wont display them; thus, this method has no impact. Home. Heres how it works: Youll notice that the results are similar to those seen earlier in Figure B: Because these methods are so easy to apply, try deleting the zeros or formatting them first. The data used in this video is taken from the book titled Principles of Geotechnical Engineering 9th Edition by Braja M Das and Khaled Sobhan. Analyzes the polluted soil transport from natural soil of the site through leachate and seasonal precipitation to pulumur river. Test procedures are similar, but the laboratory compactive effort of the modified method is higher. However, the line chart has a serious flaw: The line is solid, and April is the same value as March distributing this chart as-is would be a serious mistake. Basic formula for density (note: m = W/g) = m V. The following formulas are taken from unit weights of soil: = ( G + S e) w 1 + e. = ( G + G w) w 1 + e. d = G w 1 + e. s a t = ( G + e) w 1 + e. Gilson supplies a complete line of soil compaction and Proctor equipment and accessories. The lockdown for corporate events has now been in place for over 12 months and this has had a catastrophic effect on many events and hospitality businesses, including our Licensees. Zero air voids cannot be achieved with standard compaction the closest you will get is about 2% air voids. What must be the maximum dry density of Granular Sub Base & Wet Mix Macadam used What is the Safe Bearing Capacity values for Different Soils? China Power 100 Any ideas? Also plot the 70, 80, and 90% saturation curves. The Zero Air Voids Line . they plot the compaction curve i.e. The standard and modified Proctor test procedures are straightforward. The stacked bar chart displays only two stacks for the months that have a #N/A value, which is what we saw in Figure A. Finally, the Lineweaver Burk plot may look like the screenshot below. Recommends investigating the groundwater contamination, referring to the leachate leakage. Method 1. By If you work through the instructions with our demonstration workbook file, undo each solution before you start the next. The zero air voids (ZAV) line is the combination of moisture and density that produce complete saturation of the soil or the d obtained when there is no air in the void spaces. Explains that double-pipe, were studied in this experiment for their feasibility for scale up. Explains that part cdetermining the density of an unknown solid was conducted on the second day. Written by. All rights reserved. The manual soil compaction hammers are lifted to their maximum height and allowed to fall freely onto the soil specimen for the required number of blows. The reason is that the material in the proctor test has not achieved true ZAV, there are still some voids entrained in each particle of soil and aggregate. In the Display Options For This Worksheet section, choose the right sheet from the drop-down menu. Before you try this next formatting option, reset the Advanced option that you disabled in our previous step. 2. Uncheck the Show A Zero In Cells That Have Zero Value option, as shown in. Y-axis of the Lineweaver Burk plot that is reciprocal of velocity, [1/Vo]. Manufacturing, THE BRITISH PUBLISHING COMPANY COPYRIGHT 2022. Example in Original Condition: (Chart Tools) Design > Add Chart Element > Axes > Secondary . Keep in mind this next formatting approach has varied results. Click OK to filter the column, which will filter the entire row. Explains that the duration of water pressure exposed increases on the subsoil, causing liquefaction potential, and increasing permeability. British Asian Awards I know the following equations - IF(equation=0,"") and IFERROR(equation,""). The zero air void line doesn't intersect the curve attained on Dry density v/s Water content graph because soil can never achieve zero void condition with any kind of compaction. When you join you get additional benefits. Find the reciprocals of both raw data (i.e., Highlight the reciprocals, leaving the first non-value entries, and then go to, Click on a point on the plot, then right-click on it. We have received your request and will respond promptly. 10:10 AM The line joining the peaks of the curves, termed the line of optimums, follows the general shape of the zero air voids line or the saturation line. Explains the r2 value for the high cold flow rate data in the plate. san bernardino national forest hiking map. It is determined by the compaction test of a soil. soil sample. Explains that rpp requested an evaluation regarding the type of operating system and whether a special, heavy-duty tablet would be required. However, regularly reviewing and updating such components is an equally important responsibility. Compute the degree of saturation at the optimum point for data in column A. d. Plot the 100% saturation (zero air voids) curve. Suppose youre working with the results of formulas that might return zero instead of an error value as shown in Figure G. In that case, you can use an IF() function to return the #N/A error using the following syntax: The MIN() function returns the minimum value for each month. The pie and single-line charts reflect the data in column B for Vendor 1. The Minimum column returns the minimum value for each month, so April, May and July return zero for the minimum value. Cause. Alternatively you could group the columns if they are zero. Moisture content = Weight of water / Weight of dry sample or w = [(W_(tin+soil )- W_(tin+dry soil))/(W_(tin+dry soil) - W_tin )] x 100 7.1 Average moisture content of specimen, w w = (wt + wm + wb)/3 7.2 The dry unit weight of the specimen can be calculated as follows: Let weight of empty mold = W Weight of mold and compacted soil = W1 Volume of mold, V = 1/30 ft3 (1000cc) Water content of compacted soil = w Moist Unit weight of compacted soil = W1- W = 7.3 V Dry unit weight or dry density, d = Small voids can be manually filled with excess samples. Wet density(gm /cc) Copyright 1998-2023 engineering.com, Inc. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Explains that gs and w are constants for a given soil, so the zav line is linear function of water content. But theoretically speaking we can calculate the dry density for zero air voids. British Charity Awards how to plot zero air void line in excel icivics philosophically correct answer key I have a big chunk of values (populated using equations), 1000 rows, and 4 columns. how to plot zero air void line in excel. The saturation curve, or zero air voids curve, is a plot of soil density vs moisture at a theoretical 100% saturation level (zero air voids). We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Sample it refers to the plastic limit and liquid limit of the soil. For most standard and modified Proctor variations, this means reducing the finer materials to pass through either a 4.75mm (#4) or a 9.5mm (3/8in) sieve. the peak represents the maximum dry density (dmax) and corresponding optimum moisture content for a given compactive effort. Posted on . Explains the proctor test, which determines the optimal moisture content at which a given soil type will become most dense and achieve its maximum dry density. It is non -linear function of void ratio. Explains that a particle size distribution was obtained by the combination of dry sieve test and hydrometer test (bs1377-2:1990). Step-by-step solution 100% (8 ratings) for this solution Step 1 of 4 Determine the zero-air voids unit weight of the soil using the formula. Opines that a study on groundwater contamination could focus on ph, and organic contaminant brought by leachate. 2009-2021 The Constructor. Dry Unit Weight Determination Opines that the piping system should be better studied so that valves can be set up. Use the three sets of mass and volume measurements to find the three density values for the water. Back in the lab, processing of the samples begins with gradual air-drying to the desired moisture, usually around 10% or more below the anticipated optimum moisture. Explains that the experiment will be conducted at room temperature, although a more scientific method would be the use of an osmosis method. If youre working with a Table object, you can skip this step because the filters are already there. The plot is used to compare with no inhibitor to identify the effectiveness of the inhibitor. Pakistan Power 100 (See Figure 1.) by . Explains that the hydrometer test covers the quantitative determination of the particle size distribution in a soil from coarse sand size to clay size. Excel wont chart #N/A error values. The mold with the sample is then weighed and recorded, and the soil is extruded from the mold. Some of the cells (random) have either zero value or error value. 0 Likes. When preparing individual compaction specimens, it doesnt take much time to prepare a couple of extra in case your estimates are a bit off. Call breaded ham and cheese breakfast bars school| ap human geography frq 2018 student samples or metrotown food court hours You can then use these results, along with the Grading and Degree of Saturation to calculate the true line for that particular material. density to moisture content curve, air void and zero void line |soil mechanics | Multi Experts Tutor - YouTube 0:00 / 6:01 Soil Mechanics 1 density to moisture content curve, air void. Explains that the soil sample consists of 0% gravelly, 11% sandy, 64% silty, and 25% clayey size grains. Explains that the data obtained in this experiment are consistent with this theory. British Diversity Awards RA rakesh_agrawal Replied on March 30, 2015 Report abuse Hi, Explains that the wilson plot method uses the fact that when the velocity of the hot fluid in a heat exchanger is varied, the only resistance to heat transfer that changes is. Exceptional Organisations & Leadership Awards Jun 02 2022 Select Moving Average, then set the Period to (for example) 100. This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Advises to write down a reminder to make sure the connector is placed higher than the syringe. Explains how they obtained an unknown metal with an identification number (6) from the instructor. Heavy-duty plastic freezer bags are a convenient option for the storage and moisture conditioning of individual compaction specimens. Plot empty cells as interpolated. Four or five specimens are prepared for the compaction points with increasing moisture content that will bracket the estimated optimum water content. Explains that standard, modified and reduced compactive effort were used in proctor compaction test. I have another video on how to plot a particle size distribution link down below.https://youtu.be/l9mfvfmeXWg`Timestamps:0:00 - Introduction0:35 - Moist Unit Weight Calculation1:58 - Dry Unit Weight Calculation2:38 - Zero Air Void Line3:20 - Graph Plotting4:26 - Graph Formatting5:28 - Finding the Optimum Moisture Content Transpiration is the process of water traveling through the plant to allow nutrients in and to cool the plant. But asI stated the ZAV curve is much higher than the plotted proctor curve. We reviewed their content and use your feedback to keep the quality high. In view of this Omnicom Holdings Ltd (BVI) has now withdrawn ALL License agreements within the terms of agreement with all its UK and European Licensees. Unfortunately, this simplest approach doesnt always work as expected: If you removed zero values in the sheet during this phase, re-enter them before continuing to our next example. 2023 TechnologyAdvice. Copyright 2023 GlobalGilson.com. Plot a graph of zav vs. moisture content. Explains that atterberg test results indicate that subsoil of the site is non-plastic samples. I include this step in our tutorial to keep you from wasting your time on this technique yourself. But this does not mean that 15% air void is equal to an 85% degree of saturation. It is important to read and understand your particular test method carefully, as there areseveral variables that can affect this stage of sample preparation. Which is the code used for the design of the RCC Bridge? The truth is, youre unlikely to need this expression because most functions and expressions return the #NA error value if they try to evaluate one. But no matter how hard we try we cant eliminate all the air voids and get zero air voids. I need to figure out a way not to plot those errors and zeros. Opines that geo-environmental study is a good method that can investigate the site. The charts treat the zero values as if theyre still there because they are. Argues that filling the tank to about half capacity would produce more stable cold flows and reduce time until full. My theory being that: 1. material placed dry of standard optimum moisture may have satisfactory performance when you proof roll - but will deteriorate over time. I tried to use IF(And(. but that didn't work. When you dont want to display zero values, you have a few choices for how to hide or otherwise manage those zeros. the soil was washed with distilled water and resieved down to the 63 m size. Best practices and the latest news on Microsoft FastTrack, The employee experience platform to help people thrive at work, Expand your Azure partner-to-partner network, Bringing IT Pros together through In-Person & Virtual events. woofar - maybe I'm not seeing your point - but who cares about the entrained air (. If youve been staying away from the gym lately, you might want to call in a favor or two, or better yet, consider a. Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart. In the resulting dialog, click the Hidden and Empty Cells button in the bottom-left corner (. Effect of compactive effort on compaction. for specific gravity values of 2.5, 2.6, 2.7, 2.8. A) The functions for the problem would look like p=800*0.95*t and 0=50*1.15*t. P represents the pine, After calculating all the values, we put it in a graph to compare the density, mass, and volume by using. Create a helper column and add your date and time so it's in one value. Illustrates the heat duties on the hot and cold sides of the figure. st francis of assisi high school fees zimbabwe. SLAs involve identifying standards for availability and uptime, problem response/resolution times, service quality, performance metrics and other operational concepts. Please let us know here why this post is inappropriate. Depending on how much charting you do, you might find more than one of these methods helpful. calculations must be shown. June 7, 2022 . I know there are possible variations in soils but 14 lb seems like a big gap. 29. how to plot zero air void line in excel. You'll get a detailed solution from a subject matter expert that helps you learn core concepts. Right click the line and click Format Data Series. We hope that you have found this blog post helpful in understanding the procedures and equipment used to perform the Proctor compaction tests of soils by the noted ASTM/AASHTO methods. Explains that part bdetermining the density and the thickness of aluminum foil, was conducted on the second day. Trade Route USA If field moistures differ more than 2% or 3%, it becomes more difficult to compact to the required density. Full 100% saturation. Explains that the zero air voids (zav) line is the combination of moisture and density that produce complete saturation of the soil. In 1933, Ralph R. Proctor, a resident engineer for the Los Angeles Department of Water and Power, established a laboratory procedure to define the practical maximum density of a soil sample along with the optimum moisture content needed to achieve that density. Stretching the scatter plot Trendline Backward results in a Lineweaver Burk plot. My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. None of the charts display the #N/A error values, but they still display the category label in the axis and the legend, similar to the results shown in Figure B. the soil tested is fined soil where more than 35 % of soil is passing through 0.06 mm. But is there a way to combine IF and IFERROR? Sometimes the compacted soils had passing density tests based on standard Proctor values but were still deflecting too much under load to carry the increased forces. There could also be variability in the test results. British Education Awards Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Opines that the study focused on the mineral and soil characteristic to investigate a site, and less focus on organic contamination that might happen to the unsanitary landfill. Some of the cells (random) have either zero value or error value. If so, on the Chart Design ribbon, choose Select Data (or right-click on the line and choose Select Data) and look for the option where you can tell Excel how to treat Hidden and Empty Cells. Autor de la entrada Por ; Fecha de la entrada austin brown musician; matrix toners for bleached hair . After setting up the data, users need to insert a Scatter Plot. Average moisture content (percent) However, thats not always practical. Line chart: Drops to zero on the X-axis. But because the soil is a natural material and the ideal moisture content and maximum dry weight varies for each soil type, the questions of the best unit weight and ideal moisture content couldnt be answered.