Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

OfficeChartLayout

OfficeIMO.Drawing

Namespace
OfficeIMO.Drawing
Assembly
OfficeIMO.Core
Source revision
ba882f6b0d07 with working tree changes
Modifiers
sealed

Reusable chart layout metadata shared by OfficeIMO chart renderers and format exporters.

Inheritance

  • object
  • OfficeChartLayout

Usage

Explore 8 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Accepted by parameters 1

Constructors

OfficeChartLayout 4 overloads
public OfficeChartLayout(double? seriesLegendWidthRatio, double? categoryLegendWidthRatio, double? legendRowHeight, double? legendSwatchSize, double? legendTextGap, double? legendFontSize, string? legendFontFamily, double? axisLabelFontSize, string? axisTextFontFamily, double? categoryAxisLabelWidth, double? radarCategoryLabelWidth, int? maximumCategoryAxisLabels, int? maximumHorizontalCategoryAxisLabels, int? maximumRadarCategoryLabels, bool preventLabelOverlap, bool showLegend, OfficeChartLegendPosition legendPosition, bool showDataLabels, bool showDataLabelValues, bool showDataLabelPercentages, bool showDataLabelCategoryNames, bool showDataLabelSeriesNames, string? dataLabelSeparator, double? dataLabelFontSize, string? dataLabelFontFamily, OfficeChartDataLabelPosition dataLabelPosition, string? dataLabelNumberFormat, bool showMarkers, string? axisNumberFormat, string? categoryAxisTitle, string? valueAxisTitle, string? horizontalAxisNumberFormat, string? verticalAxisNumberFormat, bool connectScatterPoints, bool fillRadarSeries, bool showCategoryAxis, bool showValueAxis, bool showCategoryAxisLine, bool showValueAxisLine, bool showCategoryAxisLabels, bool showValueAxisLabels, OfficeChartAxisTickLabelPosition horizontalAxisTickLabelPosition, OfficeChartAxisTickLabelPosition verticalAxisTickLabelPosition, OfficeChartAxisCrossingPosition horizontalAxisCrossingPosition, OfficeChartAxisCrossingPosition verticalAxisCrossingPosition, bool reverseCategoryAxis, bool overlayTitle, double? titleTopPadding, OfficeFontStyle? legendFontStyle, OfficeFontStyle? axisTextFontStyle, OfficeFontStyle? dataLabelFontStyle, double? axisTitleFontSize, string? axisTitleFontFamily, OfficeFontStyle? axisTitleFontStyle, double? horizontalAxisDisplayUnitDivisor, string? horizontalAxisDisplayUnitLabel, double? verticalAxisDisplayUnitDivisor, string? verticalAxisDisplayUnitLabel, double? horizontalAxisMinimum, double? horizontalAxisMaximum, double? horizontalAxisMajorUnit, double? horizontalAxisMinorUnit, double? verticalAxisMinimum, double? verticalAxisMaximum, double? verticalAxisMajorUnit, double? verticalAxisMinorUnit, OfficeChartAxisTickMark horizontalAxisMajorTickMark, OfficeChartAxisTickMark verticalAxisMajorTickMark, OfficeChartAxisTickMark horizontalAxisMinorTickMark, OfficeChartAxisTickMark verticalAxisMinorTickMark) #

Creates chart layout metadata using the constructor contract that predates category-axis formatting extensions.

Parameters

seriesLegendWidthRatio double? required
categoryLegendWidthRatio double? required
legendRowHeight double? required
legendSwatchSize double? required
legendTextGap double? required
legendFontSize double? required
legendFontFamily string? required
axisLabelFontSize double? required
axisTextFontFamily string? required
categoryAxisLabelWidth double? required
radarCategoryLabelWidth double? required
maximumCategoryAxisLabels int? required
maximumHorizontalCategoryAxisLabels int? required
maximumRadarCategoryLabels int? required
preventLabelOverlap bool required
showLegend bool required
legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition required
showDataLabels bool required
showDataLabelValues bool required
showDataLabelPercentages bool required
showDataLabelCategoryNames bool required
showDataLabelSeriesNames bool required
dataLabelSeparator string? required
dataLabelFontSize double? required
dataLabelFontFamily string? required
dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition required
dataLabelNumberFormat string? required
showMarkers bool required
axisNumberFormat string? required
categoryAxisTitle string? required
valueAxisTitle string? required
horizontalAxisNumberFormat string? required
verticalAxisNumberFormat string? required
connectScatterPoints bool required
fillRadarSeries bool required
showCategoryAxis bool required
showValueAxis bool required
showCategoryAxisLine bool required
showValueAxisLine bool required
showCategoryAxisLabels bool required
showValueAxisLabels bool required
horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition required
verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition required
horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition required
verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition required
reverseCategoryAxis bool required
overlayTitle bool required
titleTopPadding double? required
legendFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
axisTitleFontSize double? required
axisTitleFontFamily string? required
axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
horizontalAxisDisplayUnitDivisor double? required
horizontalAxisDisplayUnitLabel string? required
verticalAxisDisplayUnitDivisor double? required
verticalAxisDisplayUnitLabel string? required
horizontalAxisMinimum double? required
horizontalAxisMaximum double? required
horizontalAxisMajorUnit double? required
horizontalAxisMinorUnit double? required
verticalAxisMinimum double? required
verticalAxisMaximum double? required
verticalAxisMajorUnit double? required
verticalAxisMinorUnit double? required
horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
public OfficeChartLayout(bool overlayLegend, double? seriesLegendWidthRatio, double? categoryLegendWidthRatio, double? legendRowHeight, double? legendSwatchSize, double? legendTextGap, double? legendFontSize, string? legendFontFamily, double? axisLabelFontSize, string? axisTextFontFamily, double? categoryAxisLabelWidth, double? radarCategoryLabelWidth, int? maximumCategoryAxisLabels, int? maximumHorizontalCategoryAxisLabels, int? maximumRadarCategoryLabels, bool preventLabelOverlap, bool showLegend, OfficeChartLegendPosition legendPosition, bool showDataLabels, bool showDataLabelValues, bool showDataLabelPercentages, bool showDataLabelCategoryNames, bool showDataLabelSeriesNames, string? dataLabelSeparator, double? dataLabelFontSize, string? dataLabelFontFamily, OfficeChartDataLabelPosition dataLabelPosition, string? dataLabelNumberFormat, bool showMarkers, string? axisNumberFormat, string? categoryAxisTitle, string? valueAxisTitle, string? horizontalAxisNumberFormat, string? verticalAxisNumberFormat, bool connectScatterPoints, bool fillRadarSeries, bool showCategoryAxis, bool showValueAxis, bool showCategoryAxisLine, bool showValueAxisLine, bool showCategoryAxisLabels, bool showValueAxisLabels, OfficeChartAxisTickLabelPosition horizontalAxisTickLabelPosition, OfficeChartAxisTickLabelPosition verticalAxisTickLabelPosition, OfficeChartAxisCrossingPosition horizontalAxisCrossingPosition, OfficeChartAxisCrossingPosition verticalAxisCrossingPosition, bool reverseCategoryAxis, bool overlayTitle, double? titleTopPadding, OfficeFontStyle? legendFontStyle, OfficeFontStyle? axisTextFontStyle, OfficeFontStyle? dataLabelFontStyle, double? axisTitleFontSize, string? axisTitleFontFamily, OfficeFontStyle? axisTitleFontStyle, double? horizontalAxisDisplayUnitDivisor, string? horizontalAxisDisplayUnitLabel, double? verticalAxisDisplayUnitDivisor, string? verticalAxisDisplayUnitLabel, double? horizontalAxisMinimum, double? horizontalAxisMaximum, double? horizontalAxisMajorUnit, double? horizontalAxisMinorUnit, double? verticalAxisMinimum, double? verticalAxisMaximum, double? verticalAxisMajorUnit, double? verticalAxisMinorUnit, OfficeChartAxisTickMark horizontalAxisMajorTickMark, OfficeChartAxisTickMark verticalAxisMajorTickMark, OfficeChartAxisTickMark horizontalAxisMinorTickMark, OfficeChartAxisTickMark verticalAxisMinorTickMark) #

Creates chart layout metadata with explicit legend overlay behavior using the earlier constructor contract.

Parameters

overlayLegend bool required
seriesLegendWidthRatio double? required
categoryLegendWidthRatio double? required
legendRowHeight double? required
legendSwatchSize double? required
legendTextGap double? required
legendFontSize double? required
legendFontFamily string? required
axisLabelFontSize double? required
axisTextFontFamily string? required
categoryAxisLabelWidth double? required
radarCategoryLabelWidth double? required
maximumCategoryAxisLabels int? required
maximumHorizontalCategoryAxisLabels int? required
maximumRadarCategoryLabels int? required
preventLabelOverlap bool required
showLegend bool required
legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition required
showDataLabels bool required
showDataLabelValues bool required
showDataLabelPercentages bool required
showDataLabelCategoryNames bool required
showDataLabelSeriesNames bool required
dataLabelSeparator string? required
dataLabelFontSize double? required
dataLabelFontFamily string? required
dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition required
dataLabelNumberFormat string? required
showMarkers bool required
axisNumberFormat string? required
categoryAxisTitle string? required
valueAxisTitle string? required
horizontalAxisNumberFormat string? required
verticalAxisNumberFormat string? required
connectScatterPoints bool required
fillRadarSeries bool required
showCategoryAxis bool required
showValueAxis bool required
showCategoryAxisLine bool required
showValueAxisLine bool required
showCategoryAxisLabels bool required
showValueAxisLabels bool required
horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition required
verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition required
horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition required
verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition required
reverseCategoryAxis bool required
overlayTitle bool required
titleTopPadding double? required
legendFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
axisTitleFontSize double? required
axisTitleFontFamily string? required
axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle? required
horizontalAxisDisplayUnitDivisor double? required
horizontalAxisDisplayUnitLabel string? required
verticalAxisDisplayUnitDivisor double? required
verticalAxisDisplayUnitLabel string? required
horizontalAxisMinimum double? required
horizontalAxisMaximum double? required
horizontalAxisMajorUnit double? required
horizontalAxisMinorUnit double? required
verticalAxisMinimum double? required
verticalAxisMaximum double? required
verticalAxisMajorUnit double? required
verticalAxisMinorUnit double? required
horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark required
public OfficeChartLayout(double? seriesLegendWidthRatio = null, double? categoryLegendWidthRatio = null, double? legendRowHeight = null, double? legendSwatchSize = null, double? legendTextGap = null, double? legendFontSize = null, string? legendFontFamily = null, double? axisLabelFontSize = null, string? axisTextFontFamily = null, double? categoryAxisLabelWidth = null, double? radarCategoryLabelWidth = null, int? maximumCategoryAxisLabels = null, int? maximumHorizontalCategoryAxisLabels = null, int? maximumRadarCategoryLabels = null, bool preventLabelOverlap = true, bool showLegend = true, OfficeChartLegendPosition legendPosition = Right, bool showDataLabels = false, bool showDataLabelValues = false, bool showDataLabelPercentages = false, bool showDataLabelCategoryNames = false, bool showDataLabelSeriesNames = false, string? dataLabelSeparator = null, double? dataLabelFontSize = null, string? dataLabelFontFamily = null, OfficeChartDataLabelPosition dataLabelPosition = BestFit, string? dataLabelNumberFormat = null, bool showMarkers = true, string? axisNumberFormat = null, string? categoryAxisTitle = null, string? valueAxisTitle = null, string? horizontalAxisNumberFormat = null, string? verticalAxisNumberFormat = null, bool connectScatterPoints = true, bool fillRadarSeries = true, bool showCategoryAxis = true, bool showValueAxis = true, bool showCategoryAxisLine = true, bool showValueAxisLine = true, bool showCategoryAxisLabels = true, bool showValueAxisLabels = true, OfficeChartAxisTickLabelPosition horizontalAxisTickLabelPosition = NextTo, OfficeChartAxisTickLabelPosition verticalAxisTickLabelPosition = NextTo, OfficeChartAxisCrossingPosition horizontalAxisCrossingPosition = AutoZero, OfficeChartAxisCrossingPosition verticalAxisCrossingPosition = AutoZero, bool reverseCategoryAxis = false, bool overlayTitle = false, double? titleTopPadding = null, OfficeFontStyle? legendFontStyle = null, OfficeFontStyle? axisTextFontStyle = null, OfficeFontStyle? dataLabelFontStyle = null, double? axisTitleFontSize = null, string? axisTitleFontFamily = null, OfficeFontStyle? axisTitleFontStyle = null, double? horizontalAxisDisplayUnitDivisor = null, string? horizontalAxisDisplayUnitLabel = null, double? verticalAxisDisplayUnitDivisor = null, string? verticalAxisDisplayUnitLabel = null, double? horizontalAxisMinimum = null, double? horizontalAxisMaximum = null, double? horizontalAxisMajorUnit = null, double? horizontalAxisMinorUnit = null, double? verticalAxisMinimum = null, double? verticalAxisMaximum = null, double? verticalAxisMajorUnit = null, double? verticalAxisMinorUnit = null, OfficeChartAxisTickMark horizontalAxisMajorTickMark = None, OfficeChartAxisTickMark verticalAxisMajorTickMark = None, OfficeChartAxisTickMark horizontalAxisMinorTickMark = None, OfficeChartAxisTickMark verticalAxisMinorTickMark = None, string? categoryAxisNumberFormat = null, bool categoryAxisOrientationSpecified = false, IReadOnlyCollection<int>? dataLabelSeriesIndexes = null, IReadOnlyDictionary<int, IReadOnlyCollection<int>>? dataLabelPointIndexes = null, IReadOnlyDictionary<int, IReadOnlyCollection<int>>? hiddenDataLabelPointIndexes = null, IReadOnlyCollection<int>? hiddenCategoryLegendIndexes = null) #

Creates chart layout metadata.

Parameters

