Course Content
Excel Essentials
Excel Essentials
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.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.
Everything was clear?
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.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.
Everything was clear?
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.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.
Everything was clear?
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.
Task
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. Choose an Area chart, resize it and move it under the dataset.