How to create a chart in MS Excel
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:
In order to create a pie chart, you need to open an Excel spreadsheet and insert your data into cells as shown below:
In this Word Course, you will find all the Operations a...
Enroll For FreeImpress Everyone With Fluent Communication Skills With...
Enroll For FreeEnhance your customer engagement skills with our Custom...
Enroll For FreeImprove Your Presentation and Team Management With Soft...
Enroll For FreeBecome A Master In Sales With Career In Sales Taught In...
Enroll For FreeHave a friend to whom you would want to share this course?