.PAGES File Format – Charts

Chart object and data

The chart drawable is TSCH.ChartDrawableArchive (type 5021), a TSD.DrawableArchive (super) that carries the chart in an extension field: ChartArchive.unity, field number 10000 of the drawable. Both messages reserve the extension range 10000 to 536870911. Older files use TSCH.PreUFF.ChartInfoArchive (type 5000) instead, described below.

message ChartDrawableArchive {                 // type 5021
  1 TSD.DrawableArchive super;  extensions 10000 to 536870911
}
message ChartArchive {
  1 ChartType chart_type;  2 ScatterFormat scatter_format;  3 RectArchive legend_frame;
  4 TSP.Reference preset;  5 SeriesDirection series_direction;  6 bool contains_default_data;
  7 ChartGridArchive grid;  8 TSP.Reference mediator;
  9 chart_style;  10 chart_non_style;  11 legend_style;  12 legend_non_style     // TSP.Reference
  13 rep value_axis_styles;  14 rep value_axis_nonstyles;  15 rep category_axis_styles;
  16 rep category_axis_nonstyles;  17 rep series_theme_styles                      // TSP.Reference
  18 SparseReferenceArrayArchive series_private_styles;  19 SparseReferenceArrayArchive series_non_styles;
  20 rep TSP.Reference paragraph_styles;  21 uint32 multidataset_index;
  22 bool needs_calc_engine_deferred_import_action
  extend ChartDrawableArchive { 10000 ChartArchive unity }
}
message ChartPasteboardAdditionsArchive {
  extend ChartArchive { 10000 uint32 preset_index_for_pasteboard;  10001 bytes preset_uuid_for_pasteboard }
}
extend ChartArchive { 10002 bool scene3d_settings_constant_depth }
message ChartGridArchive {
  1 rep string row_name;  2 rep string column_name;  3 rep GridRow grid_row
  message GridRow { 1 rep GridValue value
    message GridValue { 1 double numeric_value; 2 double date_value } }
}
message ChartMediatorArchive {                 // type 5004
  1 TSP.Reference info;  2 rep uint32 local_series_indexes;  3 rep uint32 remote_series_indexes }
message RectArchive { 1 req TSP.Point origin; 2 req TSP.Size size }
message SparseReferenceArrayArchive { 1 req uint32 num_entries; 2 rep Entry entries
  message Entry { 1 req uint32 index; 2 req TSP.Reference value } }
message ChartsNSNumberDoubleArchive { 1 double number_archive }
message ChartsNSArrayOfNSNumberDoubleArchive { 1 rep double numbers }
message ChartFormatStructExtensions {
  extend TSK.FormatStructArchive { 10000 string prefix;  10001 string suffix } }

The grid holds the chart’s own copy of the data: row names, column names and rows of values, each value a number or a date number. How the chart is linked to a table is not stated in the messages (unknown); ChartMediatorArchive has series indexes that are called “local” and “remote”, which suggests that data can come from another object.

Enumerations

The integer codes stored in the style properties below (symbol types, line types, label positions, error-bar and trend-line types, scale and tick-mark locations) are plain int32 values and are not named in the sources: unknown.

Presets, style containers and selection

message ChartStylePreset {                     // type 5020
  1 chart_style;  2 legend_style;  3 rep value_axis_styles;  4 rep category_axis_styles;
  5 rep series_styles;  6 rep paragraph_styles     // TSP.Reference;   7 bytes uuid }
message ChartPresetsArchive { 1 rep TSP.Reference chart_presets
  extend TSS.ThemeArchive { 120 req ChartPresetsArchive extension } }
message PropertyValueStorageContainerArchive {
  1 chart_style;  2 chart_nonstyle;  3 legend_style;  4 legend_nonstyle                 // TSP.Reference
  5 value_axis_styles;  6 value_axis_nonstyles;  7 category_axis_styles;  8 category_axis_nonstyles;
  9 series_theme_styles;  10 series_private_styles;  11 series_nonstyles;  12 paragraph_styles   // SparseReferenceArrayArchive
}
message StylePasteboardDataArchive {           // type 5129
  1 TSS.StyleArchive super;  2 PropertyValueStorageContainerArchive style_network;  3 bool copied_from_entire_chart }
message ChartSelectionPathTypeArchive { 1 string path_type; 2 string path_name }
message ChartAxisIDArchive { 1 AxisType axis_type; 2 uint32 ordinal }
message ChartSelectionPathArgumentArchive { 1 uint32 number; 2 ChartAxisIDArchive axis_id }
message ChartSelectionPathArchive { 1 ChartSelectionPathTypeArchive path_type; 2 ChartSelectionPathArchive sub_selection;
  3 rep ChartSelectionPathArgumentArchive arguments }
message ChartSelectionArchive { 1 TSP.Reference chart; 2 rep ChartSelectionPathArchive paths }
message ChartUIState { 1 TSP.Reference chart; 2 int32 cde_last_row_selected; 3 int32 cde_last_col_selected;
  4 int32 cde_last_row_count; 5 int32 cde_last_col_count }
message ChartStyleArchive [5022], ChartNonStyleArchive [5023], LegendStyleArchive [5024],
        LegendNonStyleArchive [5025], ChartAxisStyleArchive [5026], ChartAxisNonStyleArchive [5027],
        ChartSeriesStyleArchive [5028], ChartSeriesNonStyleArchive [5029]  {
  1 TSS.StyleArchive super;  extensions 10000 to 536870911 }

Every chart style is a TSS.StyleArchive that has no fields of its own; its properties are extension fields 10000 of the generated messages in the next section. A style holds the properties that belong to the look (fills, strokes, shadows, paragraph style indexes); a non-style holds the settings that are not look (titles, scale, number formats, show and hide switches, data for error bars). The …paragraphstyleindex properties are indexes into the chart’s paragraph_styles list.

Generated style properties

The messages of TSCH.Generated carry one optional field per property. Each is attached to its style message as extend TSCH.<Name> { 10000 TSCH.Generated.<Name> current }. Property names are shown as written, in lower case. Unless noted, the first word after tschchart names the object (info is the chart itself).

Generated.ChartStyleArchive

1 float tschchartinfodefault3dchartopacity
2 area, 3 bar, 4 column, 5 default, 6 line, 7 pie:  Chart3DLightingPackageArchive tschchartinfo<kind>3dlightingpackage
8 FillArchive tschchartinfodefaultbackgroundfill        9 StrokeArchive tschchartinfodefaultbackgroundstroke
10 float tschchartinfodefaultborderopacity              11 ShadowArchive tschchartinfodefaultbordershadow
12 StrokeArchive tschchartinfodefaultborderstroke       13 bool tschchartinfodefaultcombinelayers
14 FillArchive tschchartinfodefaultgridbackgroundfill   15 float tschchartinfodefaultgridbackgroundopacity
16 float tschchartinfodefaultinterbargap                 17 float tschchartinfodefaultintersetgap
18 bool tschchartinfodefaultshowborder                   19 TSP.Color tschchartinfodefaulttitlecolor
20 int32 tschchartinfodefaulttitleparagraphstyleindex   21 int32 tschchartinfodefaultdatasetnameparagraphstyleindex

Generated.ChartNonStyleArchive

1 int32 tschchartinfodefault3dbarshape                   2 bool tschchartinfodefault3dbeveledges
3 float tschchartinfodefault3dintersetdepthgap
4 Chart3DVectorArchive tschchartinfodefault3drotation
5 area, 6 bar, 7 column, 8 default, 9 line, 10 pie:  Chart3DVectorArchive tschchartinfo<kind>3dscale
11 Chart3DVectorArchive tschchartinfodefault3dviewport
19 float tschchartinfodefaultpiestartangle               20 bool tschchartinfodefaultshowlegend
21 bool tschchartinfodefaultshowtitle                    22 bool tschchartinfodefaultskiphiddendata
23 string tschchartinfodefaulttitle                      24 int32 tschchartinfodefaultdatasetnamelocation
25 int32 tschchartinfodefaultmultidatacontroltype

Generated.LegendStyleArchive, LegendNonStyleArchive

1 FillArchive tschlegendmodeldefaultfill                 2 int32 tschlegendmodeldefaultlabelparagraphstyleindex
3 float tschlegendmodeldefaultopacity                    4 ShadowArchive tschlegendmodeldefaultshadow
5 StrokeArchive tschlegendmodeldefaultstroke             (LegendNonStyleArchive has no properties)

Generated.ChartAxisStyleArchive

Each property comes in a category form (for the category axis) and a value form (for the value axis); “default” forms apply to both.

category 3dgridlineopacity 1 float | value 2 float | category 3dgridlinestroke 3 | value 4 (StrokeArchive)
categoryhorizontalspacing 5 int32 | categoryverticalspacing 41 int32
category 6 | default 7 | value 8 labelparagraphstyleindex (int32)
category 9 | default 10 | value 11 labelsorientation (float)
category 12 | value 13 majorgridlineopacity (float);  14 | 15 majorgridlineshadow (ShadowArchive);  16 | 17 majorgridlinestroke (StrokeArchive)
category 18 | value 19 minorgridlineopacity (float);  20 | 21 minorgridlineshadow;  22 | 23 minorgridlinestroke
category 24 | value 25 showaxis (bool);  26 categoryshowlastlabel (bool)
category 27 | value 28 showmajorgridlines;  29 | 30 showmajortickmarks;  32 | 33 showminorgridlines;  34 | 35 showminortickmarks (bool)
31 valueshowminimumlabel (bool)
category 36 | value 37 tickmarklocation (int32)
category 38 | default 39 | value 40 titleparagraphstyleindex (int32)
(every name is tschchartaxis + the words above, e.g. tschchartaxiscategory3dgridlineopacity = 1)

Generated.ChartAxisNonStyleArchive

1 int32 tschchartaxisdefault3dlabelposition   2 TSK.FormatStructArchive tschchartaxisdefaultnumberformat
3 int32 tschchartaxisdefaultnumberformattype  4 int32 tschchartaxisvaluenumberofdecades
5 int32 tschchartaxisvaluenumberofmajorgridlines  6 int32 tschchartaxisvaluenumberofminorgridlines
7 bool tschchartaxiscategoryplottoedges        8 int32 tschchartaxisvaluescale
9 bool tschchartaxiscategoryshowlabels         10 bool tschchartaxisdefaultshowlabels
11 bool tschchartaxisvalueshowlabels            12 bool tschchartaxiscategoryshowserieslabels
19 bool tschchartaxismultidatashowserieslabels  13 bool tschchartaxiscategoryshowtitle
14 bool tschchartaxisvalueshowtitle             15 string tschchartaxiscategorytitle
16 string tschchartaxisvaluetitle               17 ChartsNSNumberDoubleArchive tschchartaxisdefaultusermax
18 ChartsNSNumberDoubleArchive tschchartaxisdefaultusermin

Generated.ChartSeriesStyleArchive

Names are tschchartseries plus the chart kind (area, bar, bubble, column, line, mixed, mixedarea, mixedcolumn, mixedline, pie, scatter, default, 3d…) plus the property.

1 LineEndArchive tschchartseriesdefaulterrorbarlineend    2 LineEndArchive …errorbarlineendscatterx
3 ShadowArchive …defaulterrorbarshadow                   4 StrokeArchive …defaulterrorbarstroke   5 …errorbarstrokescatterx
FillArchive:  6 3dareafill  7 3dbarfill  8 3dcolumnfill  9 3dlinefill  10 3dpiefill  11 areafill  12 barfill  13 columnfill
              14 defaultfill  15 mixedareafill  16 mixedcolumnfill  17 piefill
int32 label paragraph style index (…labelparagraphstyleindex):  18 area  19 bar  20 default  21 line  22 mixed  23 pie
24 float tschchartseriesdefaultopacity
int32 outside label paragraph style index (…outsidelabelparagraphstyleindex):  25 area  26 bar  27 default  28 mixed  29 pie
ShadowArchive:  30 3dareashadow  31 3dbarshadow  32 3dcolumnshadow  33 3dlineshadow  34 3dpieshadow  35 areashadow  36 barshadow
                37 bubbleshadow  38 defaultshadow  39 lineshadow  40 mixedareashadow  41 mixedcolumnshadow  42 mixedlineshadow
                43 pieshadow  44 scattershadow
StrokeArchive:  45 areastroke  46 barstroke  47 bubblestroke  48 linestroke  49 mixedareastroke  50 mixedcolumnstroke
                51 mixedlinestroke  52 piestroke  53 scatterstroke
FillArchive symbol fill:  54 areasymbolfill  55 bubblesymbolfill  56 linesymbolfill  57 mixedareasymbolfill  58 mixedlinesymbolfill  59 scattersymbolfill
bool symbolfilluseseriesfill:  60 area  61 line  62 mixedarea  63 mixedline
bool symbolfilluseseriesstroke:  64 area  65 bubble  66 line  67 mixedarea  68 mixedline  69 scatter
float symbolsize:  70 area  71 line  72 mixedarea  73 mixedline  74 scatter
StrokeArchive symbolstroke:  75 area  76 bubble  77 line  78 mixedarea  79 mixedline  80 scatter
81 float …defaulttrendlineequationopacity   82 int32 …defaulttrendlineequationparagraphstyleindex
83 float …defaulttrendlinersquaredopacity   84 int32 …defaulttrendlinersquaredparagraphstyleindex
85 ShadowArchive …defaulttrendlineshadow    86 StrokeArchive …defaulttrendlinestroke
int32 valuelabelposition:  87 area  88 bar  89 bubble  90 default  91 line  92 mixedarea  93 mixedcolumn  94 mixedline  95 scatter
                           96 stackedarea  97 stackedbar

Generated.ChartSeriesNonStyleArchive

1 float …bubbleadjustmentscale
2 | 3 | 4 | 5 ChartsNSArrayOfNSNumberDoubleArchive …defaulterrorbarcustomnegativedata | …negativedatascatterx | …positivedata | …positivedatascatterx
6 | 7 float …errorbarfixedvalue | …scatterx      8 | 9 float …errorbarpercentvalue | …scatterx
10 | 11 int32 …errorbarsetting | …scatterx       12 | 13 float …errorbarstddevvalue | …scatterx
14 | 15 int32 …errorbartype | …scatterx
16 float …pielabelexplosion                      63 float …piewedgeexplosion
int32 linetype:  17 bubble  18 line  19 mixedline  20 scatter
21 TSK.FormatStructArchive …defaultnumberformat  22 TSK.FormatStructArchive …pienumberformat
23 int32 …defaultnumberformattype  24 int32 …pienumberformattype  25 TSK.FormatStructArchive …stackedpercentnumberformat
26 int32 …defaultseriestype
27 bool …defaultshowerrorbar  28 …scatterx   29 bool …scattershowline  30 bool …bubbleshownegativedata
31 bool …pieshowserieslabels  65 bool …bubbleshowserieslabels  67 bool …scattershowserieslabels
bool showsymbol:  32 area  33 line  34 mixedarea  35 mixedline  36 scatter
37 bool …defaultshowtrendline
bool showvaluelabels:  38 area  39 bar  40 bubble  41 default  42 line  43 mixed  44 pie  45 scatter
46 int32 …bubblesizedimension
int32 symboltype:  47 area  48 line  49 mixedarea  50 mixedline  51 scatter
52 float …defaulttrendlineequationoffsetx  53 …offsety   57 float …trendlinersquaredoffsetx  58 …offsety
54 string …defaulttrendlinelabelstring       55 int32 …defaulttrendlineorder    56 int32 …defaulttrendlineperiod
59 bool …trendlineshowequation  60 bool …trendlineshowlabel  61 bool …trendlineshowr2value  62 int32 …defaulttrendlinetype
64 int32 …defaultyaxisordinal   66 int32 …bubblevaluelabelsaxis   68 int32 …scattervaluelabelsaxis

The lines above are a shortened form of the field list: where several fields have the same type and the same name apart from one word, the field numbers and the changing words are listed together, in the order of the numbers. Every name starts with tschchartseries.

3D lighting and textures

message Chart3DVectorArchive { 1 req float x; 2 req float y; 3 req float z; 4 req float w }
message Chart3DFillArchive { 1 Chart3DLightingModelArchive lightingmodel; 2 string textureset_id;
  3 FillPropertyType fill_type; 4 uint32 series_index }
extend TSD.FillArchive { 100 Chart3DFillArchive fill3d }
message DEPRECATEDChart3DFillArchive { 1 TSD.FillArchive fill; 2 Chart3DLightingModelArchive lightingmodel;
  3 string textureset_id; 4 FillPropertyType fill_type; 5 uint32 series_index }
message Chart3DLightingModelArchive { 1 Chart3DPhongLightingModelArchive phong;
  2 Chart3DFixedFunctionLightingModelArchive fixed_function; 3 Chart3DEnvironmentPackageArchive environment }
message Chart3DLightingPackageArchive { 1 req string name; 2 rep Chart3DLightArchive lights }
message Chart3DLightArchive { 1 req string name; 2 req Chart3DVectorArchive ambient_color; 3 req ... diffuse_color;
  4 req ... specular_color; 5 req float intensity; 6 req Chart3DVectorArchive attenuation;
  7 req uint32 coordinate_space; 8 req bool enabled; 9 Chart3DPointLightArchive point_light;
  10 Chart3DDirectionalLightArchive directional_light; 11 Chart3DSpotLightArchive spot_light }
message Chart3DPointLightArchive { 1 req Chart3DVectorArchive position }
message Chart3DDirectionalLightArchive { 1 req Chart3DVectorArchive direction }
message Chart3DSpotLightArchive { 1 req Chart3DVectorArchive position; 2 req Chart3DVectorArchive direction;
  3 req float cutoff; 4 req float dropoff }
message Chart3DPhongLightingModelArchive { 1 req Chart3DPhongMaterialPackageArchive materials }
message Chart3DFixedFunctionLightingModelArchive { 1 req Chart3DPhongMaterialPackageArchive materials }
message Chart3DPhongMaterialPackageArchive { 1 Chart3DEmissiveMaterialArchive emissive; 2 Chart3DDiffuseMaterialArchive diffuse;
  3 Chart3DModulateMaterialArchive modulate; 4 Chart3DSpecularMaterialArchive specular; 5 Chart3DShininessMaterialArchive shininess }
message Chart3DEnvironmentPackageArchive { 1 rep Chart3DEnvironmentMaterialArchive materials }
message Chart3DTexturesMaterialArchive { 1 req Chart3DVectorArchive color; 2 rep Chart3DTSPImageDataTextureArchive textures }
Chart3DEmissiveMaterialArchive, Chart3DDiffuseMaterialArchive, Chart3DModulateMaterialArchive,
  Chart3DSpecularMaterialArchive, Chart3DShininessMaterialArchive:
  1 req Chart3DTexturesMaterialArchive super;  2 rep Chart3DImageTextureTilingArchive tilings
message Chart3DEnvironmentMaterialArchive { 1 req Chart3DTexturesMaterialArchive super;
  2 rep Chart3DBaseImageTextureTilingArchive OBSOLETE_tilings; 3 bool decalMode; 4 rep Chart3DImageTextureTilingArchive tilings }
message Chart3DTSPImageDataTextureArchive { 3 TSP.DataReference data; 4 TSP.DataReference mipmapdata;
  1 TSP.Reference database_data; 2 TSP.Reference database_mipmapdata }
message Chart3DBaseImageTextureTilingArchive { 1 Chart3DVectorArchive scale; 2 float rotation }
message Chart3DImageTextureTilingArchive { 1 req Chart3DBaseImageTextureTilingArchive super;
  2 TextureTilingMode mode; 3 TextureTilingWrap wrap; 4 TextureTilingFace face; 5 TextureTilingXPosition xposition;
  6 TextureTilingYPosition yposition; 7 TextureTilingContinuity scontinuity; 8 TextureTilingContinuity tcontinuity; 9 bool reveal }

The meaning of coordinate_space and of the four components of the vector (w) is not stated (unknown).

The older (pre-UFF) chart form

The types 5000 to 5017 belong to the namespace TSCH.PreUFF. “UFF” is not explained in the source; the messages keep the property names but use different field numbers, so they are an earlier layout of the same chart settings. They have their own chart, legend, model, grid and number format messages.

message ChartInfoArchive {                     // type 5000
  1 req TSD.DrawableArchive super;  2 req ChartModelArchive chart_model;  3 TSP.Reference style;
  4 req ChartType chart_type;  5 LegendModelArchive legend_model;  6 req RectArchive inner_chart_frame;
  7 rep value_axis_styles;  8 rep category_axis_styles;  9 rep value_axis_nonstyles;
  10 rep category_axis_nonstyles;  11 rep series_theme_styles                       // TSP.Reference
  12 SparseReferenceArrayArchive series_private_styles;  13 SparseReferenceArrayArchive series_non_styles;
  14 TSP.Reference non_style;  15 TSP.Reference mediator;  16 TSP.Point cde_preview_origin;
  17 TSP.Reference chart_style_preset;  18 rep TSP.Reference paragraph_styles;
  19 int32 last_row_sected_in_the_cde;  20 int32 last_column_sected_in_the_cde;
  21 int32 chart_style_preset_index;  22 bool needs_calc_engine_deferred_import_action }
message LegendModelArchive { 1 TSP.Reference info; 2 req RectArchive frame; 3 req TSP.Reference style; 4 req TSP.Reference non_style }
message ChartModelArchive { 1 TSP.Reference info; 2 req TSP.Reference grid; 3 rep uint32 series_types;
  4 uint32 scatter_format; 5 ChartGridArchive inline_grid; 6 uint32 multidataset_index }
message ChartGridArchive { 1 req int32 direction; 2 rep string row_name; 3 rep string column_name;
  4 rep ValueRow value_row; 6 req bool dirty;   message ValueRow { 1 rep double value } }
message ChartsNumberFormatArchive {
  1 req NumberValueType value_type;  2 string format_string;  3 req uint32 decimal_places;  4 string currency_code;
  5 req NegativeNumberStyle negative_style;  6 req bool show_thousands_separator;  7 req FractionAccuracy fraction_accuracy;
  8 string suffix_string;  9 req uint32 base;  10 req uint32 base_places;  11 req bool base_use_minus_sign;
  12 req bool use_accounting_style;  13 req bool is_custom;  14 req double scale_factor;
  15 rep string interstitial_strings;  16 req TSP.IndexSet interstitial_string_insertion_indexes;
  17 req uint32 index_from_right_of_last_digit_placeholder;  18 req bool is_text_format;
  19 req uint32 minimum_integer_width;  20 req uint32 decimal_width;
  21 req uint32 number_of_non_space_integer_placeholder_digits;
  22 req uint32 number_of_non_space_decimal_placeholder_digits;  23 string format_name;  24 string prefix_string }
ChartStyleArchive [5010], ChartSeriesStyleArchive [5011], ChartAxisStyleArchive [5012], LegendStyleArchive [5013],
ChartNonStyleArchive [5014], ChartSeriesNonStyleArchive [5015], ChartAxisNonStyleArchive [5016],
LegendNonStyleArchive [5017]:   1 req TSS.StyleArchive super, then the property fields below
ChartGridArchive [5002] is the type of the model’s grid; ChartMediatorArchive is 5004 (as above).

The pre-UFF property fields have the same names and types as the generated ones above; only the numbers differ. They are listed by message, as name=number (names start with tschchartinfo, tschlegendmodel, tschchartaxis or tschchartseries as given).

PreUFF.ChartStyleArchive

defaultbackgroundfill=10 defaultbackgroundstroke=11 defaultgridbackgroundfill=12 defaultintersetgap=13
defaultinterbargap=14 defaultshowborder=15 defaultborderstroke=16 defaulttitlecolor=18
defaultgridbackgroundopacity=19 defaultcombinelayers=20 defaultbordershadow=21 defaultborderopacity=22
defaulttitleparagraphstyleindex=23 defaultdeprecatedmasterfontfamily=24 (string)
defaultdeprecatedmasterfontnamedsize=25 (int32) defaultdeprecatedtrendlineequationparagraphstyleindex=30
defaultdeprecatedtrendlinersquaredparagraphstyleindex=31 defaultdeprecatedtrendlineequationshadow=32
defaultdeprecatedtrendlinersquaredshadow=33 defaultdeprecatedtrendlineequationopacity=34
defaultdeprecatedtrendlinersquaredopacity=35 bardeprecated3dshadow=308 columndeprecated3dshadow=309
linedeprecated3dshadow=310 areadeprecated3dshadow=311 piedeprecated3dshadow=312
default3dlightingpackage=313 column3dlightingpackage=314 bar3dlightingpackage=315 line3dlightingpackage=316
area3dlightingpackage=317 pie3dlightingpackage=318 defaultdeprecated3dbeveledges=326 piedeprecated3dbeveledges=327
bardeprecated3dbeveledges=328 columndeprecated3dbeveledges=329 defaultdeprecated3dbarshape=330
default3dchartopacity=335

PreUFF.ChartNonStyleArchive

defaulttitle=10 defaultshowlegend=11 defaultpiestartangle=12 defaultshowtitle=13
defaultdeprecatedagainmasterfontnamedsize=25 default3drotation=300 default3dscale=301 column3dscale=302
bar3dscale=303 line3dscale=304 area3dscale=305 pie3dscale=306 default3dviewport=313
defaultdeprecated3dlightingpackage=320 columndeprecated3dlightingpackage=321 bardeprecated3dlightingpackage=322
linedeprecated3dlightingpackage=323 areadeprecated3dlightingpackage=324 piedeprecated3dlightingpackage=325
defaultskiphiddendata=326 default3dbeveledges=327 default3dbarshape=336 default3dintersetdepthgap=331

PreUFF.LegendStyleArchive

tschlegendmodeldefaultfill=10 …stroke=11 …shadow=14 …opacity=15 …labelparagraphstyleindex=16

PreUFF.ChartAxisStyleArchive

value: showmajorgridlines=10 showminorgridlines=11 majorgridlinestroke=12 minorgridlinestroke=13 tickmarklocation=14
  showmajortickmarks=15 showminortickmarks=16 labelsorientation=17 showminimumlabel=18 majorgridlineshadow=21
  minorgridlineshadow=22 majorgridlineopacity=23 minorgridlineopacity=24 showaxis=25
category: showmajorgridlines=50 showminorgridlines=51 majorgridlinestroke=52 minorgridlinestroke=53 tickmarklocation=54
  showmajortickmarks=55 showminortickmarks=56 labelsorientation=57 horizontalspacing=58 verticalspacing=59
  showlastlabel=60 majorgridlineshadow=63 minorgridlineshadow=64 majorgridlineopacity=65 minorgridlineopacity=66 showaxis=67
default: labelsorientation=102 titleparagraphstyleindex=110 labelparagraphstyleindex=111
value: titleparagraphstyleindex=112 labelparagraphstyleindex=113   category: titleparagraphstyleindex=114 labelparagraphstyleindex=115
3d: value3dgridlinestroke=331 category3dgridlinestroke=332 value3dgridlineopacity=333 category3dgridlineopacity=334
(all names start tschchartaxis + the group word)

PreUFF.ChartAxisNonStyleArchive

defaultusermin=11 defaultusermax=12 defaultnumberformat=13 (ChartsNumberFormatArchive) defaultshowlabels=14
value: numberofminorgridlines=50 scale=51 numberofdecades=52 showlabels=53 showtitle=54 numberofmajorgridlines=55 title=56
category: showlabels=100 showserieslabels=101 showtitle=102 title=103 plottoedges=116
defaultnumberformattype=120 default3dlabelposition=336

PreUFF.ChartSeriesStyleArchive

defaulttrendlineequationparagraphstyleindex=201 defaulttrendlinersquaredparagraphstyleindex=202
defaulttrendlineequationopacity=205 defaulttrendlinersquaredopacity=206
barfill=10 barstroke=11 barvaluelabelposition=13 linestroke=16 linesymbolfill=17 linesymbolstroke=18 linesymbolsize=20
linevaluelabelposition=22 areafill=25 areastroke=26 areavaluelabelposition=28 areasymbolfill=29 areasymbolstroke=30
areasymbolsize=32 piefill=35 piestroke=36 scatterstroke=40 scattersymbolfill=41 scattersymbolstroke=42
scattersymbolsize=44 scattervaluelabelposition=46 defaultfill=50 defaultvaluelabelposition=52
piedeprecatedserieslabelson=60 (bool) columnfill=62
pieshadow=100 barshadow=101 areashadow=102 scattershadow=103 mixedlineshadow=104 mixedareashadow=105
mixedcolumnshadow=106 lineshadow=107 defaultshadow=108
defaultlabelparagraphstyleindex=110 barlabel…=111 linelabel…=112 arealabel…=113 pielabel…=114 mixedlabel…=115
defaultopacity=116 linesymbolfilluseseriesstroke=117 areasymbolfilluseseriesstroke=118 scattersymbolfilluseseriesstroke=119
mixedlinesymbolfilluseseriesstroke=120 mixedareasymbolfilluseseriesstroke=121 linesymbolfilluseseriesfill=122
areasymbolfilluseseriesfill=123 mixedlinesymbolfilluseseriesfill=124 mixedareasymbolfilluseseriesfill=125
mixedcolumnfill=130 mixedareafill=131 mixedcolumnstroke=132 mixedlinestroke=133 mixedareastroke=134
mixedlinesymbolsize=135 mixedareasymbolsize=136 mixedlinesymbolfill=137 mixedareasymbolfill=138
mixedlinesymbolstroke=139 mixedareasymbolstroke=140 mixedcolumnvaluelabelposition=141
mixedlinevaluelabelposition=142 mixedareavaluelabelposition=143 defaultoutsidelabelparagraphstyleindex=150
baroutsidelabel…=151 areaoutsidelabel…=153 pieoutsidelabel…=154 mixedoutsidelabel…=155
stackedbarvaluelabelposition=156 stackedareavaluelabelposition=157 defaulttrendlinestroke=167
defaulttrendlineshadow=168 defaulterrorbarshadow=180 defaulterrorbarstroke=181 defaulterrorbarstrokescatterx=182
defaulterrorbarlineend=183 defaulterrorbarlineendscatterx=184 bubblesymbolfill=207 bubblestroke=211
bubblesymbolstroke=212 bubblevaluelabelposition=213 bubbleshadow=214 bubblesymbolfilluseseriesstroke=215
3dbarshadow=306 3dcolumnshadow=307 3dlineshadow=308 3dareashadow=309 3dpieshadow=310
defaultdeprecated3dfill=300 bardeprecated3dfill=301 columndeprecated3dfill=302 linedeprecated3dfill=303
areadeprecated3dfill=304 piedeprecated3dfill=305 (DEPRECATEDChart3DFillArchive)
3dbarfill=320 3dcolumnfill=321 3dlinefill=322 3dareafill=323 3dpiefill=324
(a name ending … is the same as the one before it, with the kind word changed)

PreUFF.ChartSeriesNonStyleArchive

defaultnumberformat=10 (ChartsNumberFormatArchive) defaultnumberformattype=11 barshowvaluelabels=12
linesymboltype=19 lineshowsymbol=20 lineshowvaluelabels=21 areashowvaluelabels=27 linelinetype=30
areasymboltype=31 areashowsymbol=32 pieshowvaluelabels=37 scattershowvaluelabels=45 piewedgeexplosion=50
defaultshowvaluelabels=51 pienumberformat=52 pienumberformattype=53 pielabelexplosion=54 mixedlineshowsymbol=58
mixedareashowsymbol=59 mixedlinesymboltype=60 mixedareasymboltype=61 mixedshowvaluelabels=62 mixedlinelinetype=63
defaultyaxisordinal=65 pieshowserieslabels=66 scattershowsymbol=69 scattersymboltype=70 scatterlinetype=71
scattershowline=72 stackedpercentnumberformat=90 defaultseriestype=126 defaulttrendlinetype=160
defaulttrendlineorder=161 defaulttrendlineperiod=162 defaulttrendlineshowlabel=163 defaulttrendlinelabelstring=164
defaulttrendlineshowequation=165 defaulttrendlineshowr2value=166 defaulterrorbarsetting=170
defaulterrorbarsettingscatterx=171 defaulterrorbartype=172 defaulterrorbartypescatterx=173
defaulterrorbarfixedvalue=174 …scatterx=175 defaulterrorbarpercentvalue=176 …scatterx=177
defaulterrorbarstddevvalue=178 …scatterx=179 defaulterrorbarcustompositivedata=190 …scatterx=191
defaulterrorbarcustomnegativedata=192 …scatterx=193 defaulttrendlineequationoffsetx=194 …offsety=195
defaulttrendlinersquaredoffsetx=196 …offsety=197 defaultshowtrendline=198 defaultshowerrorbar=199
defaultshowerrorbarscatterx=200 bubblesizedimension=208 bubbleshowvaluelabels=209 bubblelinetype=210
bubbleshownegativedata=216 bubbleadjustmentscale=217
(all names start tschchartseries; types as in Generated.ChartSeriesNonStyleArchive)

Source

TSCHArchives.proto, TSCHArchives.Common.proto, TSCHArchives.GEN.proto, TSCH3DArchives.proto and TSCHPreUFFArchives.proto from iWorkFileFormat (Messages/Proto), read in full; type numbers from Common.json. In the shortened property lists a repeated word or an ellipsis stands for text copied from the entry before it; the original files have one line per field. Not in the sources: the integer codes behind style properties, how a chart is bound to a table, and anything after Pages 5.0.