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.

Tarefa

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.

Tarefa

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

Tudo estava claro?

Seção 6. Capítulo 2

Escolha seu plano

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.

Tarefa

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.

Tarefa

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

Tudo estava claro?

Seção 6. Capítulo 2

Escolha seu plano

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.

Tarefa

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.

Tarefa

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.

Tudo estava claro?

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.

Tarefa

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.

Seção 6. Capítulo 2

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo