3.1 Graph - Column Chart

  • Article

This example shows a column chart created using a graph object. The set of records that specifies the column chart exists in the chart sheet substream of the file. For brevity, not all records in the chart sheet substream are included in the example. The column chart specified in this example has a single series with three data points, as shown in the following figure.

Column chart in a sheet (1)

Figure 3: Column chart in a sheet (1)

This example includes the following records:

  • The Chart, Scl, PlotGrowth, ShtProps, and AxesUsed records specify properties of the chart.

  • The Series, Begin, BRAI, SeriesText, DataFormat, and SerToCrt records specify properties of the data series.

  • The AxisParent, Pos, Axis, CatSerRange, Tick, ValueRange, AxisLine, and LineFormat records specify properties of the axis group in the chart.

  • The Frame, LineFormat, and AreaFormat records specify the properties of the plot area.

  • The ChartFormat and Bar records specify properties of the chart group.