How To Create A Graph In Excel
Plotting a graph in Ms-excel is very simple and easy to perform the task. It is very quick, fast, and useful for representing any calculations using charts and graphs. In Microsoft Excel, there are varieties of graphs and charts available that are used accordingly. But one should know that there is a difference between a graph and a chart.
Graphs Vs. Charts
Both terms are technically interdependent and are different from one another, but both represent data values. A chart such as a Pie chart is used for representing a relative share in a particular data. For example, A plot division between three men in the form of percentage can be displayed using a pie chart.
On the other hand, a graph is used for representing variations in the values for the given data for a particular time duration. A graph is simpler than a chart. For example: To interpret data of a company sale in past 5 years can be easily represented via an appropriate Graph.
Varieties of Graphs in Ms Excel
Excel has leveraged its users by introducing the following varieties of graphs:
Where these Graphs are available
Open MS Excel > Insert, and there you will see all the available charts. You can see in the below figure:
Creating Graph in Excel
Here are the steps using which we can create graphs for representing the given data values:
Step 1: Open MS excel on the system, no matter the version you have. Graph feature is available in every excel version.
Step 2: Take or import the data you want to represent and enter it into the excel spreadsheet. Set all the data values in the rows (represented with numbers and marked horizontally) and columns (represented vertically and marked with alphabets). We have created a data representation as shown below:
Step 3: Under Home, click on the Number section for assigning the right data type to the data columns. Assigning the right data type will help you set and represent the data values correctly. The snippet is shown below:
Here, we have assigned General type for our data.
Step 4: Now move to Insert, which is next to Home, and there you will see the varieties of Charts as shown below:
Step 5: To choose the appropriate graph suitable for your data, you need to examine the type of data and different parameters you are working with.
Note: If we do not want every parameter to be represented in the graph, we need to make the smart selection for which, move to the cell that you want in the graph. Bring the mouse cursor on the cell name that you want to select, let say A, so keep the cursor on it, and you will see a downward-facing tiny arrow and click. The whole column of A will get selected.
Step 6: Now, if you want to select more than one cell, then drag the mouse, and multiple cells will get selected. The snippet is shown below after making multiple cell selection:
Step 7: Now, as per your data, choose the appropriate graph, and for our data, we have selected the 2D line graph, as you can see in the below snippet:
You will notice that as soon you select the graph, a graph will appear on the sheet, as you can see in the below snippet:
However, on making incorrect data type selection, the graph may not come out to be appropriate. But we can improve our created graph using the Chart tools provided by Excel.
How to make the graph attractive and presentable
Here are the tools of Ms Excel through which we can improve and make the graph more attractive:
A snippet showing the presence of the excel tools is shown below:
In the case of simple data sets, it is simple to create a graph. But when adding different types of data with multiple parameters, one will face the below challenges: