To create a chart from an existing spreadsheet and customize the settings.
Creating charts in Excel 2010 is much easier that you might think. Follow the simple steps and you'll be on your way to creating impressive spreadsheets in no time at all.
Excel 2010 makes it easy to show your data in graphical form through its insert chart feature.
Source: YouTube - GCFLearnFree.org Channel
Using the downloaded Cookie Contest worksheet above, follow the steps below to create a basic chart.
1) Highlight the data fields of cells A3 through D6
2) Click on the Insert tab and choose the 2-D clustered bar type
3) Switch the row/column data
4) Select layout 8 to include chart and axis title areas
5) Type in the chart title as: 12th Annual Cookie Contest
6) Type in the vertical axis title as: Finalist
7) Type in the horizontal axis title as: Result Points
8) Change the chart style to style 34 which is a multi color, gray background shading
9) Move the chart to the right within the worksheet so that you can view all the data and chart at once
Compare your screen to the Cookie Contest Final below
Source: Marie E. Arriaga
Source: Marie E. Arriaga
