• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Using Excel > Task 26 How to Create a Chart with Chart Wizard

Task 26 How to Create a Chart with Chart Wizard

A chart turns boring numbers into an instantly accessible, persuasive visual presentation. This task explains how to create charts from your worksheet data. The Chart Wizard builds the chart for you as you make selections along the way. After the chart is built, you can resize it, rearrange it, recolor it, and personalize it so that it doesn't resemble every other Excel chart in the computer world. Chart data is organized by series. A series is a group of related cells (such as one row of data, or one column of data). Each series is assigned its own color on the chart. In the worksheet shown here, you could group the data by month, with each month assigned a unique color; you could also group the data by store.

  1. Select Data

    Start by selecting the range of data you want to chart. Include headings and labels, but don't include subtotals or totals. Here you see the range C8:F11 selected. On the Standard toolbar, click the Chart Wizard button. The first of the series of Chart Wizard dialog boxes opens.



  2. Select a Chart Type

    On the left side of the dialog box, select the Chart type you want; on the right side of the dialog box, select the Chart subtype you want. Click Next.



  3. Check the Data Range

    Check the Data range Excel displays to be sure it's correct. Click each of the two Series in option buttons (Rows and Columns) to see which layout is best. Click Next.



  4. Set Chart Features

    Click each tab and select the options you want for your chart. For example, enter a chart title on the Titles tab. Reposition or turn off the legend on the Legend tab, add labels to identify data on the Data Labels tab, and append a data table to the bottom of the chart on the Data Table tab. Click Next.



  5. Choose a Location

    Choose a location for the chart. The As new sheet option creates a separate chart sheet (similar to a worksheet, but it holds only a big chart), called CHART 1 (or whatever name you enter). The As object in option creates an embedded chart object on the worksheet you select from the As object in drop-down list. Click Finish.



  6. View the Chart

    Depending on the option you chose in Step 5, the chart appears in your worksheet or as a separate sheet in the workbook (as shown here). Notice that the Chart toolbar appears so that you can make changes to the chart as necessary.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint