docx
    Preparing search index...

    Type Alias CategoryChartOptions

    CategoryChartOptions: ChartBaseOptions & {
        categories:
            | readonly (string | number | Date)[]
            | readonly ChartCategoryGroup[];
        categoryAxis?: ChartAxis;
        dataLabels?: ChartDataLabels;
        dataTable?: boolean | ChartDataTable;
        emptyValues?: ChartEmptyValues;
        secondaryValueAxis?: ChartValueAxis;
        series: readonly ChartSeries[];
        stacking?: ChartStacking;
        valueAxis?: ChartValueAxis;
    }

    Options of the charts with categories and values: column, bar, line and area charts.

    Type Declaration

    • Readonlycategories: readonly (string | number | Date)[] | readonly ChartCategoryGroup[]

      The categories along the chart's category axis, in order. If they are all numbers, they are written as numbers. If they are all dates, the axis is a date axis, which spaces them by date. Groups of categories, such as quarters in years, are labelled in rows, the groups below their categories

    • Optional ReadonlycategoryAxis?: ChartAxis

      The axis of categories

    • Optional ReadonlydataLabels?: ChartDataLabels

      Labels on each bar or point

    • Optional ReadonlydataTable?: boolean | ChartDataTable

      A table of the data under the plot, or true for one with Office's borders and legend keys. Default is none

    • Optional ReadonlyemptyValues?: ChartEmptyValues

      How empty values (null) are drawn: as gaps, as zero, or with a line joining the points either side. Default is "gap"

    • Optional ReadonlysecondaryValueAxis?: ChartValueAxis

      The secondary axis of values, on the right, for series with axis: "secondary". It has no gridlines by default

    • Readonlyseries: readonly ChartSeries[]

      The series, one value for each category

    • Optional Readonlystacking?: ChartStacking

      Whether the series of the chart's type are stacked. Default is "none"

    • Optional ReadonlyvalueAxis?: ChartValueAxis

      The axis of values