How to Create Charts in Excel
Plotting a Graph in Excel is an easy process. Below is a step-by-step process explaining how to make a chart or graph in Excel:
Step 1: Create a Dataset
In your excel sheet enter the dataset for which you want to make chart or graph. We are using the following random sales data for different courses for Jan – Mar period.
Step 2: Select the Dataset
Select the entered dataset by drag and drop or by CTRL + A.
Step 3: Go to Insert and Select Recommended Charts
Go the Insert Tab and in the dropdown select chart of your choice from the Recommended Charts. You can click on All charts option if can not find your desired chart.
There are various types of charts recommended by Excel. You can preview the chart before applying it. Select the chart or graph that you desire and click on OK. These types of charts are discussed below.
How to Create Graph in Excel: Step-by-Step Guide
The charts or graphs are the visual representation of data in both rows and columns. They are used to analyze the trends and patterns in the datasets.
For example, If we want to analyze the sales of different courses for a specific period we can easily do this with the help of charts and get the result of queries such as months having a maximum number of sales etc.