en uk

Switching rows and columns Microsoft Excel 2007

    When Excel creates a chart, it displays your data's labels on the X - and Y-axes. However, you can switch these around, and Excel can show you how your chart may change.

    To switch the rows and columns used to create a chart, follow these steps:

    1. Click the chart you want to change.

    The Chart Tools tab appears.

    2. Click the Design contextual tools tab under the Chart Tools tab.

    3. Click the Switch Row/Column icon in the Data group.

    Excel switches the X-axis data to appear on the Y-axis and vice versa.

    Changing the parts of a chart

    To make your charts more informative, you can add additional text, such as

    A chart title A legend Data labels Axis labels Axes Gridlines

    With each part of a chart, Excel can either hide it completely or move it to a different location. To modify any part of a chart, follow these steps:

    1. Click the chart you want to change.

    The Chart Tools tab appears.

    2. Click the Layout contextual tools tab under the Chart Tools tab.

    3. Click the icon that identifies the part of the chart you want to modify, such as Chart Title or Axis Titles.

    A menu of different options appears, as shown in Figure 9-8.

    4. Click an option, such as None.

    Excel shows your modified chart.

    Switching rows and
columns Microsoft Excel 2007

    Figure 9-8:

    The Legend menu lets you place it

    In different locations on

    Your chart.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.