[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

Create a chart
With the help of this data let’s create a chart in excel
Year | Sales |
---|---|
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

Shortcut to Insert Chart
First, select the data then press ‘ALT + F1’ to create a chart
Note: Click on the image

Also read other articles @ EduTaxTuber
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
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

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