to create chart in MS Excel
To create a chart in Excel 2007
To create a chart in Excel 2007,
Open to the worksheet that contains your unsummarized data.
Select the cell range of the data to be charted.
If your cell range contains two nonadjacent areas, hold down the Ctrl key as you drag and select each area.
Select Insert and in the Charts group, click the chart type.
From the drop-down gallery that appears, click the chart sub-type you want.
To help distinguish sub-types, move the mouse pointer over a sub-type and wait for the sub-type description to appear.
Customize your chart by clicking the chart and selecting the Layout tab of the Chart Tools ribbon group (or PivotChart Tools, if the chart is based on a PivotTable).
Review the settings for the members of the Labels and Axes groups in this tab.
Unless overridden specifically in later instructions, use the following settings for these items
(for a given chart type, some of these items may be disabled and not available):
Chart Title Choose either Centered Overlay Title or Above Chart.
Axes Titles For the Primary Horizontal Axis Title, select Title Below Axis. For the Primary Vertical Axis Title, select Rotated Title.
Some charts have secondary axes; for such charts, select Title Below Axis as the Secondary Horizontal Axis Title and None as the Secondary Vertical Axis Title.
Data Labels Select None.
Data Table Select None.
Axes For the Primary Horizontal Axis Title, select Show Left to Right Axis. For the Primary Vertical Axis Title, select Show Default Axis. Some charts have secondary axes; for such charts, select None as the Secondary Horizontal Axis Title and Show Default Axis as the Secondary Vertical Axis Title.
Gridlines Select None for both the Primary Horizontal Gridlines and Primary Vertical Gridlines. Also select
None for secondary gridlines, if the chart contains those as well.
To create a chart in Excel 2007,
Open to the worksheet that contains your unsummarized data.
Select the cell range of the data to be charted.
If your cell range contains two nonadjacent areas, hold down the Ctrl key as you drag and select each area.
Select Insert and in the Charts group, click the chart type.
From the drop-down gallery that appears, click the chart sub-type you want.
To help distinguish sub-types, move the mouse pointer over a sub-type and wait for the sub-type description to appear.
Customize your chart by clicking the chart and selecting the Layout tab of the Chart Tools ribbon group (or PivotChart Tools, if the chart is based on a PivotTable).
Review the settings for the members of the Labels and Axes groups in this tab.
Unless overridden specifically in later instructions, use the following settings for these items
(for a given chart type, some of these items may be disabled and not available):
Chart Title Choose either Centered Overlay Title or Above Chart.
Axes Titles For the Primary Horizontal Axis Title, select Title Below Axis. For the Primary Vertical Axis Title, select Rotated Title.
Some charts have secondary axes; for such charts, select Title Below Axis as the Secondary Horizontal Axis Title and None as the Secondary Vertical Axis Title.
Data Labels Select None.
Data Table Select None.
Axes For the Primary Horizontal Axis Title, select Show Left to Right Axis. For the Primary Vertical Axis Title, select Show Default Axis. Some charts have secondary axes; for such charts, select None as the Secondary Horizontal Axis Title and Show Default Axis as the Secondary Vertical Axis Title.
Gridlines Select None for both the Primary Horizontal Gridlines and Primary Vertical Gridlines. Also select
None for secondary gridlines, if the chart contains those as well.