AnaTabIds

The tracking worksheet holds a single ListObject. Every row carries the scope it belongs to and a kind: a series row describes one chart series, a format row describes the look of one chart. The rows of one chart stay together because they are appended in call order, and the reader starts a new chart when the graph identifier changes.

Every named range of an analysis table was created by CrossTable through Range.Name, so the workbook already holds it. TransferNames reads the workbook name collection, keeps the names that resolve to a range on the analysis sheet, and creates each one at the same address on the output sheet. The collection is walked once per export and sorted by owning worksheet, because the export asks for four sheets in turn.

Analysis scopes. Each one is a sheet of the generated linelist. This class is the leaf that reads the value, so it owns the enum: AnalysisOutput and LLExporter both name it, and the generated linelist carries this class without carrying AnalysisOutput.

A fifth member used to sit here, standing for the tables-only pass. It was a build stage wearing the type of a scope, and four Select Case blocks that route on a scope had no branch for it. AnalysisOutput owns that enum now, under the name AnalysisBuildStage.

Column positions of the registry table. The headers are written from this enum by PrepareSheet, so one place decides both the layout and every read.

Depends on: Graphs

Version: 2026-07-30

Create #

create

Create a new AnaTabIds instance bound to a tracking worksheet

Signature:

Public Function Create(ByVal idsh As Worksheet, _
                       Optional ByVal check As Boolean = True) As AnaTabIds

Factory method on the predeclared instance. Validates the worksheet reference and, when asked, that the registry table is on the sheet. Pass check as False while the linelist is still being built.

Parameters:

• idsh: Worksheet. The worksheet hosting the registry table.
• check: Optional Boolean. When True, calls CheckRequirements. Defaults to True.

Returns: AnaTabIds. A fully initialised tracking instance.

Throws:

• ProjectError.InvalidArgument When idsh is Nothing.
• ProjectError.InvalidArgument When check is True and the registry table is missing.

---

PrepareSheet #

prepare-sheet

Build the registry table on a tracking worksheet

Signature:

Public Sub PrepareSheet(ByVal idsh As Worksheet)

Called on the predeclared instance while the linelist is being built. Writes the header row from RegistryColumnIndex and lists it as REGISTRY_TABLE. A sheet that already carries the table is left as it is, so a second build over the same workbook changes nothing.

Parameters:

• idsh: Worksheet. The worksheet to prepare.

Throws:

• ProjectError.InvalidArgument When idsh is Nothing.

---

AddGraphInfo #

add-graph-info

Register a graph series row in the registry

Signature:

Public Sub AddGraphInfo(ByVal scope As Byte, _
                        ByVal graphId As String, _
                        ByVal seriesName As String, _
                        ByVal seriesType As String, _
                        ByVal seriesPos As String, _
                        ByVal seriesLabel As String, _
                        ByVal seriesColumnLabel As String, _
                        ByVal hardCodeLabels As Boolean, _
                        ByVal outRangeAddress As String, _
                        Optional ByVal prefix As String = vbNullString, _
                        Optional ByVal prefixOnly As Boolean = False)

Methods for registering graph series and formatting metadata.

Writes one series row. The rows of one chart have to stay together, and they do because every writer registers the series of a chart one after the other. The two flags are stored as 0 or 1 so they survive a save and reopen.

Parameters:

• scope: Byte. AnalysisScope value the chart belongs to.
• graphId: String. Identifier of the chart receiving this series.
• seriesName: String. Named range name for the series data.
• seriesType: String. Chart series type (e.g. "line").
• seriesPos: String. Axis position indicator for the series.
• seriesLabel: String. Named range name for category labels.
• seriesColumnLabel: String. Named range name for column header labels.
• hardCodeLabels: Boolean. When True, labels are written as literals.
• outRangeAddress: String. Cell address for chart placement on output.
• prefix: Optional String. Admin-level prefix for spatial graphs. Defaults to vbNullString.
• prefixOnly: Optional Boolean. When True, only the prefix is used as the label. Defaults to False.

Throws:

• ProjectError.InvalidArgument When the scope is unknown.

---

AddGraphFormat #

add-graph-format

Register the look of one chart in the registry

Signature:

Public Sub AddGraphFormat(ByVal scope As Byte, _
                          ByVal graphId As String, _
                          ByVal catTitle As String, _
                          ByVal valuesTitle As String, _
                          ByVal hardCodeLabels As Boolean, _
                          Optional ByVal heightFactor As Long = 1, _
                          Optional ByVal plotTitle As String = vbNullString)

Writes one format row, found again by the graph identifier when the chart has all its series.

Parameters:

• scope: Byte. AnalysisScope value the chart belongs to.
• graphId: String. Identifier of the chart to format.
• catTitle: String. Category (X) axis title.
• valuesTitle: String. Value (Y) axis title.
• hardCodeLabels: Boolean. When True, axis labels are written as literals.
• heightFactor: Optional Long. Multiplier for chart height. Defaults to 1.
• plotTitle: Optional String. Chart title. Defaults to vbNullString.

Throws:

• ProjectError.InvalidArgument When the scope is unknown.

---

TransferNames #

transfer-names

Recreate every named range of an analysis sheet on the output sheet

Signature:

Public Sub TransferNames(ByVal inpsh As Worksheet, ByVal outsh As Worksheet)

Copying the named ranges of an analysis sheet to the output sheet.

A chart reads its values and its labels through named ranges, so the output sheet needs the same names at the same addresses. The names are read from the workbook collection: every one of them was created on the analysis sheet by the table builder, which is why nothing has to be stored to find them again. A name holding a value has no range behind it, so it is skipped, and so is a name that no longer resolves.

Parameters:

• inpsh: Worksheet. The analysis sheet the names live on.
• outsh: Worksheet. The sheet the names are recreated on.

Throws:

• ProjectError.InvalidArgument When either worksheet is Nothing.

---

WriteGraphs #

write-graphs

Recreate the named ranges and the charts of one scope

Signature:

Public Sub WriteGraphs(ByVal outsh As Worksheet, ByVal scope As Byte, _
                       ByVal inpsh As Worksheet)

Drawing the tracked charts on an output worksheet.

Copies the named ranges of the analysis sheet first, because a chart cannot read a series before its name exists. Then walks the series rows of the scope in registry order and starts a new chart every time the graph identifier changes. Each chart is formatted once it holds all its series.

Parameters:

• outsh: Worksheet. The output worksheet receiving the charts.
• scope: Byte. AnalysisScope value selecting the registry rows.
• inpsh: Worksheet. The analysis sheet the names are copied from. The caller holds it already, which is why it is passed in.

Remarks:

• Application.GoTo scrolls to the chart position, which some Excel versions need for correct chart placement. It also means the output sheet has to be selectable.

Throws:

• ProjectError.InvalidArgument When a worksheet is Nothing or the scope is unknown.

---