What does the color of your stool indicate about your health. How can the Bristol Stool Chart help you understand your digestive system. Why do changes in stool appearance matter for overall wellness.

Understanding the Bristol Stool Chart: A Window into Digestive Health

The Bristol Stool Chart is a valuable tool used by medical professionals to assess digestive health. This chart categorizes stools into seven distinct types based on their shape and consistency. By understanding these categories, individuals can gain insights into their bowel health and potential digestive issues.

The Seven Types of Stool

1. Type 1: Separate hard lumps, like nuts (hard to pass)
2. Type 2: Sausage-shaped, but lumpy
3. Type 3: Like a sausage but with cracks on its surface
4. Type 4: Like a sausage or snake, smooth and soft
5. Type 5: Soft blobs with clear-cut edges (passed easily)
6. Type 6: Fluffy pieces with ragged edges, a mushy stool
7. Type 7: Watery, no solid pieces, entirely liquid

Types 1 and 2 indicate constipation, while types 6 and 7 suggest diarrhea. Types 3, 4, and 5 are considered normal and healthy stools.

The Rainbow of Stool Colors: What Your Poop Palette Reveals

Stool color can vary significantly and often provides valuable information about your digestive health and overall well-being. While the Bristol Stool Chart focuses on consistency, understanding stool color is equally important.

Common Stool Colors and Their Meanings

• Brown: The most common and typically healthy color
• Green: Often due to diet or rapid intestinal transit
• Red: May indicate lower gastrointestinal bleeding
• Black: Potential upper gastrointestinal bleeding or iron supplements
• Yellow: Possible malabsorption or excess fat in the stool
• White or Clay-colored: May indicate bile duct obstruction

Is green poop normal? Green stools are often harmless and can result from consuming green vegetables or food coloring. However, if persistent, it may indicate that food is moving too quickly through the intestines, not allowing bile to break down completely.

Frequency Matters: How Often Should You Go?

Bowel movement frequency can vary greatly from person to person. While some individuals may have multiple bowel movements daily, others may only go every few days. So, what’s considered normal?

Most health experts agree that having a bowel movement anywhere from three times a day to three times a week falls within the normal range. However, consistency is key. Any significant change in your regular pattern could be a sign of an underlying issue.

Factors Affecting Bowel Movement Frequency

• Diet
• Hydration levels
• Physical activity
• Stress
• Medications
• Medical conditions

How can you improve your bowel regularity? Increasing fiber intake, staying well-hydrated, and maintaining regular physical activity can help promote healthy bowel movements.

The Smell Factor: What Your Stool’s Odor Indicates

While discussing stool odor might seem unpleasant, it can provide valuable insights into your digestive health. The smell of your stool is influenced by various factors, including diet, gut bacteria, and potential health issues.

Common Causes of Unusually Smelly Stools

• Certain foods (e.g., sulfur-rich foods like eggs and broccoli)
• Malabsorption disorders
• Celiac disease
• Inflammatory bowel diseases
• Infections
• Medications

When should you be concerned about stool odor? While occasional changes in smell are normal, persistently foul-smelling stools accompanied by other symptoms like abdominal pain, weight loss, or blood in the stool warrant medical attention.

Size Matters: What Your Stool’s Dimensions Reveal

The size and shape of your stool can provide valuable information about your digestive health and potential issues. While there’s no one-size-fits-all approach to stool dimensions, certain characteristics can indicate healthy or problematic bowel function.

Ideal Stool Characteristics

• Shape: Sausage-like or snake-like
• Length: About 4-8 inches
• Diameter: About 1-2 inches
• Consistency: Soft but formed

Can stool size indicate health problems? Yes, both extremely large and very small stools can be signs of underlying issues. Large, difficult-to-pass stools may indicate constipation, while pencil-thin stools could suggest an obstruction in the colon.

The Floating Phenomenon: When Stools Don’t Sink

Occasionally, you might notice that your stool floats instead of sinking. While this can be alarming, it’s often harmless and related to diet or temporary digestive issues. However, persistent floating stools can sometimes indicate underlying health concerns.

Common Causes of Floating Stools

• Excess gas in the stool
• High-fiber diet
• Malabsorption disorders
• Celiac disease
• Pancreatic insufficiency

Should you be worried about floating stools? Occasional floating stools are usually not a cause for concern. However, if accompanied by other symptoms like weight loss, diarrhea, or oily stools, it’s best to consult a healthcare provider.

When to Seek Medical Attention: Red Flags in Stool Changes

While occasional changes in stool appearance are normal, certain signs and symptoms warrant immediate medical attention. Being aware of these red flags can help you identify potential serious health issues early on.

Warning Signs to Watch For

• Blood in the stool (red or black)
• Persistent changes in bowel habits
• Severe abdominal pain
• Unexplained weight loss
• Chronic diarrhea or constipation
• Pale or clay-colored stools

How quickly should you seek medical attention for stool changes? If you experience any of the above symptoms, especially if they persist for more than a few days or are accompanied by fever or severe pain, consult a healthcare provider promptly.

Promoting Healthy Bowel Movements: Lifestyle and Dietary Tips

Maintaining healthy bowel movements is crucial for overall well-being. By adopting certain lifestyle habits and dietary changes, you can promote regular, comfortable bowel movements and support digestive health.

Tips for Optimal Bowel Health

• Stay hydrated by drinking plenty of water
• Consume a fiber-rich diet with plenty of fruits, vegetables, and whole grains
• Exercise regularly to stimulate bowel movements
• Manage stress through relaxation techniques
• Avoid holding in bowel movements
• Consider probiotics to support gut health

How much fiber should you consume for optimal bowel health? The recommended daily intake of fiber is 25-30 grams for adults. Gradually increase your fiber intake to avoid digestive discomfort and ensure you’re drinking enough water to help the fiber move through your system.

Understanding your stool’s characteristics can provide valuable insights into your digestive health and overall well-being. By familiarizing yourself with the Bristol Stool Chart, paying attention to color, frequency, and other factors, you can better monitor your health and identify potential issues early on. Remember, while occasional changes are normal, persistent alterations in your bowel habits or stool appearance should be discussed with a healthcare provider. By maintaining a healthy lifestyle and being attentive to your body’s signals, you can promote optimal digestive health and catch any potential problems before they become serious.

What Stool Shape, Size, & Smell Can Tell You

Medically Reviewed by Minesh Khatri, MD on November 29, 2022

It can be hard to describe your poop, so doctors use a scale to show the different kinds. It’s called the Bristol stool chart, and it gives you an idea of how long a stool spent in your bowel before heading out.

They’ve spent a long time in your bowel and are tough to pass. If your stool looks like this, you’re probably constipated. If it lasts longer than a couple of weeks, see your doctor to find out what’s causing it.

This stool also can be a sign that you’re constipated. Try to get more fiber in your diet and drink more water to move things along.

Doctors think of this kind of poop as normal, because it’s soft and easy to pass. If things are going as they should, it shouldn’t take longer than a minute on the toilet to push out a poop.

Doctors think of this as poop you want to have. Everyone’s bathroom habits are different, but ideally you should have one of these every 1 to 3 days.

These are easy to pass, but you may feel a sense of urgency about getting to the bathroom. That can be a sign of mild diarrhea. Most of the time, it goes away on its own in a couple of days.

If you have these more than three times a day, you have diarrhea. Make sure to drink plenty of fluids. Water is good, but you also need to replace the minerals you’re losing (called electrolytes). Fruit juices and soup can help.

This stool moved through your bowel very quickly. See your doctor if you have more than three of these a day for longer than 2 days. You should check with your doctor if you also have other signs of dehydration (dry mouth, sleepiness, headache, or dizziness), severe pain in your tummy or rear end, or a fever of 102 degrees or higher.

Your stool comes in different colors, too. The Bristol stool chart doesn’t include color, but you might have questions about that.

The color of your stool depends on a couple of things: your diet and how much bile is in it. Bile is a yellow-green fluid that helps digest fats. A healthy stool, then, should reflect a mixture of all the colors of the food you eat and that bile. Almost any shade of brown, or even green, is considered OK.

It may come as a shock when you see it, but a green poop every once in a while is OK. It may be because you eat a lot of green vegetables (which is good) or too much green food coloring (not so good). It also may mean that your food is moving through your system too quickly — think diarrhea — and the green in your bile doesn’t have time to break down. If the color doesn’t change, see a doctor.

This might be from eating too much red food coloring. It can also come from red-colored medicine. Your stool should soon return to its normal color.

But a bright red stool could mean bleeding in your large intestine. Sometimes it’s blood from your rectum, too, from a scratch or a hemorrhoid. If you keep passing red stools, check with your doctor.

If your stool is black, the cause might be an iron supplement or an over-the-counter medicine you took because your stomach felt bad. Or it could even be all that black licorice you downed the night before. If none of these possibilities ring true to you, check with a doctor. A black stool, or one that appears dark maroon, smells bad, and looks tarry, may be a sign of bleeding from high in your digestive tract, like your stomach.

Yellow stools are fine in breastfed infants, but for others, they could be a sign of too much fat. And that could mean your body’s having trouble absorbing nutrients like it should. See your doctor. Sometimes, stools can be white or chalky-looking, too. That may be a side effect of some medication, but it also could mean your bile duct is clogged. Your doctor can let you know for sure.

IMAGES PROVIDED BY:

1) Brook Rieman / Getty Images

2) WebMD

3) WebMD

4) WebMD

5) WebMD

6) WebMD

7) WebMD

8) WebMD

9) WebMD

SOURCES:

Bladder and Bowel Foundation: “Bristol Stool Chart.”

Cleveland Clinic: “Constipation: 6 Ways to Unblock Yourself. ”

Continence Foundation of Australia: “Bristol stool chart.”

Mayo Clinic: “Dehydration,” “Diarrhea,” “Stool color: When to worry.”

National Institute of Diabetes and Digestive and Kidney Diseases

“Diarrhea,”  “Treatment for Constipation.”

© 2022 WebMD, LLC. All rights reserved. View privacy policy and trust info

Identifying Types of Poop with the Bristol Stool Chart and More

Your stool is basically undigested food, proteins, bacteria, salts, and other substances produced and released by your intestines. What your poop looks like can be important. It could indicate if you’re healthy or have an underlying medical condition.

We all do it. For some, it’s a necessary inconvenience. For others, it’s a pleasant and satisfying part of the digestive process. It has fascinated toddlers since time immemorial, and there’s a reason for that.

Going number two might not be the prettiest topic for a dinner party, but there’s a lot to learn from this mundane yet mysterious, process. In the end (no pun intended), it’s simply a part of our functioning body.

So, what exactly is poop? Although everyone is unique in the size, shape, and smell of their poop, there are a few things that indicate a healthy (or unhealthy) poop.

Healthy poop can be as varied and as unique as the individuals who make it. But there are a few general rules to follow if you want to assess your poo artistry for optimum health.

Color

The poop emoji has one thing right: the brown coloring. The combination of stomach bile and bilirubin, which is a pigment compound formed from the breakdown of red blood cells in the body, gets the credit for this oh-so-lovely shade of brown.

Shape

A somewhat log-like shape is how most poop should come out due to its formation within the intestines. However, as we’ll get to later, there are a variety of shapes that poop can have.

When they differentiate from the log shape, that’s when your poop is trying to tell you something’s up.

Size

Poops shouldn’t come out in small pellets — something else we’ll get to later — but instead should be a couple of inches in length, and comfortable and easy to pass.

Consistency

Anywhere between a firm and soft consistency is pretty much normal. If it sways too much one way or another, it could suggest some digestion or fiber issues.

Length of time

A commonly heard joke is that when someone takes too long in the bathroom, it must mean they’re pooping. A healthy poop, however, should be easy to pass and take only a minute or so to push out.

That said, some people do spend a bit more time on the toilet, so as a general rule, a poop should take no more than 10 to 15 minutes.

Frequency

Fun fact: Did you know most people poop around the same time every day?

On average, a person with healthy digestion will poop anywhere between every other day to three times a day. Any less could suggest possible constipation. This means you need some more water to move the “boat. ”

The Bristol stool chart is an overarching indicator of how and why different types of poops look or feel a certain way. It’s broken up into seven categories based on a 2,000-person study published back in 1992, and it makes poop knowledge basic and easy to understand.

Share on Pinterest

Type 1: Marbles

Appearance: Hard and separate little lumps that look like nuts and are hard to pass.

Indicates: These little pellets typically mean you’re constipated. It shouldn’t happen frequently.

Type 2: Caterpillar

Appearance: Log-shaped but lumpy.

Indicates: Here we have another sign of constipation that, again, shouldn’t happen frequently.

Type 3: Hot dog

Appearance: Log-shaped with some cracks on the surface.

Indicates: This is the gold standard of poop, especially if it’s somewhat soft and easy to pass.

Type 4: Snake

Appearance: Smooth and snake-like.

Indicates: Doctors also consider this a normal poop that should happen every 1 to 3 days.

Type 5: Amoebas

Appearance: Small, like the first ones, but soft and easy to pass; the blobs also have clear cut edges.

Indicates: This type of poop means you’re lacking fiber and should find ways to add some to your diet through cereal or vegetables.

Type 6: Soft serve

Appearance: Fluffy and mushy with ragged edges.

Indicates: This too-soft consistency could be a sign of mild diarrhea. Try drinking more water and electrolyte-infused beverages to help improve this.

Type 7: Jackson Pollock

Appearance: Completely watery with no solid pieces.

Indicates: In other words, you’ve got the runs, or diarrhea. This means your stool moved through your bowels very quickly and didn’t form into a healthy poop.

As with size and consistency, poop’s color can be a helpful signal about what’s going on within your body. As we previously mentioned, varying shades of brown are what’s considered the norm.

Even a hint of green is considered healthy. But if your poop is veering toward other ends of the rainbow, you might want to assess.

Share on Pinterest

Black

If you’ve had licorice, iron supplements, or bismuth medications (such as Pepto-Bismol), that could be the explanation behind black stool. If you haven’t had any of that, black poop could be a sign of bleeding in the upper gastrointestinal tract.

It may seem like red would be a more likely color for this sort of concern, but since it’s taken a while to travel down, it’s older and therefore darker.

Green

While hints of green are quite normal, if your poop has gone from brown to full green, it may mean one of two things. Either you’ve added lots of green foods like spinach to your diet, or your stools passing through you too fast. When it doesn’t pick up as much of the brown-tinting bilirubin, it has more bile salts that turn it this color.

Pale, white, or clay

If your poop is a chalky light shade, it might mean you’re lacking bile. Bile is a digestive fluid that comes from your liver and gallbladder, so if you’re producing white stool, it probably means your duct is blocked.

Pale poop could also be a side effect of certain medications like antidiarrhea medicine. Either way, if it continues, consult a doctor.

Red

You’re probably not surprised to hear that red poop can mean bleeding, either due to hemorrhoids or to bleeding in the lower intestinal tract. If your stool is a little red, however, there may be no need to immediately fret.

There are other, less serious reasons for this change in color. Foods like beets, cranberries, red gelatin, or tomato juice can turn poop red as well.

Yellow

Greasy, stinky, yellow stool is typically a sign of too much fat. This could also be a direct relation to a malabsorption disorder like celiac disease, where your body isn’t absorbing enough nutrients.

If your poop looks bright yellow, it could signify a condition called giardiasis, which is caused by an intestinal parasite in North America and the world. Typically, you can get giardiasis from contaminated water or exposure to a person with the condition.

Every now and again, when you take a look in the toilet bowl, you’ll see poop bobbing like a toy sailboat in the bathtub. As alarming as this seems, all it means is that the stool is less dense than the others that sink.

One potential reason for this lack of density can come from an increased amount of gas or water, or even a high fiber diet.

