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:

  1. Select the data you want to include in the chart;
  2. Click the "Insert" tab on the ribbon;
  3. Click on the type of chart you want to create;
  4. 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:

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

Article image pivot tables 14

Next page of the Free Ebook:

pivot tables

Estimated reading time: 2 minutes

Download the app to earn free Certification and listen to the courses in the background, even with the screen off.

+ 9 million
students

Free and Valid
Certificate

60 thousand free
exercises

4.8/5 rating in
app stores

Free courses in
video and ebooks