►Creating and Modify Chart in Microsoft Excel

CreatingChartsare visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, rather than having to analyze several columns of worksheet numbers, you can see at a glance whether sales are falling or rising over quarterly periods, or how the actual sales compare to the projected sales. The following is an example of a column chart:You can graphically present your data with Excel’s charting features. 

The Chart Wizard  createscharts after stepping you through the following series of options:
1-  Select the cells you want to include in a chart.
2- On the Standard toolbar, click on the Chart Wizard icon  , to display Step 1 of the
Chart Wizard.

3- Select the Chart Type, and click Next to display Step 2 of the Chart Wizard.
4- Select the Data Range, and click Next to display Step 3 of the Chart Wizard.
5- Select the Chart Options, and click Next to display Step 4 of the Chart Wizard.
6- Select the Chart Location, and click Finish to create the chart.

Note: You can create the chart during any of the steps by clicking Finish    .

» Step 1-  Selecting the Chart Type:
1- From Step 1 of the Chart Wizard, select the type of chart that you want from the Chart type area.
2- Select the exact chart format you want from the Chart sub-type.
3- To see how the selected chart will look, click and hold the Press and hold to view sample button:

4-Click Next to continue.
» Step 2 - Specifying the Data Source:
1- From Step 2 of the Chart Wizard, enter the range you want to plot in the Data  range text box.
2- Choose to display your Series in Rows or Columns.
3- To adjust the series, click on the Series tab. From this tab, you can add, define, and remove data series.
4- Check the sample chart, and make adjustments as needed:

5- Click Next to continue.
»Step 3 - Customizing the Chart:
From Step 3 of theChart Wizard, click on one of the following tabs to customize your chart:
1-  Enter the title in the Chart title text box.
2-  Enter the X axis name in Category (X) axis text box.
3-  Enter the Y axis name in Value (Y) axis text box:


1-  Select the Category (X) axis checkbox to display the X axis labels.
2-  Select the Value (Y) axis checkbox to display the Y axis labels:

1-  Choose the options you want to display the major and/or minor gridlines for the X and Y axis:

1-  Select the Show Legend checkbox to display the legend.
2-  Choose the legend placement by selecting the Bottom, Corner , Top, Right, or
Left radio button:

Data Labels:
1-  Choose to display and/or format data labels:

Data Table:
1-  Choose to display the chart data in a data table:

2-Click Next to continue.

»Step 4 - Defining the Chart Location:
1-  From Step 4 of the Chart Wizard, choose the location for your new chart.
2-  Select theAs new sheet radio button to place the chart on a new Worksheet, and enter the Worksheet name in the text box .

OR select the As object in   radio button to place the chart as an object in existing worksheet, and select the Worksheet you want from the dropdown list:

3-  Click Finish to create the chart.

No comments:

Post a Comment