IAnaTabIds

AddGraphInfo #

Register a graph series in the tracking table

Signature:

Public Sub AddGraphInfo( _
    ByVal scope As Byte, _
    ByVal tabId As String, _
    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 outRangeAddress As String, _
    Optional ByVal hardCodeLabels As Boolean = False, _
    Optional ByVal prefix As String = vbNullString, _
    Optional ByVal prefixOnly As Boolean = False)

Methods for registering graph series and formatting metadata. Adds one series entry to the internal graph-tracking table. Each call records the series name, chart type, position, label text, column label, and output range address. Optional parameters control label hard-coding and prefix filtering for spatial and spatio-temporal scopes.

Parameters:

• scope: Byte. AnalysisIdsScope value selecting the target tracking table.
• tabId: String. Identifier of the parent analysis table.
• graphId: String. Identifier of the graph receiving this series.
• seriesName: String. Name of the data series.
• seriesType: String. Chart series type (e.g. "bar", "line").
• seriesPos: String. Position index of the series within the graph.
• seriesLabel: String. Display label for the series.
• seriesColumnLabel: String. Column header label for the series data.
• outRangeAddress: String. Worksheet address of the series data range.
• hardCodeLabels: Optional Boolean. When True, labels are written as literal values rather than cell references. Defaults to False.
• prefix: Optional String. Admin-level prefix for spatial graphs. Defaults to vbNullString.
• prefixOnly: Optional Boolean. When True, only the prefix series is written. Defaults to False.

---

AddGraphFormat #

Register graph formatting metadata in the tracking table

Signature:

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

Adds formatting information for a graph: category axis title, value axis title, optional plot title, and a height-factor multiplier. This data is consumed by WriteGraphs when rendering charts on the output worksheet.

Parameters:

• scope: Byte. AnalysisIdsScope value selecting the target tracking table.
• tabId: String. Identifier of the parent analysis table.
• graphId: String. Identifier of the graph to format.
• catTitle: String. Category (X) axis title.
• valuesTitle: String. Value (Y) axis title.
• hardCodeLabels: Optional Boolean. When True, axis labels are written as literal values. Defaults to False.
• heightFactor: Optional Long. Multiplier for graph height. Defaults to 1.
• plotTitle: Optional String. Title displayed above the chart area. Defaults to vbNullString.

---

AddTableInfos #

Register table named ranges in the tracking table

Signature:

Public Sub AddTableInfos( _
    ByVal scope As Byte, _
    ByVal tabId As String, _
    ByVal tabRangesNames As BetterArray, _
    Optional ByVal exportTable As String = "yes")

Methods for registering table named ranges for export. Adds the list of named range names created by a cross-table to the internal tracking table. These entries are used later during export to identify which ranges belong to each analysis table.

Parameters:

• scope: Byte. AnalysisIdsScope value selecting the target tracking table.
• tabId: String. Identifier of the analysis table.
• tabRangesNames: BetterArray. Collection of named range names to register.
• exportTable: Optional String. Export flag ("yes" or "no"). Defaults to "yes".

---

WriteGraphs #

Write all tracked graphs to the output worksheet

Signature:

Public Sub WriteGraphs(ByVal outsh As Worksheet, ByVal scope As Byte): End Sub

Methods for rendering tracked graphs on output worksheets. Iterates through the graph-tracking table for the specified scope and creates Excel chart objects on the output worksheet. Each graph is built from its registered series data and formatted according to the stored formatting metadata.

Parameters:

• outsh: Worksheet. The output worksheet receiving the chart objects.
• scope: Byte. AnalysisIdsScope value selecting which tracking table to read.

---