10 Excel Charts

12
26099
Excel Spreadsheets

It is surprising how much resources Excel offers us. And one of them is the generation of graphs based on the data inserted in the worksheet. And Excel still has several types of graphics, allowing for greater customization and adaptation to the needs of the user. Check out ten types of Excel charts and see which one best fits your needs:

Get to know 10 different graphics types that you can create in excel

1. Column style charts

10 Excel Charts 1

It is the most commonly used chart in Excel for giving easy visibility to spreadsheet data. This simplicity makes it very popular with excel users. It allows you to view various information at the same time, making it easier to cross data.

2. Pie style graphic

10 Excel Charts 2

It is the second most used graphic and is certainly the best known. It allows the categories to be viewed more accurately, ie it is great to use when there is a need for a quick idea of ​​quantitative data. He is an excellent graphic to emphasize an idea and helps as a good argument if you need to convince someone of your idea.

3. Bar style chart

10 Excel Charts 3

Just like pizza and columns, the Barras style graphic is very popular. Again, its popularity is given by the way information provides, allowing easy understanding to those involved. Although very similar to the column style chart, this chart style is suitable for data that has very long labels.

  • Bar chart (3D variation)

10 Excel Charts 4

4. Scatter style graphics

10 Excel Charts 5

Anyone who enjoys math and physics classes will surely become familiar with this graphic style quickly. It works with X and Y axes and is great for anyone wanting to demonstrate a sequence of some action, such as demonstrating the image. It shows the number of adoptions made in that quarter, which animals were more successful and which were less. In this way, it is possible to facilitate decision making, such as which campaigns to prioritize next quarter.

5. Line style graphics

10 Excel Charts 6

Like the Scatter style, this chart is great for displaying information in sequence and even better for decision making. It is less mathematical than the Scatter chart, but it is more didactic and easy to understand by lay people (such as clients, community, etc.)

6. Thread-style graphics

It is similar to the Pizza style, both in view style and in information organization logic. However, it is more complex to read and interpret the information.

  • Common Version

10 Excel Charts 7

  • Percentage version

10 Excel Charts 8

7. Area Style Charts

10 Excel Charts 9

If you need to demonstrate the changes and swings of a given category (campaign, product, etc.) this chart is perfect. It is great for analyzing just these oscillations.

8. Surface graphics

10 Excel Charts 10

This is the ideal graph for anyone who needs to cross data and find combinations between them. You can detect trends and behaviors from this type of chart.

9. Bubble style graphics

10 Excel Charts 11

If it is necessary to accurately determine the values ​​entered in the worksheet, this is the ideal graph. This type of worksheet is widely used to present financial data.

10. Radar style chart

10 Excel Charts 12

Named after the editing style, this graph is very useful for those who want precision data crossing.

As you can see, there are many types of graphics available for your use. Have you ever used any? And how did you use it? Comment and share the experience!

Excel Spreadsheets

12 COMMENTS

  1. Hi Lavinia, to make a very simple chart just put a structure like this in Excel:

    column A column B
    line 1 Fruit Quantity
    2 apple line 20
    3 line strawberry 10

    Select the 6 cells and click INSERT GRAPHIC

  2. I wanted to know what? a graph already ready, you must be wondering: but you already have a graph ready! but ne I'm in the fourth year and and homework I wanted an easy graphic to make n a difficult like that

  3. Hi Daniel, I imagine it's possible to do something general. First you would have to have an image of the human body "leaked" with transparent background and white outline for example. So you could put a column chart behind the image and, as that graph grew, it would fill the human body.

  4. I would like to customize my chart ... I want it in human body format, can you do that?
    so that it is in total volume or in partial by members, or by volumes ??

  5. Very good! Thank you!
    the Surface chart can also be used to analyze temperature profile, something I see a lot in the course of chemical engineering.

LEAVE AN ANSWER

Please, write your comment
Please enter your name