seriesLegendWidthRatio double? = null optional
Maximum chart-width ratio reserved for series legends.
categoryLegendWidthRatio double? = null optional
Maximum chart-width ratio reserved for category legends such as pie slices.
legendRowHeight double? = null optional
Legend row height.
legendSwatchSize double? = null optional
Legend color swatch size.
legendTextGap double? = null optional
Gap between a legend swatch and its label.
legendFontSize double? = null optional
Legend label font size.
legendFontFamily string? = null optional
Optional legend label font family.
axisLabelFontSize double? = null optional
Axis label font size.
axisTextFontFamily string? = null optional
Optional axis label/title font family.
categoryAxisLabelWidth double? = null optional
Maximum category-axis label width.
radarCategoryLabelWidth double? = null optional
Maximum radar category label width.
maximumCategoryAxisLabels int? = null optional
Maximum number of category-axis labels to render on cartesian charts.
maximumHorizontalCategoryAxisLabels int? = null optional
Maximum number of category-axis labels to render on horizontal bar charts.
maximumRadarCategoryLabels int? = null optional
Maximum number of category labels to render on radar charts.
preventLabelOverlap bool = true optional
Whether axis/category label stride should increase automatically to avoid obvious label overlap.
showLegend bool = true optional
Whether series or category legends should be rendered.
legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition = Right optional
Preferred legend placement when legends are rendered.
showDataLabels bool = false optional
Whether point data labels should be rendered when supported by a chart family.
showDataLabelValues bool = false optional
Whether point data labels should include values.
showDataLabelPercentages bool = false optional
Whether point data labels should include percentages.
showDataLabelCategoryNames bool = false optional
Whether point data labels should include category names.
showDataLabelSeriesNames bool = false optional
Whether point data labels should include series names.
dataLabelSeparator string? = null optional
Separator used between enabled data label parts.
dataLabelFontSize double? = null optional
Data label font size.
dataLabelFontFamily string? = null optional
Optional data label font family.
dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition = BestFit optional
Preferred data label position when labels are rendered.
dataLabelNumberFormat string? = null optional
Optional numeric format for data-label values.
showMarkers bool = true optional
Whether point markers should be rendered for marker-capable chart families.
axisNumberFormat string? = null optional
Optional numeric format for value-axis labels.
categoryAxisTitle string? = null optional
Optional category or horizontal axis title.
valueAxisTitle string? = null optional
Optional value or vertical axis title.
horizontalAxisNumberFormat string? = null optional
Optional numeric format for horizontal value-axis labels.
verticalAxisNumberFormat string? = null optional
Optional numeric format for vertical value-axis labels.
connectScatterPoints bool = true optional
Whether scatter points should be connected by series lines.
fillRadarSeries bool = true optional
Whether radar series polygons should be filled.
showCategoryAxis bool = true optional
Whether the category or horizontal axis should be rendered.
showValueAxis bool = true optional
Whether the value or vertical axis should be rendered.
showCategoryAxisLine bool = true optional
Whether the category or horizontal axis line should be rendered.
showValueAxisLine bool = true optional
Whether the value or vertical axis line should be rendered.
showCategoryAxisLabels bool = true optional
Whether category or horizontal tick labels should be rendered.
showValueAxisLabels bool = true optional
Whether value or vertical tick labels should be rendered.
horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo optional
Preferred tick-label side for the physical horizontal axis.
verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo optional
Preferred tick-label side for the physical vertical axis.
horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero optional
Physical crossing side for the horizontal axis.
verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero optional
Physical crossing side for the vertical axis.
reverseCategoryAxis bool = false optional
Whether category-axis slots should be rendered in reverse order.
overlayTitle bool = false optional
Whether category-axis orientation was explicitly supplied by the source chart.
titleTopPadding double? = null optional
Whether the title should overlay the plot instead of reserving layout space.
legendFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Top padding before the chart title inside the chart canvas.
axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Optional legend label font style.
dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Optional axis label font style and axis title fallback style.
axisTitleFontSize double? = null optional
Optional data label font style.
axisTitleFontFamily string? = null optional
Optional axis title font size.
axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Optional axis title font family.
horizontalAxisDisplayUnitDivisor double? = null optional
Optional axis title font style.
horizontalAxisDisplayUnitLabel string? = null optional
Optional divisor applied to horizontal value-axis labels.
verticalAxisDisplayUnitDivisor double? = null optional
Optional display-unit label shown for horizontal value axes.
verticalAxisDisplayUnitLabel string? = null optional
Optional divisor applied to vertical value-axis labels.
horizontalAxisMinimum double? = null optional
Optional display-unit label shown for vertical value axes.
horizontalAxisMaximum double? = null optional
Optional minimum for horizontal value axes.
horizontalAxisMajorUnit double? = null optional
Optional maximum for horizontal value axes.
horizontalAxisMinorUnit double? = null optional
Optional major tick/grid unit for horizontal value axes.
verticalAxisMinimum double? = null optional
Optional minor tick/grid unit for horizontal value axes.
verticalAxisMaximum double? = null optional
Optional minimum for vertical value axes.
verticalAxisMajorUnit double? = null optional
Optional maximum for vertical value axes.
verticalAxisMinorUnit double? = null optional
Optional major tick/grid unit for vertical value axes.
horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional minor tick/grid unit for vertical value axes.
verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional major tick mark placement for the horizontal axis.
horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional major tick mark placement for the vertical axis.
verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional minor tick mark placement for the horizontal axis.
categoryAxisNumberFormat string? = null optional
Optional minor tick mark placement for the vertical axis.
categoryAxisOrientationSpecified bool = false optional
Optional numeric format for numeric category-axis labels.
dataLabelSeriesIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null optional
Optional zero-based series indexes that should render data labels.
dataLabelPointIndexes System.Collections.Generic.IReadOnlyDictionary<int, System.Collections.Generic.IReadOnlyCollection<int>>? = null optional
Optional zero-based point indexes that should render data labels per series.
hiddenDataLabelPointIndexes System.Collections.Generic.IReadOnlyDictionary<int, System.Collections.Generic.IReadOnlyCollection<int>>? = null optional
Optional zero-based point indexes that should suppress data labels per series.
hiddenCategoryLegendIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null optional
Optional zero-based category or slice legend indexes that should be suppressed.
public OfficeChartLayout(bool overlayLegend, double? seriesLegendWidthRatio = null, double? categoryLegendWidthRatio = null, double? legendRowHeight = null, double? legendSwatchSize = null, double? legendTextGap = null, double? legendFontSize = null, string? legendFontFamily = null, double? axisLabelFontSize = null, string? axisTextFontFamily = null, double? categoryAxisLabelWidth = null, double? radarCategoryLabelWidth = null, int? maximumCategoryAxisLabels = null, int? maximumHorizontalCategoryAxisLabels = null, int? maximumRadarCategoryLabels = null, bool preventLabelOverlap = true, bool showLegend = true, OfficeChartLegendPosition legendPosition = Right, bool showDataLabels = false, bool showDataLabelValues = false, bool showDataLabelPercentages = false, bool showDataLabelCategoryNames = false, bool showDataLabelSeriesNames = false, string? dataLabelSeparator = null, double? dataLabelFontSize = null, string? dataLabelFontFamily = null, OfficeChartDataLabelPosition dataLabelPosition = BestFit, string? dataLabelNumberFormat = null, bool showMarkers = true, string? axisNumberFormat = null, string? categoryAxisTitle = null, string? valueAxisTitle = null, string? horizontalAxisNumberFormat = null, string? verticalAxisNumberFormat = null, bool connectScatterPoints = true, bool fillRadarSeries = true, bool showCategoryAxis = true, bool showValueAxis = true, bool showCategoryAxisLine = true, bool showValueAxisLine = true, bool showCategoryAxisLabels = true, bool showValueAxisLabels = true, OfficeChartAxisTickLabelPosition horizontalAxisTickLabelPosition = NextTo, OfficeChartAxisTickLabelPosition verticalAxisTickLabelPosition = NextTo, OfficeChartAxisCrossingPosition horizontalAxisCrossingPosition = AutoZero, OfficeChartAxisCrossingPosition verticalAxisCrossingPosition = AutoZero, bool reverseCategoryAxis = false, bool overlayTitle = false, double? titleTopPadding = null, OfficeFontStyle? legendFontStyle = null, OfficeFontStyle? axisTextFontStyle = null, OfficeFontStyle? dataLabelFontStyle = null, double? axisTitleFontSize = null, string? axisTitleFontFamily = null, OfficeFontStyle? axisTitleFontStyle = null, double? horizontalAxisDisplayUnitDivisor = null, string? horizontalAxisDisplayUnitLabel = null, double? verticalAxisDisplayUnitDivisor = null, string? verticalAxisDisplayUnitLabel = null, double? horizontalAxisMinimum = null, double? horizontalAxisMaximum = null, double? horizontalAxisMajorUnit = null, double? horizontalAxisMinorUnit = null, double? verticalAxisMinimum = null, double? verticalAxisMaximum = null, double? verticalAxisMajorUnit = null, double? verticalAxisMinorUnit = null, OfficeChartAxisTickMark horizontalAxisMajorTickMark = None, OfficeChartAxisTickMark verticalAxisMajorTickMark = None, OfficeChartAxisTickMark horizontalAxisMinorTickMark = None, OfficeChartAxisTickMark verticalAxisMinorTickMark = None, string? categoryAxisNumberFormat = null, bool categoryAxisOrientationSpecified = false, IReadOnlyCollection<int>? dataLabelSeriesIndexes = null, IReadOnlyDictionary<int, IReadOnlyCollection<int>>? dataLabelPointIndexes = null, IReadOnlyDictionary<int, IReadOnlyCollection<int>>? hiddenDataLabelPointIndexes = null, IReadOnlyCollection<int>? hiddenCategoryLegendIndexes = null) #

Creates chart layout metadata with explicit legend overlay behavior.

Parameters

overlayLegend bool required
Whether a legend should be drawn over the plot instead of reserving layout space.
seriesLegendWidthRatio double? = null optional
Maximum chart-width ratio reserved for series legends.
categoryLegendWidthRatio double? = null optional
Maximum chart-width ratio reserved for category legends such as pie slices.
legendRowHeight double? = null optional
Legend row height.
legendSwatchSize double? = null optional
Legend color swatch size.
legendTextGap double? = null optional
Gap between a legend swatch and its label.
legendFontSize double? = null optional
Legend label font size.
legendFontFamily string? = null optional
Optional legend label font family.
axisLabelFontSize double? = null optional
Axis label font size.
axisTextFontFamily string? = null optional
Optional axis label font family and axis title fallback family.
categoryAxisLabelWidth double? = null optional
Maximum category-axis label width.
radarCategoryLabelWidth double? = null optional
Maximum radar category label width.
maximumCategoryAxisLabels int? = null optional
Maximum number of category-axis labels to render on cartesian charts.
maximumHorizontalCategoryAxisLabels int? = null optional
Maximum number of category-axis labels to render on horizontal bar charts.
maximumRadarCategoryLabels int? = null optional
Maximum number of category labels to render on radar charts.
preventLabelOverlap bool = true optional
Whether axis/category label stride should increase automatically to avoid obvious label overlap.
showLegend bool = true optional
Whether series or category legends should be rendered.
legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition = Right optional
Preferred legend placement when legends are rendered.
showDataLabels bool = false optional
Whether point data labels should be rendered when supported by a chart family.
showDataLabelValues bool = false optional
Whether point data labels should include values.
showDataLabelPercentages bool = false optional
Whether point data labels should include percentages.
showDataLabelCategoryNames bool = false optional
Whether point data labels should include category names.
showDataLabelSeriesNames bool = false optional
Whether point data labels should include series names.
dataLabelSeparator string? = null optional
Separator used between enabled data label parts.
dataLabelFontSize double? = null optional
Data label font size.
dataLabelFontFamily string? = null optional
Optional data label font family.
dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition = BestFit optional
Preferred data label position when labels are rendered.
dataLabelNumberFormat string? = null optional
Optional numeric format for data-label values.
showMarkers bool = true optional
Whether point markers should be rendered for marker-capable chart families.
axisNumberFormat string? = null optional
Optional numeric format for value-axis labels.
categoryAxisTitle string? = null optional
Optional category or horizontal axis title.
valueAxisTitle string? = null optional
Optional value or vertical axis title.
horizontalAxisNumberFormat string? = null optional
Optional numeric format for horizontal value-axis labels.
verticalAxisNumberFormat string? = null optional
Optional numeric format for vertical value-axis labels.
connectScatterPoints bool = true optional
Whether scatter points should be connected by series lines.
fillRadarSeries bool = true optional
Whether radar series polygons should be filled.
showCategoryAxis bool = true optional
Whether the category or horizontal axis should be rendered.
showValueAxis bool = true optional
Whether the value or vertical axis should be rendered.
showCategoryAxisLine bool = true optional
Whether the category or horizontal axis line should be rendered.
showValueAxisLine bool = true optional
Whether the value or vertical axis line should be rendered.
showCategoryAxisLabels bool = true optional
Whether category or horizontal tick labels should be rendered.
showValueAxisLabels bool = true optional
Whether value or vertical tick labels should be rendered.
horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo optional
Preferred tick-label side for the physical horizontal axis.
verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo optional
Preferred tick-label side for the physical vertical axis.
horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero optional
Physical crossing side for the horizontal axis.
verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero optional
Physical crossing side for the vertical axis.
reverseCategoryAxis bool = false optional
Whether category-axis slots should be rendered in reverse order.
overlayTitle bool = false optional
Whether category-axis orientation was explicitly supplied by the source chart.
titleTopPadding double? = null optional
Whether the title should overlay the plot instead of reserving layout space.
legendFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Top padding before the chart title inside the chart canvas.
axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Optional legend label font style.
dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Optional axis label font style and axis title fallback style.
axisTitleFontSize double? = null optional
Optional data label font style.
axisTitleFontFamily string? = null optional
Optional axis title font size.
axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null optional
Optional axis title font family.
horizontalAxisDisplayUnitDivisor double? = null optional
Optional axis title font style.
horizontalAxisDisplayUnitLabel string? = null optional
Optional divisor applied to horizontal value-axis labels.
verticalAxisDisplayUnitDivisor double? = null optional
Optional display-unit label shown for horizontal value axes.
verticalAxisDisplayUnitLabel string? = null optional
Optional divisor applied to vertical value-axis labels.
horizontalAxisMinimum double? = null optional
Optional display-unit label shown for vertical value axes.
horizontalAxisMaximum double? = null optional
Optional minimum for horizontal value axes.
horizontalAxisMajorUnit double? = null optional
Optional maximum for horizontal value axes.
horizontalAxisMinorUnit double? = null optional
Optional major tick/grid unit for horizontal value axes.
verticalAxisMinimum double? = null optional
Optional minor tick/grid unit for horizontal value axes.
verticalAxisMaximum double? = null optional
Optional minimum for vertical value axes.
verticalAxisMajorUnit double? = null optional
Optional maximum for vertical value axes.
verticalAxisMinorUnit double? = null optional
Optional major tick/grid unit for vertical value axes.
horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional minor tick/grid unit for vertical value axes.
verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional major tick mark placement for the horizontal axis.
horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional major tick mark placement for the vertical axis.
verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None optional
Optional minor tick mark placement for the horizontal axis.
categoryAxisNumberFormat string? = null optional
Optional minor tick mark placement for the vertical axis.
categoryAxisOrientationSpecified bool = false optional
Optional numeric format for numeric category-axis labels.
dataLabelSeriesIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null optional
Optional zero-based series indexes that should render data labels.
dataLabelPointIndexes System.Collections.Generic.IReadOnlyDictionary<int, System.Collections.Generic.IReadOnlyCollection<int>>? = null optional
Optional zero-based point indexes that should render data labels per series.
hiddenDataLabelPointIndexes System.Collections.Generic.IReadOnlyDictionary<int, System.Collections.Generic.IReadOnlyCollection<int>>? = null optional
Optional zero-based point indexes that should suppress data labels per series.
hiddenCategoryLegendIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null optional
Optional zero-based category or slice legend indexes that should be suppressed.

Methods

public OfficeChartLayout WithBarGeometry(int gapWidthPercent, int overlapPercent) #

Returns a layout copy with the requested bar gap width and overlap.

Parameters

gapWidthPercent int required
The gap between clusters as a percentage of one bar's width, from 0 to 500.
overlapPercent int required
The overlap of clustered bars, from -100 to 100.
public OfficeChartLayout WithCategoryPointsOnTickMarks(bool onTickMarks) #

Returns a layout copy that places line and area points on the category tick marks or between them.

Parameters

onTickMarks bool required
public OfficeChartLayout WithDataLabelLeaderLines(bool show) #

Returns a layout copy with the requested outside radial leader-line setting.

Parameters

show bool required
public OfficeChartLayout WithHighLowLines(bool show, OfficeColor? color = null, double? width = null) #

Returns a layout copy that draws or hides high-low lines across the line series of each category.

Parameters

show bool required
Whether to draw high-low lines.
color OfficeIMO.OfficeColor? = null optional
The line colour, or null for the chart text colour.
width double? = null optional
The line width in points, greater than zero and at most 1584, or null for 0.75 points.
public OfficeChartLayout WithSecondaryValueAxis(OfficeChartValueAxisLayout? axis) #

Returns a layout copy with an independent secondary value-axis scale and format.

Parameters

axis OfficeIMO.Drawing.OfficeChartValueAxisLayout? required

Properties

public int BarGapWidthPercent { get; private set; } #

The gap between bar clusters as a percentage of one bar's width, from 0 to 500. New charts use the shared theme; imported Office charts without a value use 150.

public int BarOverlapPercent { get; private set; } #

How far bars in a cluster overlap, from -100 (a full bar apart) to 100 (fully overlapped).

public bool CategoryPointsOnTickMarks { get; private set; } #

Whether line and area points sit on the category tick marks (OOXML midCat) rather than in the middle of each category (OOXML between, the default).

public bool ShowHighLowLines { get; private set; } #

Whether a vertical line joins the highest and lowest line-series value in each category.

public OfficeColor? HighLowLineColor { get; private set; } #

The high-low line colour, or null for the chart text colour.

public double? HighLowLineWidth { get; private set; } #

The high-low line width in points, or null for 0.75 points.

public static OfficeChartLayout Default { get; } #

Default premium OfficeIMO chart layout.

public double SeriesLegendWidthRatio { get; } #

Maximum chart-width ratio reserved for series legends.

public double CategoryLegendWidthRatio { get; } #

Maximum chart-width ratio reserved for category legends such as pie slices.

public double LegendRowHeight { get; } #

Legend row height.

public double LegendSwatchSize { get; } #

Legend color swatch size.

public double LegendTextGap { get; } #

Gap between a legend swatch and its label.

public double LegendFontSize { get; } #

Legend label font size.

public string? LegendFontFamily { get; } #

Optional legend label font family.

public OfficeFontStyle? LegendFontStyle { get; } #

Optional legend label font style.

public double AxisLabelFontSize { get; } #

Axis label font size.

public string? AxisTextFontFamily { get; } #

Optional axis label font family and axis title fallback family.

public OfficeFontStyle? AxisTextFontStyle { get; } #

Optional axis label font style and axis title fallback style.

public double? AxisTitleFontSize { get; } #

Optional axis title font size.

public string? AxisTitleFontFamily { get; } #

Optional axis title font family.

public OfficeFontStyle? AxisTitleFontStyle { get; } #

Optional axis title font style.

public double CategoryAxisLabelWidth { get; } #

Maximum category-axis label width.

public double RadarCategoryLabelWidth { get; } #

Maximum radar category label width.

public int MaximumCategoryAxisLabels { get; } #

Maximum number of category-axis labels to render on cartesian charts.

public int MaximumHorizontalCategoryAxisLabels { get; } #

Maximum number of category-axis labels to render on horizontal bar charts.

public int MaximumRadarCategoryLabels { get; } #

Maximum number of category labels to render on radar charts.

public bool PreventLabelOverlap { get; } #

Whether axis/category label stride should increase automatically to avoid obvious label overlap.

public bool ShowLegend { get; } #

Whether series or category legends should be rendered.

public OfficeChartLegendPosition LegendPosition { get; } #

Preferred legend placement when legends are rendered.

public bool OverlayLegend { get; } #

Whether a legend should be drawn over the plot instead of reserving layout space.

public bool ShowDataLabels { get; } #

Whether point data labels should be rendered when supported by a chart family.

public bool ShowDataLabelValues { get; } #

Whether point data labels should include values.

public bool ShowDataLabelPercentages { get; } #

Whether point data labels should include percentages.

public bool ShowDataLabelCategoryNames { get; } #

Whether point data labels should include category names.

public bool ShowDataLabelSeriesNames { get; } #

Whether point data labels should include series names.

public string DataLabelSeparator { get; } #

Separator used between enabled data label parts.

public double DataLabelFontSize { get; } #

Data label font size.

public string? DataLabelFontFamily { get; } #

Optional data label font family.

public OfficeFontStyle? DataLabelFontStyle { get; } #

Optional data label font style.

public OfficeChartDataLabelPosition DataLabelPosition { get; } #

Preferred data label position when labels are rendered.

public string? DataLabelNumberFormat { get; } #

Whether radial outside data labels connect to their slices with leader lines.

public IReadOnlyCollection<int>? DataLabelSeriesIndexes { get; } #

Optional zero-based series indexes that should render data labels; null means every series may render labels.

public IReadOnlyDictionary<int, IReadOnlyCollection<int>>? DataLabelPointIndexes { get; } #

Optional zero-based point indexes that should render data labels per series; null means every point may render labels.

public IReadOnlyDictionary<int, IReadOnlyCollection<int>>? HiddenDataLabelPointIndexes { get; } #

Optional zero-based point indexes that should suppress data labels per series.

public IReadOnlyCollection<int>? HiddenCategoryLegendIndexes { get; } #

Optional zero-based category or slice legend indexes that should be suppressed for category legends.

public bool ShowMarkers { get; } #

Whether point markers should be rendered for marker-capable chart families.

public string? AxisNumberFormat { get; } #

Optional numeric format for value-axis labels.

public string? HorizontalAxisNumberFormat { get; } #

Optional numeric format for horizontal value-axis labels.

public string? VerticalAxisNumberFormat { get; } #

Optional numeric format for vertical value-axis labels.

public string? CategoryAxisNumberFormat { get; } #

Optional numeric format for numeric category-axis labels.

public double? HorizontalAxisDisplayUnitDivisor { get; } #

Optional divisor applied to horizontal value-axis labels.

public string? HorizontalAxisDisplayUnitLabel { get; } #

Optional display-unit label shown for horizontal value axes.

public double? VerticalAxisDisplayUnitDivisor { get; } #

Optional divisor applied to vertical value-axis labels.

public string? VerticalAxisDisplayUnitLabel { get; } #

Optional display-unit label shown for vertical value axes.

public double? HorizontalAxisMinimum { get; } #

Optional minimum for horizontal value axes.

public double? HorizontalAxisMaximum { get; } #

Optional maximum for horizontal value axes.

public double? HorizontalAxisMajorUnit { get; } #

Optional major tick/grid unit for horizontal value axes.

public double? HorizontalAxisMinorUnit { get; } #

Optional minor tick/grid unit for horizontal value axes.

public double? VerticalAxisMinimum { get; } #

Optional minimum for vertical value axes.

public double? VerticalAxisMaximum { get; } #

Optional maximum for vertical value axes.

public double? VerticalAxisMajorUnit { get; } #

Optional major tick/grid unit for vertical value axes.

public double? VerticalAxisMinorUnit { get; } #

Optional minor tick/grid unit for vertical value axes.

public OfficeChartAxisTickMark HorizontalAxisMajorTickMark { get; } #

Major tick mark placement for the horizontal axis.

public OfficeChartAxisTickMark VerticalAxisMajorTickMark { get; } #

Major tick mark placement for the vertical axis.

public OfficeChartAxisTickMark HorizontalAxisMinorTickMark { get; } #

Minor tick mark placement for the horizontal axis.

public OfficeChartAxisTickMark VerticalAxisMinorTickMark { get; } #

Minor tick mark placement for the vertical axis.

public string? CategoryAxisTitle { get; } #

Optional category or horizontal axis title.

public string? ValueAxisTitle { get; } #

Optional value or vertical axis title.

public bool ConnectScatterPoints { get; } #

Whether scatter points should be connected by series lines.

public bool FillRadarSeries { get; } #

Whether radar series polygons should be filled.

public bool ShowCategoryAxis { get; } #

Whether the category or horizontal axis should be rendered.

public bool ShowValueAxis { get; } #

Whether the value or vertical axis should be rendered.

public bool ShowCategoryAxisLine { get; } #

Whether the category or horizontal axis line should be rendered.

public bool ShowValueAxisLine { get; } #

Whether the value or vertical axis line should be rendered.

public bool ShowCategoryAxisLabels { get; } #

Whether category or horizontal tick labels should be rendered.

public bool ShowValueAxisLabels { get; } #

Whether value or vertical tick labels should be rendered.

public OfficeChartAxisTickLabelPosition HorizontalAxisTickLabelPosition { get; } #

Preferred tick-label side for the physical horizontal axis.

public OfficeChartAxisTickLabelPosition VerticalAxisTickLabelPosition { get; } #

Preferred tick-label side for the physical vertical axis.

public OfficeChartAxisCrossingPosition HorizontalAxisCrossingPosition { get; } #

Physical crossing side for the horizontal axis.

public OfficeChartAxisCrossingPosition VerticalAxisCrossingPosition { get; } #

Physical crossing side for the vertical axis.

public bool ReverseCategoryAxis { get; } #

Whether category-axis slots should be rendered in reverse order.

public bool CategoryAxisOrientationSpecified { get; } #

Whether category-axis orientation was explicitly supplied by the source chart.

public bool OverlayTitle { get; } #

Whether the chart title should overlay the plot area instead of reserving a title band.

public double TitleTopPadding { get; } #

Top padding before the chart title inside the chart canvas.

public bool ShowDataLabelLeaderLines { get; private set; } #

Whether outside radial labels connect to their slices.

public OfficeChartValueAxisLayout? SecondaryValueAxis { get; private set; } #

Independent secondary value-axis scale and format, or automatic settings when absent.

Fields

public const int MaximumDataLabelSeparatorCharacters #

Maximum length of a separator copied into each rendered data label.

Value: 64