Export (0) Print
Expand All

2.2.1.4 Axis Group

Office

An axis group is a set of axes that specify a coordinate system, a set of chart groups that are plotted using these axes, and the plot area that defines where the axes are rendered on the chart.

An axis group is specified by a collection of records that conforms to the AXISPARENT rule, as specified by the chart sheet substream ABNF.

The following records and rules define the significant parts of an axis group:

  • The AxisParent record specifies whether the axis group is the primary axis group or the secondary axis group on a chart. Typically, the axes of the primary axis group are displayed to the left and at the bottom of the plot area, whereas axes of the secondary axis group are displayed on the right and at the top of the plot area.

  • The Pos record specifies the position and size of the outer plot area. The outer plot area is the bounding rectangle that includes the axis labels, the axis titles, and the data table of the chart. This record MUST be ignored on a secondary axis group.

  • The sequences of records that conform to the IVAXIS, DVAXIS, and SERIESAXIS rules in the sequence of records that conform to the AXES rule specify the axes of the axis group.

  • The sequence of records that conform to the ATTACHEDLABEL rule in the sequence of records that conform to the AXES rule specifies the axis titles of the axis group. Each attached label MUST contain an ObjectLink record that conforms to the following requirements:

    • The wLinkObj field MUST be equal to 0x0002, 0x0003, or 0x0007, indicating with which axis the axis title is associated.

    • The wLinkObj field MUST specify an axis defined in the current axis group.

    • The wLinkObj field MUST be unique among the other attached labels that represent axis titles in the same axis group.

  • The PlotArea record and the sequence of records that conform to the FRAME rule in the sequence of records that conform to the AXES rule specify the properties of the inner plot area. The inner plot area is the rectangle bounded by the chart area. The PlotArea record MUST NOT exist on a secondary axis group.

  • The sequence of records that conform to the CRT rule specifies the chart groups of the axis group.

Because there are many different ways to represent data visually, each representation has specific requirements about the layout of the data and the way it is plotted. This places restrictions on the combinations of chart group types that can be plotted on the same axis group and the combinations of chart group types that can be plotted in the same chart.

A chart MUST contain one of the following:

  • A single axis group that contains a single chart group that contains a Chart3d record.

  • One or two axis groups that each contain a single bubble chart group.

  • One or two axis groups that each contain a single scatter chart group.

  • One or two axis groups that each conform to one of the following restrictions on chart group type combinations:

    • Zero or one of each of the following chart group types: area, column, and line.

    • A single bar chart group.

    • A single bar of pie chart group.

    • A single doughnut chart group.

    • A single filled radar chart group.

    • A single pie chart group.

    • A single pie of pie chart group.

    • A single radar chart group.

In addition to the restrictions on the combinations of chart group types that can be plotted on the same axis group or chart, there are additional restrictions on the axes of the axis group based on the chart groups of the axis group.

The following restrictions apply to the axes of an axis group:

  • The axis group MUST NOT contain any axes if the axis group contains a bar of pie, doughnut, pie, or pie of pie chart group.

  • The axis group MUST contain a category (3) or date axis if the axis group contains an area, bar, column, filled radar, line, radar, or surface chart group.

  • The axis group MUST contain an area, bar, column, filled radar, line, radar, or surface chart group if the axis group contains a category (3) or date axis.

  • The axis group MUST contain two value axes if, and only if, all chart groups are of type bubble or scatter.

  • The axis group MUST contain a series axis if, and only if, the chart group attached to the axis group is one of the following:

    • An area chart group with the fStacked field of the Area record set to zero.

    • A column chart group with the fStacked field of the Bar record set to zero and the fClustered field of the Chart3d record set to zero.

    • A line chart group with field fStacked of the Line record set to zero.

    • A surface chart group.

  • The chart group on the axis group MUST contain a Chart3d record if the axis group contains a series axis.

Show:
© 2014 Microsoft