Graph is one of the important data analyzing tools which makes it easier for the user to determine different aspects of the collected data through pictorial representation. Furthermore, the variance of color for different data types helps user understand the data statistics more easily as compared to determining through multiple rows and columns of Microsoft Excel sheet.

Create Graph In Excel

Excel is very efficient in creating and embedding graphs. This is the reason why it charts are considered as one of its basic features. Converting your numerical data into charts can be tedious if you do not know the appropriate way of doing it.

Abiding by the given methods will help you create, edit and print graphs through MS Excel.

Creating Graph In MS Excel

In order to create graph in Excel sheet, you will need to follow the given steps.

Step # 1:

The very first thing that you will need to do is to enter your collected data in the Excel sheet. While entering data, make sure to place a single data type in a particular column. In case you have placed mix data types in columns, the graphs that would be created will be of no use.

Pic 1

Step # 2:

Once you have entered data appropriately in your Excel sheet, now you will need to select the specific cells containing your data. For this, you can simply press left-click of mouse from the very first cell and drag it to the last one diagonally. Or you can simply select the first cell, press Shift key and using the arrow keys, select your desired cells.

Pic 2

Step # 3:

After selecting data, click the ‘Insert’ tab. When you will select this option, you will be provided different insert options including picture, clip-art, shapes, etc. One of these options will be of inserting charts.

Pic 3

Step # 4:

When it comes to inserting charts, one needs to be very careful while picking up the right type depending upon his data. There is a wide range of charts including column, line, pie, scatter, bar, area and others.

Pic 4


These charts are further divided in sub-categories which make it a bit difficult to make selection. However, selection of the right chart-type is essential to analyze data via graph. Selecting the wrong or inappropriate type of graph would be of no use and all your efforts will be simply wasted.

Step # 5:

After deciding the appropriate type of graph for your data, simply select it which will convert your data into your desired chart. In this case, I have selected 3D column chart which has converted the data into a graph as shown in given image.

Pic 5

Editing Graph In MS Excel

Implementing the aforementioned steps will only convert the data into pictorial representation and you may need to do some additional things to make it understandable for your others. Following are some important editing options that you may need to incorporate in your graph.

Adding Title Of Graph:

Graph’s title is one of the most important things which are required to be added in it to make the chart understandable for the readers. If the readers do not know the topic, they will not be able to understand graph either.

To give your chart a title, you will need to go to your chart, select ‘layout’ option from the chart tools and select ‘chart title’ option. Upon selecting the chart title option, it will display you multiple options of adding title to your graph and it completely depends on you which option you select. In my case, I have selected ‘Above Title’ option and named it as ‘Example Chart’ which can be shown in given image.

Pic 6

Adding Axis Titles:

Similar to the main title of the graph, it is also important to name the axis of the graph to make the graph and its interpretation understandable for the reader. To name axis of your graph, you will need to select the ‘Axis Titles’ option from chart tools as shown in given image.

Pic 7

Changing Legend Position:

User can also change the position of Legend to his desired position in graph. All you need to do is to select ‘Legend’ option from the ‘Layout’ tab. One can easily move the legend to different positions with the help of given options. In order to move it manually, you can simply select the legends and drag it your desired position. In this case, I have moved the legends to the bottom of chart using the predefined positions.

Pic 8

Printing MS Excel Graph

Once you have created graph and edited it according to your needs, you can now simply print it out using the print option from the file menu as shown in given image.

Pic 9