Create professional looking charts and graphs using Microsoft Excel! The Chart Wizard allows you to transform spreadsheet data into a clear and engaging chart or
graph. The charts and graphs may be imported into PowerPoint presentations, reports,
marketing materials, and more.
Select Data
Select the cells you wish to be displayed in the chart. Be sure to include
the column and row headings.
Open Chart Wizard
Open the Chart Wizard by going to the Insert menu
and selecting Chart
Select Chart Type
Select the Chart Type you want to use. Then select a Chart
Sub-Type. To preview the chart layout, click on Press and Hold
to View Sample. After you finalize your selection, click Next.
Verify Range of Data
The second window is Chart Source Data. Verify the range of
data being used for the chart. Make changes to your selection if necessary.
Save the series by rows or columns by selecting the appropriate radio button.
Click Next.
Chart Options
The third window is Chart Options. Add a title to the chart,
make changes on the legend, or make changes on the data labels. Click Next.
Save the Chart
The final window in the Chart Wizard is Chart Location.
Select As New Sheet if you wish to insert the chart into another
document (see below.) Click As Object In to place it in one
of the sheets in your workbook. Click Finish. Your chart is
done!
Additional Formatting
You can further manipulate the look and feel of your chart by double clicking
on the various chart elements.
Insert Chart into another document
Open the PowerPoint or Word document you want to include the chart in. Go to
the Insert menu and select Object. Click the Create from File radio button (PowerPoint) or tab (Word), then
click the Browse button. Navigate to the Excel file that contains
the chart, then click Insert. |
