Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Creating a Basic Chart | Visualizing Data with Charts and Graphs
Excel Essentials
course content

Contenido del Curso

Excel Essentials

Excel Essentials

1. Introduction to Excel
2. Entering and Formatting Data
3. Basic Formulas and Functions
4. Advanced Formulas and Functions
5. Data Management and Analysis
6. Visualizing Data with Charts and Graphs
7. Working with Worksheets and Workbooks

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.

Tarea

  • 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.

Tarea

  • 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

¿Todo estuvo claro?

Sección 6. Capítulo 2

Elige tu 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.

Tarea

  • 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.

Tarea

  • 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

¿Todo estuvo claro?

Sección 6. Capítulo 2

Elige tu 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.

Tarea

  • 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.

Tarea

  • 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.

¿Todo estuvo 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.

Tarea

  • 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.

Sección 6. Capítulo 2
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt