Complete Excel Course for Beginners

4.25

(16)

37 pages

All courses > Information Technology > Excel, Word, LibreOffice and more ( Office ) ::

basic graphics

Capítulo 13

Estimated reading time: 2 minutes

Listen in audio

0:00 / 0:00

Charts are one of Excel's most powerful tools for visualizing and understanding data. They allow you to present information clearly and concisely, making it easier for the audience to understand what is being communicated.

Graphics Types

Excel offers a variety of chart types, each with their own advantages and disadvantages. Here are some of the most common types:

Column chart: used to compare values between different categories;
Line chart: used to show trends over time;
Pie chart: used to show the proportion of each category in relation to the whole;
Bar chart: similar to the column chart, but with the bars horizontal instead of vertical;
Scatter chart: used to show the relationship between two variables;
Area chart: used to show change over time;
Radar chart: used to compare values in different categories on a radial axis.

Creating a basic chart

To create a chart in Excel, follow these steps:

Select the data you want to include in the chart;
Click the "Insert" tab on the ribbon;
Click on the type of chart you want to create;
The chart will be created and displayed on the worksheet.

You can customize the chart in many ways, such as changing the colors, adding data labels and legends, and adjusting the axis scales. To do this, click on the graphic and use the tools available on the "Design" and "Format" ribbon.

Tips for creating effective graphics

Here are some tips to help you create graphics that effectively communicate your information:

Continue in our app.

You can listen to the audiobook with the screen off, receive a free certificate for this course, and also have access to 5,000 other free online courses.

Or continue reading below...

Download the app

Choose the right chart type for your data;
Use consistent colors and fonts throughout the chart;
Add data labels and legends to make the graph easier to understand;
Remove unnecessary elements like gridlines to keep the chart clean;
Use an appropriate scale for the axes to avoid distortion;
Avoid overloading the chart with too much information;
Use charts to supplement your data, not replace it.

With these tips in mind, you can create effective graphics that will help communicate your information clearly and concisely.

Now answer the exercise about the content:

_What is the most suitable type of graph to show the proportion of each category in relation to the whole?

You are right! Congratulations, now go to the next page

You missed! Try again.

The pie chart is the most suitable type of graph to show the proportion of each category in relation to the whole as it visually represents parts-to-whole relationships, allowing easy comparison of categories.

Next chapter

pivot tables