This record defines a 3D chart group and also contains generic formatting information.
This record specifies linked series data or text.
This record specifies rich-text formatting (bold, italic, font changes, etc.) within chart titles and data labels.
This record describes the patterns and colors used in a filled area.
This record defines an area chart group.
This record specifies the layout information for attached label
The ATTACHEDLABEL record defines the data label type. The ATTACHEDLABEL record applies to the label data identified in the associated DATAFORMAT record.
This record defines axis options.
This record specifies the number of axes sets (1 = primary only, 2 = primary and secondary) used on the chart (3D charts can only have primary axes).
Represents DisplayUnits option.
This record usually follows an AXIS record to define the axis line as it appears on the chart.
Represents chart category axis offset record.
This record specifies the location and size of the chart axes, in units of 1/4000 of the chart area.
This record defines the axis type.
This record defines a bar or column chart group.
Represents begin display axis unit label record.
This record stores options for a custom bar of pie or pie of pie chart; these are two of the pie chart subtypes.
This record stores options for a bar of pie or pie of pie chart; these are two of the pie chart subtypes.
This record defines the scaling options for a category or series axis.
This record is the parent record for the chart group format description. Each chart group will have a separate CHARTFORMAT record, followed by a BEGIN record, the chart-group description, and an END record.
This record specifies drop lines, hi-lo lines, or series lines on a line chart. If the chart has both drop lines and hi-lo lines, two CHARTLINE records will be present.
The CHART record marks the start of the chart data substream in the workbook BIFF stream. This record defines the location of the chart on the display and its overall size. The X and Y fields define the position of the upper-left corner of the bounding rectangle that encompasses the chart. The position of the chart is referenced to the page. The Width and Height fields define the overall size (the bounding rectangle) of the chart, including title, pointing arrows, axis labels, etc. The position and size are specified in points (1/72 inch), using a fixed point format (two bytes integer, two bytes fraction).
The DATAFORMAT record contains the zero-based numbers of the data point and series. The subordinate records determine the format of the series or point defined by the DATAFORMAT record.
Summary description for ChartDataLabelsRecord.
This record stores options for the chart data table.
The DEFAULTTEXT record precedes a TEXT record to identify the text defined in the TEXT record as the default properties for certain chart items.
This record defines drop bars on a line chart. If the chart contains drop bars, the chart BIFF will contain two DROPBAR records. The first DROPBAR record corresponds to the up bar and the second DROPBAR record corresponds to the down bar.
Represents end display axis unit label record.
The FBI record stores font metrics.
This record is the child of a TEXT record and defines a text font by indexing the appropriate font in the font table. The font table is built from FONT records.
This record is written by Microsoft Excel but it is ignored. Applications writing chart BIFF do not need to write this record and applications reading chart BIFF can ignore it.
The FRAME record defines the border that is present around a displayed label as a rectangle. A displayed label can include the chart title, the legend (if not a regular rectangle), a category name, or a value amount.
This record stores fill effects such as gradient fills, patterns, textures, and so on. The record data is obtained from the Microsoft Office Drawing DLL.
This record specifies the number-format index for an axis.
The LEGEND record defines the location of the legend on the display and its overall size. The displayed legend contains all series on the chart.
This record specifies information about a legend entry which has been changed from the default legend-entry settings.
This record defines the appearance of a line, such as an axis line or border.
This record defines a line chart group.
This record defines the color and shape of the line markers that appear on scatter and line charts.
This record links a TEXT record to an object on the chart or to the entire chart.
This record defines the format for a picture attached to a data series or point.
The distance of an open pie slice from the center of the pie chart expressed as a percentage of the pie diameter. For example, if the percent = 33 (21h), the pie slice is one-third of the pie diameter away from the pie center.
This record defines a pie chart group and specifies pie chart options.
This record specifies the plot area layout information for attached label
This record stores scale factors for font scaling.
This record defines manual position information for the main-axis plot area, legend, and attached text (data labels, axis labels, and chart title). The record data depends on the record's use, as shown in the following sections.
This record defines a radar chart group.
This record specifies the PivotTable reference used for the chart.
This record stores the scatter chart properties.
This record defines the series error bars.
This record defines a series trend line.
This record specifies series formatting information.
This record is subordinate to the second CHARTFORMAT (overlay) record in a file and defines the series that are displayed as the overlay to the main chart. The first CHARTFORMAT (main chart) record in a file does not require a SERIESLIST record because all series, except those specified for the overlay, are included in the main chart.
This record describes the series of the chart and contains the type of data and number of data fields that make up the series. Series can contain 4000 points in Microsoft Excel version 5. The sdtX and sdtY fields define the type of data that is contained in this series. At present, the two types of data used in the Microsoft Excel chart series are numeric and text (date and sequence information is not used). The cValx and cValy fields contain the number of cell records in the series.
The value of the ID field determines the assignment of the text field.
This record indicates the series index for the series that the trend line or error bar is attached to. The series index is the number of the series in the BIFF (starting with series one).
This record is part of the series specifications and indicates the chart-group index for the series. The chart-group index specifies the number of the chart group (specified by a CHARTFORMAT record) in the BIFF, starting with chart group zero.
This record specifies chart sheet properties.
This record defines where a series appears in the list of series.
This record defines a surface chart group.
This record is used in conjunction with several child records (which further define the text displayed on the chart) to define the alignment, color, position, size, and so on of text fields that appear on the chart. The fields in this record have meaning according to the TEXT record's parent (CHART, LEGEND, or DEFAULTTEXT).
This record defines tick mark and tick label formatting.
This record defines the value axis.
This class wraps single record. Used in charts for DataLabels settings.
Represents wrapper for gel frame record.
Summary description for PrintedChartSizeRecord.
The Shadow record defines the Shadow properties and the 3D features(bevel top and bevel bottom),Lignting and Material properties
Represents interface, that implement mso option and fopte option wrapper classes.
Link index options.
Represents the Chart axis type.
Represents the text defaults options.
Type of marker.
Environment from which the file was written.
Type of data.