Saturday, March 5, 2011

Steps to make graph in excel 2007/2010

Below mentioned are the steps to make simple graph in Excel 2007. The example displays how to make bar graph.

1. Make the base data table as shown in the screenshot belowUse Chart tools à Layout à Data Labels option to add data labels in the graph














2. Select the data and go to Insert à Column à Clustered Column













This will insert the bar graph as displayed in the screenshot below.













3. Use format selection option (Graph tools à Format selection) to format the graph. (Tip: Keep the format selection window open and keep changing the selection in graph. The format selection window changes as per the selection in the graph)


4.


No comments:

Post a Comment