Create an Excel Chart: The 4 Easy Steps!
Here is the step-by-step guides to create an outstanding Excel chart:
Key in the data illustrated below accordingly as we will use it to demonstrate how to create a chart in Microsoft Office Excel.Note:
We will use the step-by-step Excel Chart Wizard
to create a chart that related to the Student exam results for the subject English, Science and Mathematics.
Step 1: The Chart Wizard (1) – Chart TypeClick on any cell within the data containing the information that you wish to display as a chart, or highlight the exact data that you wish to display as a chart. Click the Chart Wizard icon on the Standard toolbar. This will display the Excel Chart Wizard as show below:
From the Chart type: section you can select the type of chart that you wish to create. Then from the Chart sub-type: section you can select the exact format that you required for the selected chart type.To see how the selected chart will look, use the Press and Hold to View Sample button within the dialog box. In our example, we accept the default selection.Click the Next button to see the next page of the dialog box - Chart Source Data.
Step 2: The Excel Chart Wizard (2) – Data SourceThe Data Range tab allows you to specify the exact data that you wish to display within your chart.You can choose to display Series in Rows or Columns. In the case of the example data used, the two effects will be as illustrated. Choose the Series in Rows.
When you click on the Next button, this will display the Chart Options dialog box.
Step 3: The Excel Chart Wizard (3) – Chart Options
From the chart options dialog box displayed, you can select Titles, Axes, Gridlines, Legend, Data Labels and Data Table tabs and make the necessary changes.
To add title to a chartIn the Chart title: text box, enter the name for the chart, i.e. Exam results.In the Category (X) axis: text box, enter a title for the X axis, i.e. Subject.In the Category (Y) axis: text box, enter a title for the Y axis, i.e. Mark score.In the example used, the screen will be as illustrated.
To customize the chart axisFrom the Chart Option dialog box displayed, click on the Axes tab.It allows you to control the way the axes are displayed, you can tick or un-tick the check box to see the effects on the chart.
To customize chart gridlinesFrom the Chart Option dialog box displayed, click on the Gridlines tab.You can choose to display the major and minor X and Y gridlines for the axis by clicking on the particular check box.
To customize chart legendFrom the Chart Option dialog box displayed, click on the Legend tab.You can choose to display or not the chart legend and the placement of the legend in the chart by clicking on the radio button.
To customize data labelsFrom the Chart Option dialog box displayed, click on the Data Labels tab.You can choose to display or not the chart data labels by clicking on the radio button.
To display a data tableFrom the Chart Option dialog box displayed, click on the Data Table tab.You can choose to display or not the chart data table by ticking on the check box.Click on the Next button to continue and this will display the final page of the Chart Wizard – Chart Location.
Step 4: The Excel Chart Wizard (4) – Chart Location
To define the chart locationYou can choose to place the chart on an existing worksheet as an object, or you can place it on a new worksheet. Two options for you to choose:
As new sheet: – It will place the chart in the new worksheet.
As object in: - It will place the chart in the existing worksheet.
Click on the Finish button and the chart will be created as you have specified during the Chart Wizard creation process.
Can't find what you're looking for? Try Google Search!
Back to Top
>> Next Topic : What you can do with Templates and Styles?
<< Previous Topic : Using the Excel Formulas and Functions
You're viewing the Excel chart info page, click here to go back to the Home Page