It’s also possible that malabsorption is, once again, the reason for a floating stool. If this is the case, the other abnormalities previously mentioned, like slight constipation, might also be present.

Constipation is defined as having less than three bowel movements per week.

There could be many reasons you experience this lack of pooping. Nerve issues in and around the colon or rectum may slow down pooping, as can problems with pelvic muscles. Conditions that affect hormones, like pregnancy or diabetes, could also be the culprit.

If you’re experiencing this clogged-up feeling, you can add more high fiber foods to your diet, like beans, vegetables, fruits, and whole grains. Drinking lots of fluids, staying active, and managing stress can also help alleviate constipation.

If a diet change doesn’t seem to get things moving, constipation could be caused by certain medications or even a blockage in the bowel. Talking with a doctor is the best course of action to find relief in this instance.

A green poop here or hard poop there happens to the best of us. It’s when this type of irregularity carries on for more than a day or two that you should take action and talk with a doctor. The same goes for changes in color or consistency, or constipation.

Chronic constipation can obstruct the bowels, while chronic diarrhea can make it difficult for a person to absorb necessary nutrients from food. Both chronic constipation and chronic diarrhea could even be a sign of more serious conditions.

Again, the first sign of either of these should not be immediate cause for concern, but keep an eye on it and see if it lasts more than a few days.

That said, pay attention to any signs of blood. If you haven’t eaten any of the foods mentioned above that could turn your poop this color, talk with a doctor immediately.

As quick as we are to write it off, our poop can provide a wealth of knowledge about our health and ourselves. So next time you pop a squat, take note of what’s going on. The toilet bowl is a window into your health and you.

Read this article in Spanish.

Emily Rekstis is a New York City-based beauty and lifestyle writer who writes for many publications, including Greatist, Racked, and Self. If she’s not writing at her computer, you can probably find her watching a mob movie, eating a burger, or reading an NYC history book. See more of her work onher website, or follow her onTwitter.

Change the colors of the data markers of one row in a chart

Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019for Mac Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2016 for Mac Word 2016 for Mac PowerPoint 2016 for Mac Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 More. ..Less

When creating a single-series chart, all data markers, data data points in that chart, the data series are displayed in the same color. To use different colors for each data marker, you can change the colors automatically using the Change Colors by Points or Change color cuts.

By default, the colors of slices in pie and donut charts can be different, but this option can be turned off if necessary. For example, you might want to display each ring in a donut chart with the same color, rather than different colors.

You can also change colors by changing the color of each data marker manually.

Important: You must have an existing chart in order to successfully complete these procedures. For more information about selecting and adding charts, see Office.

Automatically change all data marker colors by point or slice

org/ItemList”>

1. Click on the chart to select the data series for which you want to change the colors.

2. On the Format tab, in the Current Fragment group, click the Format Selection button.

3. In the area Format data series go to the Fill tab & line , go to the Fill tab and do the following:

   • To change the colors of the data markers on a single chart series, select Change colors by points.

   • To make all data points of a data series display the same color in a pie or foot chart, this flag can be used to display different colors across slices.

Change colors of individual data markers manually

1. In the chart, select the individual data marker you want to change.

2. On the Format tab, in the Shape Styles group, select Shape fill .

3. Do one of the following:

   • To change the fill color, under Theme Colors or Standard Colors , select the desired color.

     Tip: Before applying a different color, you can quickly see how the chart will change. When you hover over different colors, the color of the selected element in the diagram changes accordingly.

   • To remove the color of the selected chart element, select No Fill .

   • To use a fill color that is not in Theme Colors or Standard Colors , click Other Fill Colors . In the Colors dialog box, select the color you want from the Standard or Custom tab and click the OK button.

     Custom fill colors that you create are added to the Recent Colors section so they can be reused.

   • To use a picture to fill the shape, select Picture . In the Insert Picture dialog box, locate and select the picture you want, and then click the Insert button.

   • org/ListItem”>

     To use a gradient effect for the selected fill color, find Gradient and select the desired gradient style.

   • To use a textured fill, find the Texture entry and select the desired texture.

4. Repeat these steps for each data token you want to change.

Tip: For more information about changing the appearance of chart elements, see Office.

Important: You must have an existing chart in order to successfully complete these procedures. For more information about selecting and adding charts, see Office.

Automatically change all data marker colors by point or slice

1. Click on the chart to select the data series for which you want to change the colors.

2. On the Format tab, click a series in the Chart Elements list and select the Format Area button on the ribbon.

3. In area Row format data go to the Fill & Line tab , expand the Fill button and do the following depending on the chart type:

   • org/ListItem”>

     To change the colors of the data markers on a single chart series, select Change colors by points.

   • To make all data points of a data series display the same color in a pie or leg chart, this flag can be used to display different colors cut.

Change colors of individual data markers manually

1. In the chart, select the individual data marker you want to change.

2. org/ListItem”>

   On Format 9 tab0006 click the button Shape fill.

3. Do one of the following:

   • To change the fill color, under Theme Colors or Standard Colors , select the desired color.

     Tip: Before applying a different color, you can quickly see how the chart changes. When you hover over different colors, the color of the selected element in the diagram changes accordingly.

   • To remove the color of the selected chart element, select No Fill .

   • To use a fill color that is not in Theme Colors or Standard Colors , click Other Fill Colors . In dialog in the Colors window, create a custom fill color using the available options and click OK.

     Custom fill colors that you create are added to the Recent Colors section so they can be reused.

   • To use a picture to fill a shape, select the element Picture . In the Insert Picture dialog box, click the desired image and click the Insert button.

   • org/ListItem”>

     To apply a gradient effect to the selected fill color, find Gradient and select the desired gradient style.

   • To use a textured fill, find item Texture and select the desired texture.

4. Repeat these steps for each data token you want to change.

Tip: See this table for more information about changing the appearance of chart elements.

Lab 2 Excel

LABORATORY
JOB NO. 2

Subject: Graphic
data display. Editing
diagrams

Purpose of work:
Teach
students build and edit
charts and graphs in solving problems
economic profile through
spreadsheet processor on a personal
computer.

Brief comment

visual aid
data representations are charts.
They make comparisons easier.
identifying patterns and trends
data.

Microsoft Office Excel 2007
supports various types of charts.
When creating or modifying an existing
diagrams, you can choose one of the many
available chart subtypes of each
type:

Bar graphs
used to show changes
data for a certain period of time
or to illustrate the comparison
objects.

Graphs
allow you to depict a continuous
changing data over time
single scale; thus they
perfect for picture
data trends with equal
intervals. On category charts
data is evenly distributed along
horizontal axis, and the values ​​evenly
distributed along the vertical axis.

Circular
chart
shows the size of the elements of one
row
data
proportionately
the sum of the elements. Row
data – a set of interconnected
data items displayed on
chart. Each row of data on
the diagram corresponds to a single color
or the method of designation indicated on
chart legend. Diagrams of all types,
except circular, may contain several
rows of data.
points
data
– data elements, individual values,
displayed on the chart as bars,
columns, lines, sectors, dots or
other objects called markers
data. Single color data markers
form a series of data.
pie chart are displayed as
percent of the whole circle.

Ruled
diagrams
illustrate the comparison of individual
elements.

Diagrams with
areas
illustrate the magnitude of the change in
depending on time and
be used to attract attention
to the total value according to
with trend.

Spot
chart
shows the relationship between numerical
values ​​in multiple data series
or displays two groups of numbers as
one set of x and y coordinates.

Exchange
chart
most commonly used for
illustrations of stock price changes.
However, this chart can be used
also for the output of scientific data.

Surface
chart
used when looking for
optimal combinations in two sets
data. Like a topographic map
colors and shading highlight areas of the same
value ranges.

Ring
chart
reflects the relationship of parts to the whole,
but may contain more than one.

B bubble
diagram
column data can be displayed
spreadsheet, with the values
along the x-axis are selected from the first column,
and the corresponding values ​​along the Y axis and
values ​​that determine the size of the bubbles,
are selected from neighboring columns.

