The Chart Wizard brings you through the process of creating a chart by displaying a series of dialog boxes.
[hidepost=1]
- Enter the data into the worksheet and highlight the range for which you want to make a chart including headers.
- Click the Chart Wizard icon on the standard toolbar to view the first Chart Wizard dialog box or choose Chart option from the Insert menu.
- Chart Type – The Chart Wizard dialog box is displayed. Choose the Chart type and the Chart subtype if necessary. Click Next.
- Chart Source Data – Select the data range (if different from the area highlighted in step 1) and click Next. If you want to change the data and labels, click in the Data Range box and select the source data range on the worksheet.
- Chart Options – Enter the name of the chart and titles for the X- and Y-axes. Other options for the axes, grid lines, legend, data labels, and data table can be changed by clicking on the tabs. Press Next to move to the next set of options.
- Chart Location – Click As new sheet if the chart is to be placed on a new, blank worksheet or select As object in if the chart is be embedded in an existing sheet and select the worksheet from the drop-down menu.
- Click Finish to create the chart.
Resizing The Chart
To resize the chart, click on its border and drag any of the nine black handles to change the size. Handles on the corners will resize the chart proportionally while handles along the lines will stretch the chart.
Moving The Chart
Select the border of the chart, hold down the left mouse button, and drag the chart to a new location. Elements within the chart such as the title and labels may also be moved within the chart. Click on the element to activate it, and use the mouse to drag the element to move it.
Chart Formatting Toolbar
Chart Objects List – To select an object on the chart to format, click the object on the chart or select the object from the Chart Objects List and click the Format button. A window containing the properties of that object will then appear to make formatting changes.
Chart Type – Click the arrowhead on the chart type button to select a different type of chart.
Legend Toggle – Show or hide the chart legend by clicking this toggle button.
Data Table view – Display the data table instead of the chart by clicking the Data Table toggle button.
Display Data by Column or Row – Charts the data by columns or rows according to the data sheet.
Angle Text – Select the category or value axis and click the Angle Downward or Angle Upward button to angle the the selected by +/- 45 degrees.
[/hidepost]
Like what you read?
If so, please join over 28,000 people who receive our exclusive weekly newsletter and computer tips, and get FREE COPIES of 5 eBooks we created, as our gift to you for subscribing. Just enter your name and email below:
