Inserting an extended bar or column chart

Extended bar and column charts allow you to roll up data across one or more columns in a result set.

About this task

To insert an extended bar or column chart:

Procedure

  1. Double-click the Bar Chart or Column Chart object in the Layouts palette of the Palette view.
    The Bar Chart Wizard or Column Chart Wizard opens.
  2. In the All Data Sources tree, navigate to the table or query that will be run to obtain the layout object's query result set and click Next.
    The Select layout type page opens.
  3. Click Extended and click Next.
    The Select the field(s) to be displayed as bars page opens.
  4. Select one or more columns in the Available fields list box and click Move Right to move them to the Field column of the Fields to be displayed table.
    This field lists the names of the columns of data that are included in the selected query result set. The columns that you move to the Fields to be displayed table will be displayed as the bars along a labeled axis in the column or bar chart.
  5. Click a cell in the Aggregation column of the Fields to be displayed table. A drop-down list opens. Choose an option to specify how the column is aggregated.
  6. Click Next.
    The Select one or more fields to be moved in the side group page opens.
  7. Select one or more columns in the Available fields list box and click Move Right to move them to the Fields to be moved list box.
    The columns that you move to the Fields to be moved list box will be rolled up in the query result set, and the order of the columns will determine the roll up hierarchy.
  8. Click Next.
    The Set up labels and legend information for chart page opens.
  9. Select the Display the value of each bar check box to display the data value at the end of each value bar.
  10. Select the Stack bars when there are multiple series check box to stack value bars of different data series on the same line.
    The value bars representing the first data column in the Fields to be displayed list box are drawn first, and subsequent value bars start where the ones before them end.
    For example, if bar 1 has a value of 50 and bar 2 has a value of 20, bar 1 is displayed from 0 to 50 and bar 2 is displayed from 50 to 70.
  11. Click Finish.
    The wizard closes, and the bar or column chart is displayed in the editor window.