creating+charts+in+Excel+2007

Different types of charts can be created in Microsoft Excel 2007 such as Bar, Line, pie, scatter…and many more. Some of the steps to create charts in Excel are the following:- · First step to create chart in excel is by selecting the data on a worksheet. · Open Excel 2007, and either open an existing worksheet or use the default. · Enter or create some data that supports the creation of a chart. · Select the data to be charted. · Left-click and drag a box around the data to select it. · Make sure to include both the data and the labels.  · Choose a chart style from the charts group. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Select "Insert" on the Excel 2007 ribbon and then choose from the chart types listed in the "Charts" section. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">The chart will be placed on the worksheet near the table of data. By default, the series will be listed across the bottom and the elements will be listed to the side. The element values will be listed on the left side of the chart. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· **<span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Note: **<span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"> The chart group is located on the insert tab. If there is a problem seeing a chart style, then open the insert chart dialog box for more chart options or select the “other charts” icon. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Place the chart. Left-click on any white space on the chart, and move it to the preferred location. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Finally, format the chart. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Right-click on the chart and different options will appear in a dialog. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Change the font displayed within the chart, change the chart type and select different chart data by selecting the relevant item from the list. <span style="color: #333333; font-family: Symbol; font-size: 12pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol; msobidifontfamily: Symbol; msofareastfontfamily: Symbol; msolist: Ignore;">· **<span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Note: **<span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';"> To change the chart's appearance, select “Format Chart Area” and then select from the options to change the chart's “Fill,” “Border color,” “Border Styles,”…..and “Shadow.” <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">Creating charts in Excel 2007 **
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">STEP 1 **
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">STEP 2 **
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">STEP 3 **
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">STEP 4 **
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">STEP 5 **
 * <span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">For more information go to: first advantage-Training – excel 2007 level 1 – “create charts” **<span style="color: #333333; font-family: Andalus; font-size: 12pt; mso-fareast-font-family: 'Times New Roman';">