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:-
Change the Chart Type
If you want to show the %age on Vertical Axis instead of Horizontal Axis follow below mentioned steps:-
Add Chart Title
Change the Legend Position
Add Data Labels
This is all about that how to prepare a chart, and modify it in Microsoft Excel 2010 and Microsoft Excel 2013.
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.