Excel Insert Chart

How to Create a Chart in Microsoft Excel?

2 minutes, 7 seconds Read

[wpdreams_ajaxsearchlite]

In the previous post, we saw ‘How to Use Slicers to Filter data in Excel?’, now we will learn about how to Create a Chart in Microsoft Excel?

Where to Find The Excel Chart Option?

To find the excel chart option click on the “Insert” tab under the Charts group select the chart that you want to use.

Note: Click on the image

Excel Insert chart- Edutaxtuber


Create a chart

With the help of this data let’s create a chart in excel

YearSales
2021        2,54,03,730
2020           69,50,193
2019        2,34,63,494
2018           21,09,367
2017        2,62,54,412
2016        4,99,69,893
2015        3,90,56,289
2014        3,21,52,046

First, select the data then click on the “Insert” tab after that click/Select a chart on the Recommended Charts tab, to preview the chart, and finally click on ‘OK’ to insert the chart.

Note: Click on the image

Excel Insert chart- Edutaxtuber

Shortcut to Insert Chart

First, select the data then press ‘ALT + F1’ to create a chart

Note: Click on the image

Excel insert chart - Edutaxtuber


Also read other articles @ EduTaxTuber

How To Create Multiple Ledgers in Tally Prime?
In this article, we will discuss that how we can create multiple ledgers in Tally Prime. If we create multiple ledgers then we can save our time on the other hand If we create a single ledger then it will …
TallyPrime: Important Shortcut Key ALT + G or GO To
In this article, we will discuss the new and unique shortcut key ALT + G or GO To in the TallyPrime. With the help of the ALT + G shortcut key, you can navigate in tally anywhere. ALT + G …

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status

In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More

For Latest Updates & Learning Join Our YouTube Channel: Join Now

EduTaxTuber Team

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply