Now we will see that we can create chart in MS Excel.
Suppose if you want to show any particular information in comparison form
then we can create the chart for better understanding.
The simplest way to create a chat is first of all, we will select the data
which we want, and after that press 'Alt+F1' key, as soon as we press the
key a chart will be inserted according to our selected data and also 'Chart
tools' will be added in ribbon section.
Chart tool consists of two things that is Design and Format.
Now we will select the data and then go to INSERT tab and then in that we
will see an option of Recommended Charts. As soon as we open it we will see
different kind of recommended charts like clustered column, clustered bar
and many others, we can choose any chart according to our requirement.
Now if we want to display our chart in different sheet, then we will first
select the data which we want in chart form and after that we can press
'F11' button from our keyboard which will create a different sheet named as
'Chart1' and our chart will be automatically inserted there.
Now if we have decided that we want our chart to be in Bar form, than we
can select our data a d after that from INSERT tab Chart column we can
select our requirement chart form.
There are various types of charts that you can create in Excel - bar charts, line graphs, pie charts, etc. The type of chart you choose will depend on the type of data that you want to represent and what kind of information you want your audience to take away from it.
The following steps will help you create a basic bar chart in Excel:
Create a new sheet in Excel and select the cells where you want your chart to appear
Select "Insert" from the menu at the top left corner
A column chart is a simple way to represent data visually, with the height of each column representing a different value. The columns are drawn side-by-side, with the width of each column proportional to the value it represents.
A bar chart is a visual representation of data using rectangular bars of varying lengths to show how much or what percentage each item contributes to the whole.
In order to create a pie chart, you need to open an Excel spreadsheet and insert your data into cells as shown below:
Click on cell A3 and enter your data into this column.
Select cells A3 through A6 by clicking on them with your mouse and dragging them down so that they are below cell B3.
Select cell B3 by clicking on it with your mouse
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR
I'm very lucky because I have this app. I learned a lot from this app and will keep learning.
Thank you so much LearnVern.
best app for learning
This is very useful app by all courses in this app and thanks for learnvern