Creating a Chart Quickly

To present your Excel data graphically, select the cells you want to summarize, click the Insert tab, and then use the controls in the chart gallery to select the chart type that’s best for your data and the message you want to get across. The cells with the data to be represented in the chart are part of one or more data series. A series is a collection of related data, such as all sales for a particular product or the sales for each day of a month. A bar chart could contain just one series; a line chart, which might display monthly sales for several years, could have many series.

Creating attractive charts is much easier in Excel 2007 than in previous versions of the program. Not only can you create the chart quickly by using the controls on the ribbon, you can use the same controls to choose your chart’s overall layout and style. After you set your chart’s general appearance, you can make any desired changes with no trouble at all.

Create a Chart

  1. Click a cell in the data list you want to summarize.

  2. Click the Insert tab.

  3. Click the type of chart you want to create.

  4. Click the desired chart subtype.

    Create a Chart

    Tip

    Tip

    Pressing F11 creates a chart of the default type (a column chart, unless you’ve changed it), with the default layout and formatting, on a new workbook sheet.

Change a Chart’s Layout

  1. Click the chart you want to change.

  2. Click the Design tab.

  3. In the Chart Layouts group on the ribbon, click the desired layout.

    Change a Chart’s Layout

Change a Chart’s Style

  1. Click the chart you want to change.

  2. Click the Design tab.

  3. In the Chart Styles group on the ribbon, click the desired style.

    Change a Chart’s Style
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.158.32