Draw the whole function first, and then erase the outside according to the given domain.

How to make piecewise function images with excel?

You touched the S value, so you should also enter the N value in a certain column. For example, in column b, enter:

0, 1, 2, 3 ... and then enter the formula in column C.

Select these two columns, insert/chart(2007 version seems to be the same), then select the "polyline" shape and follow the wizard.

How to draw a piecewise function image

1. basin

Besides vitamins A, B 1 and B2, the most important thing is cellulose and minerals.

It can help to drain waste and accumulated water from the body.

2. Sesame

Its "linseed oleic acid" can remove cholesterol attached to blood vessels, make metabolism better and lose weight much easier.

banana

Although high in calories, but low in fat, and rich in potassium, full and low in fat.

It can reduce fat accumulation and is an ideal food for losing weight.

4. Apple

Apple contains unique malic acid, which can accelerate metabolism and reduce lower body fat.

Moreover, it contains more calcium than other fruits, which can reduce the salt in the lower body that makes people edema.

5. adzuki bean

Alkaloids contained in red beans can increase the peristalsis of large intestine, promote urination and reduce constipation, thus removing fat.

6.papaya

It has a unique proteolytic enzyme that can remove the fat accumulated in the lower body due to eating meat.

Moreover, pectin contained in papaya meat is an excellent intestinal lavage agent, which can reduce the accumulation of waste in the body.

7.watermelon

He is a diuretic expert who eats raw fruit. Eating more can reduce the residual excess water in the body.

Moreover, there is not much sugar in itself, and if you eat too much, you will not get fat.

8. eggs

Vitamin B2 in eggs helps to remove fat. In addition,

It contains nicotinic acid and vitamin B 1, which can remove body fat.

9.grapefruit

It has long been known that grapefruit is extremely low in calories and will not gain weight if you eat more.

But as it turns out, it is also rich in potassium, which helps to reduce the accumulation of fat and water in the body.

10. konjac

It is completely fat-free and delicious. In the final analysis, it is also a must to lose weight.

It turns out that its rich plant fiber can make the lymph in the lower body smooth and prevent leg edema.

1 1. spinach

Because it can promote blood circulation, so that the leg farthest from the heart,

They all absorb enough nutrients, balance metabolism, detoxify and lose weight.

celery

On the one hand, celery contains a lot of calcium, which can supplement "foot strength".

On the other hand, it also contains potassium, which can reduce the accumulation of water in the body.

peanut

Rich in vitamin B2 and nicotinic acid, bringing high-quality protein,

Long meat does not grow fat, and secondly it can eliminate body fat and fat.

14. Kiwifruit

In addition to vitamin C, it is also rich in fiber.

It can increase the speed of decomposing fat and avoid excessive fat accumulation.

15. Tomato

Eating fresh tomatoes can induce diuresis, eliminate leg fatigue and reduce edema.

If it is eaten raw, the effect will be better.

How to draw a piecewise function diagram with excel, as shown in the following formula:

If the data X is put in A 1 and the function value Y is put in B 1, then enter in B 1:

=IF( 1 5，A 1*A 1*A 1，" ")