If you are looking for how to make graph or chart in Excel sheet, then this article is for you. Here we have mentioned about the complete details in steps wise, which you can follow to get an idea about to make a graph or chart in Excel.
In the MS Excel, you can create any basic chart by selecting the part of the data range, which you can want to display in the chart. After selecting the data, you have to click on the chart type that you want to use to make your chart. From there, you can also choose multiple and different chart layouts to make your chart more attractive and interesting. After you create a chart, you can also customize and modify any one of its elements.
How to Make Graph in Excel
So, let’s take a look at this below mentioned simple steps:
Step 1: First of all, you have to create a new Excel Sheet, then input your all data into the Excel Sheet which you want to use to make a chart or graph.
(Here, the data can be arranged in rows or columns) After you arrange the in rows or columns, the Excel will automatically determine the best way to plot the data on the chart.
Step 2: To make the chart, you need to select the data range that you want to use for the chart.
(You can use “Shift + “Arrow Keys” to select the data in Excel)
Step 3: After you select (highlight) the data, click on the “Insert” tab, then choose chart type in the chart group. (e.g., you can choose from, Column, Line, Pie, Bar, Area, Scatter, etc.)
Step 4: After you choose the chart type, you have to choose the chart subtype which you want to use to make your chart.
You are done!
Note: You can also create the simple chart by using some shortcut keys. To quickly create a chart, select the data that you want to use to make the chart. After you select the chart, press ALT+F1 key combination. (When you press these key combinations, the chart is displayed as an embedded chart in an existing sheet.) You can also press the F11 key. (This will create your chart on a separate chart sheet)
If you don’t have to use a chart, then you can also delete it. To delete the chart, you have to select on it, and then press the Delete button on your Keyboard to delete it.
Do share your comments in the comments section below, how do you make graphs in your MS Excel.