How to Create a Graph in Microsoft Excel

In this article we will learn about how we can make a graph in Microsoft Excel.

Charts are used to convert the numeric data in a graphical format, it’s valuable for analyses the data. It makes easier to understand the large no. of data and association between different series. In Excel almost Graphs are inbuilt Column Graph, Bar Graph, Pie Graph, Doughnut Graph etc. It is very important to learn how to make graphs if we want to get more information from the data.

Before preparing the chart, we need to keep few things in our mind. When we will enter the data in excel worksheet, so data should have proper headers, rows, columns and any cell should not be blank.
Create the Graph

We have a table from the range A1 to D9, in which column A contains Month, Column B Total Achieved %age, column C Issued %age and column D Cancelled %age. To create the chart follow below mentioned steps:-

img1

  • Select the range A1:D9.
  • Go to Insert Tab, in the chart group, click on Line Chart and select the line with markers.
  • Line Chart will get created.

img2

Change the Chart Type

  • Click on the chart.
  • Go to Insert Tab, in the chart group, click on Column Chart and select the Clustered Column Chart.
  • Line Chart will get created.

img3

Switch Row/Column

If you want to show the %age on Vertical Axis instead of Horizontal Axis follow below mentioned steps:-

  • Click on the Chart.
  • In the ribbon 2 contextual tabs will get activate
  • Go to the Design Tab, click on the Switch Row / Column in the Data group.

img4

Add Chart Title

  • Click on the Chart.
  • In the ribbon 2 contextual tabs will get activate
  • Go to the Design Tab, click on Add Chart Element in the Chart Layouts group.
  • After click on the Add Chart Element drop down menu will be appeared, click on Chart Title again drop down menu will appear click on Above Chart.
  • Now you can edit the title, type Monthly report.

img5

img6

Change the Legend Position

  • By default the legend will appear in the bottom of the chart.
  • To move the legend click on the chart.
  • The chart related tools tab will get activated.
  • Go to the Design Tab, click on Add Chart Element in the Chart Layouts group.
  • After click on the Add Chart Element drop down menu will be appeared, click on Legend again drop down menu will appear click on Bottom to show the legend on Right.

img7

Add Data Labels

  • Click on the chart.
  • The chart related tools tab will get activated.
  • Go to the Design Tab, click on Add Chart Element in the Chart Layouts group.
  • After click on the Add Chart Element drop down menu will be appeared, click on the Data Labels again drop down menu will appear click on Outside End.

img8

This is all about that how to prepare a chart, and modify it in Microsoft Excel 2010 and Microsoft Excel 2013.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube