Out Of Tech

how to make charts in excel 2010 & 2016, 1x click done!

Confused about how to make graphs in Microsoft Excel? Jaka shares tips for making charts in Excel 2010 and 2016 the fastest and easiest 2020.

In addition to processing data, Microsoft Excel also has features that can be used to present graphs that can make it easier to present data on the internet spreadsheet We.

This one feature is really mandatory for you to master because it will be used very often for college assignments and for other office tasks.

How to make graphs in Excel is also very easy, the gang and ApkVenue will discuss everything in this article.

How to Create Charts in Excel 2010

Although classified as an old school program, Microsoft Excel 2010 is still widely used by many people because it lighter and still able to support various jobs.

Therefore, ApkVenue will also give a tutorial on how to make charts in Excel 2010 automatically quickly and easily.

So that it won't take long, let's see what are the steps for making graphs in Excel 2010.

Steps on How to Create Charts in Excel 2010

1. Prepare in advance the tables and data to be used

To make a chart in Excel 2010, you have to organize the data that will be used in the form of a table.

Make sure to write the category (month, type, etc.) in the first row and the value (amount) starting from the second column by category.

Categories will then be displayed as X axis and values ​​will be displayed per category on Y axis.

2. Choose the Graphic Type You Want

Select the insert menu and then select the graph you want, be it a bar, line, or circle graph.

3. Choose a Graphic Design According to Your Taste

After selecting the type of graphic you want, select the menu design to choose the graphic design you want.

4. Add and Edit Graphic Titles

To add a title, select menu layout then select chart title and choose where you want to place the title either above the Y-axis or slightly above the graph.

After that, the title will appear according to the location you chose and you can edit it immediately.

How to Create Charts in Excel 2016

How to make a chart in Excel 2016 more or less the same with the steps performed in Microsoft Excel 2010.

Only in Microsoft Excel 2016 there are more designs and variations which you can choose as you wish.

What are the steps to create a chart in Excel 2016 with lots of data? Check it out below, gang.

Steps How to Create Charts in Excel 2016

1. Prepare a table for the data to be used

Just like how to create an Excel 2010 chart, in Microsoft Excel 2016 you too need to create a table first according to the provisions.

Make sure that the first line contains the category and then it is filled with the value according to what you need.

2. Select the Graphic Type

Enter menu Insert then select the graph according to what you want, be it a circle, line, or bar graph.

You can adjust this type of graph according to your needs, for example for comparison it is more suitable to use a bar graph and to show the proportions of a circle graph can be more representative.

3. Edit Title, Layout, and Design As You Like

In Microsoft Excel 2016 chart title automatically appear when you choose the type of graphic you want and can be directly edited as needed.

Besides, Microsoft Excel 2016 too have a choice layout much more and more interesting which you can choose according to your heart.

What's more, there are also many choices of formats and themes that can make your graphics more attractive and colorful.

That's how to make charts in Excel 2010 and 2016 that you can practice at will. Jaka guarantees these tips will be very useful for daily needs.

The use of the current version of Microsoft Office is still diverse. The 2010 and 2016 versions of this program are still widely used today and that's why Jaka made two versions of how to make excel charts.

In addition to processing data, with the skill of making this graph, you can immediately present the pattern of the data that you process right away when asked by your lecturer or boss, gang.

Also read articles about Apps or other interesting articles from Restu Wibowo.

$config[zx-auto] not found$config[zx-overlay] not found