Flap
diagrams
allow comparison of cumulative values
multiple rows of data.

Practical
task

1. Download MS Excel
   2007.

2. On sheet 1 of the working
   books based on data provided
   in fig. 2.1, create a table. Install
   with sufficient column width
   and the height of the rows, in the “header” of the table
   center the headers.
   Decorate the table with lines.

Rice. 2.1 Table
“Accounting wages for work performed
repair»

3. Run
   calculations where:

“Amount of payment
labor” = “Amount of work” * “Price for
unit”;

“ Surcharge amount”
= “Amount of wages” * “% of additional payment” /
100;

“Sum of all”
= “Amount of payment” + “Amount of additional payment” (in
result display 0 characters after
decimal point and group separator
digits).

4. Build
   histogram with all design
   elements (legend, name
   chart, title on x-axis
   and Y
   and data values) reflecting the “Sum
   payment”, “Amount of additional payment” and “Amount of total”
   in the context of employees:

a)
ordinary;

b)
with accumulation;

c)
with areas (with accumulation).

Place Chart
on the same sheet.

1. Build
   normal histogram. For execution
   of this paragraph must be carried out
   4 steps. In the first step in the menu Insert
   in group
   Diagrams
   select the type of Histogram (Fig. 2.2)

Rice. 2.2 Button
histogram inserts

At the second step in
menu Constructor
in group Data
click
button Select
data ,
this opens a dialog box.
“Selecting a data source” (Fig. 2.3).

Rice. 2.3 Dialogue
window for selecting data source

In this window
set the data range for the chart,
radio button Rows in columns. And then
register rows by clicking the button Edit .
In this case, the new dialog box “Change
row” (Fig. 2.4):

Rice. 2.4 Dialogue
row window

Write similarly
the name of the second and third row. This
allows you to add a legend to the histogram.

At the third step in
menu Layout
in group Signatures
click button Name
diagrams
(Fig. 2.5)

Rice. 2.5 Button
chart title spelling

On the fourth step
you need to choose a location
diagrams. To do this, on the tab Designer
in group Location
click button Move
chart .
This will open a dialog box.
“Chart movement” (Fig.2.6), in
where you can choose one of two options.

Rice. 2.6 Dialogue
“Move Chart” window

Histogram will accept
view (Fig. 2.7):

Rice. 2.7 Plain
chart

2. Build
   stacked histogram max
   close to the sample in Fig. 2.8.

Rice. 2.8 Diagram
cumulative

3. Build
   histogram with areas (stacked)
   as close as possible to the sample
   rice. 2.9

Fig.2.9 Diagram
with areas and accumulation.

5. Build a circular
   chart reflecting the “Sum of all” in
   in the context of workers (Fig. 2.10).

Fig.2.10 Circular
chart

6. Run
   working preview
   books, keep the book in your family
   folder named lr2zad1 .

7. On sheet 2 of the working
   books based on data provided
   in fig. 2.11, create a table. Install
   with sufficient column width
   and the height of the rows, in the “header” of the table
   center the headers.
   Decorate the table with lines.

Rice. 2.11 Table
“Fodder consumption by types of livestock and their
zootechnical assessment”

8. Run a calculation
   indicators column 4 and 7 up to
   hundredths according to the following formula:

“Consumption c. ed.”
= “Consumption, c” * “Feed units in 1 kg
feed” / 100.

9. In the lower part
   calculate tables according to the same columns
   totals using the button Autosum.

10. Build a roundabout
    diagram showing
    actual feed consumption by species
    cattle on the model of fig. 2.12

Rice. 2.12
Ring diagram

11. Build a circular
    diagram showing
    actual feed consumption for dairy
    herd according to the model of Fig. 2.13.

Rice. 2.13
Circular
chart

12. Build a ruled
    diagram showing
    zootechnical assessment of feed by species
    cattle on the model of fig. 2.14.

Rice. 2.14 Ruled
chart

13. Build a chart
    with areas reflecting
    actual feed consumption by species
    cattle on the model of fig.