You will learn how to select data, insert charts, and position them for optimal visibility. This foundation will help you create charts that effectively communicate your data.

Key Points

Use the quick access buttons to quickly choose the right charts;
Move and resize your charts to make them easily understandable;
Use the CTRL key to choose nonadjacent cells.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Mark tasks as Completed

Все було зрозуміло?

Секція 6. Розділ 2

Choose your plan

Creating a Basic Chart

Now, let's unlock the art of crafting visually appealing and insightful charts in Excel.

We'll focus on the basics of creating your very first chart, transforming raw data into a visual masterpiece that speaks volumes.

You will learn how to select data, insert charts, and position them for optimal visibility. This foundation will help you create charts that effectively communicate your data.

Key Points

Use the quick access buttons to quickly choose the right charts;
Move and resize your charts to make them easily understandable;
Use the CTRL key to choose nonadjacent cells.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Mark tasks as Completed

Все було зрозуміло?

Секція 6. Розділ 2

Choose your plan

Creating a Basic Chart

Now, let's unlock the art of crafting visually appealing and insightful charts in Excel.

We'll focus on the basics of creating your very first chart, transforming raw data into a visual masterpiece that speaks volumes.

You will learn how to select data, insert charts, and position them for optimal visibility. This foundation will help you create charts that effectively communicate your data.

Key Points

Use the quick access buttons to quickly choose the right charts;
Move and resize your charts to make them easily understandable;
Use the CTRL key to choose nonadjacent cells.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Все було зрозуміло?

Now, let's unlock the art of crafting visually appealing and insightful charts in Excel.

We'll focus on the basics of creating your very first chart, transforming raw data into a visual masterpiece that speaks volumes.

You will learn how to select data, insert charts, and position them for optimal visibility. This foundation will help you create charts that effectively communicate your data.

Key Points

Use the quick access buttons to quickly choose the right charts;
Move and resize your charts to make them easily understandable;
Use the CTRL key to choose nonadjacent cells.

Завдання

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.

Секція 6. Розділ 2

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів