Creating Charts Using Chart Wizard:

Creating Charts Using Chart Wizard Ms Excel 2007: Chart wizard displays a set of dialog of dialog boxes to create chart. It is an easier and quicker ways of creating charts. The following procedure is use to create a chart using chart wizard:

• Enter data in worksheet.
• Highlight all cells to be included in chart including headers.
• Click Chart Wizard button on standard toolbar to view chart Wizard dialog box.
• Choose Chart type and Chart subtype if necessary.
• Click Next.
• Select the data range and click Next.
• Enter the name of the chart and titles for the X-axis and Y-axis. Other options for the axes, grid line, legend, data labels and data table can be change by clicking on tabs.
• Press next.
• Click As new sheet to insert chart in a new worksheet OR select As Object In to insert chart in an existing sheet and select the worksheet from the drop down menu.
• Click Finish to create the chart.

Moving the chart:

The chart is an object in the spreadsheet. The chart can be moved anywhere on the spreadsheet. The following procedure is use to move the chart:

• Select the chart.
• Click and hold the chat.
• Drag the chart to appropriate location and release the mouse button.

Resizing the chart:

The following procedure is use to resize the chart:

• Select the chart.
• Click and hold on one of handles.
• Drag the handle in or out to adjust the size of chart.
• Release the mouse button.

Changing Patterns or colors of chart

The following procedure is use to change patterns or colors of the chart.

• Double click the item whose color is to e adjusted. The Format Data series dialog box appears.
• Select Patterns tab from format series dialog box.
• Select appropriate color and click OK.

Chart Formatting Toolbar

The chart formatting toolbar contains the following parts:

• Chart Objects list:               It is used to select an object on the chart to format. Click on object on chart or select the object from chart Objects List and click Format button. A window containing the properties of that object will appear to change formatting.
• Chart Type:                           It is used to select a different type of chart.
• Legend toggle:                     It shows or hides the chart legend.
• Data Table view;                 It is used to display the data table instead of the chart by.
• Display Data by column or Row:    It charts the data by column or rows according to the data sheet.
• Angle Text:                             Select category or value axis and click the Angle Downward or angle Upward button to angle the selected by +/ - 45 degrees.

  Creating 2 – D Pie chart:

The following procedure is use to create 2- D pie chart:

1. Enter the data in worksheet and highlight all the cells to be included in the chart including headers.
2. Click Chart Wizard button on Standard toolbar. Chart Wizard dialog box appears.
3. Choose chart type (Pie) and chart subtype if necessary. Click next.
4. Select the data range and click Next.
5. Enter name of chart. Clicking on the tabs can change other options for Titles, legend, data labels.
6. Press next.
7. Click As new sheet to insert chart in a new worksheet form the dropdown menu.
8. Click finish to create the chart.