OfficeChartLayout
OfficeIMO.Drawing
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.
Returned or exposed by 7
- Method OfficeChartLayout.WithBarGeometry
- Method OfficeChartLayout.WithCategoryPointsOnTickMarks
- Method OfficeChartLayout.WithDataLabelLeaderLines
- Method OfficeChartLayout.WithHighLowLines
- Method OfficeChartLayout.WithSecondaryValueAxis
- Property OfficeChartLayout.Default
- Property OfficeChartSnapshot.Layout
Accepted by parameters 1
- Constructor OfficeChartSnapshot.OfficeChartSnapshot
Constructors
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?
- categoryLegendWidthRatio double?
- legendRowHeight double?
- legendSwatchSize double?
- legendTextGap double?
- legendFontSize double?
- legendFontFamily string?
- axisLabelFontSize double?
- axisTextFontFamily string?
- categoryAxisLabelWidth double?
- radarCategoryLabelWidth double?
- maximumCategoryAxisLabels int?
- maximumHorizontalCategoryAxisLabels int?
- maximumRadarCategoryLabels int?
- preventLabelOverlap bool
- showLegend bool
- legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition
- showDataLabels bool
- showDataLabelValues bool
- showDataLabelPercentages bool
- showDataLabelCategoryNames bool
- showDataLabelSeriesNames bool
- dataLabelSeparator string?
- dataLabelFontSize double?
- dataLabelFontFamily string?
- dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition
- dataLabelNumberFormat string?
- showMarkers bool
- axisNumberFormat string?
- categoryAxisTitle string?
- valueAxisTitle string?
- horizontalAxisNumberFormat string?
- verticalAxisNumberFormat string?
- connectScatterPoints bool
- fillRadarSeries bool
- showCategoryAxis bool
- showValueAxis bool
- showCategoryAxisLine bool
- showValueAxisLine bool
- showCategoryAxisLabels bool
- showValueAxisLabels bool
- horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition
- verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition
- horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition
- verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition
- reverseCategoryAxis bool
- overlayTitle bool
- titleTopPadding double?
- legendFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- axisTitleFontSize double?
- axisTitleFontFamily string?
- axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- horizontalAxisDisplayUnitDivisor double?
- horizontalAxisDisplayUnitLabel string?
- verticalAxisDisplayUnitDivisor double?
- verticalAxisDisplayUnitLabel string?
- horizontalAxisMinimum double?
- horizontalAxisMaximum double?
- horizontalAxisMajorUnit double?
- horizontalAxisMinorUnit double?
- verticalAxisMinimum double?
- verticalAxisMaximum double?
- verticalAxisMajorUnit double?
- verticalAxisMinorUnit double?
- horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
- verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
- horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
- verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
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
- seriesLegendWidthRatio double?
- categoryLegendWidthRatio double?
- legendRowHeight double?
- legendSwatchSize double?
- legendTextGap double?
- legendFontSize double?
- legendFontFamily string?
- axisLabelFontSize double?
- axisTextFontFamily string?
- categoryAxisLabelWidth double?
- radarCategoryLabelWidth double?
- maximumCategoryAxisLabels int?
- maximumHorizontalCategoryAxisLabels int?
- maximumRadarCategoryLabels int?
- preventLabelOverlap bool
- showLegend bool
- legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition
- showDataLabels bool
- showDataLabelValues bool
- showDataLabelPercentages bool
- showDataLabelCategoryNames bool
- showDataLabelSeriesNames bool
- dataLabelSeparator string?
- dataLabelFontSize double?
- dataLabelFontFamily string?
- dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition
- dataLabelNumberFormat string?
- showMarkers bool
- axisNumberFormat string?
- categoryAxisTitle string?
- valueAxisTitle string?
- horizontalAxisNumberFormat string?
- verticalAxisNumberFormat string?
- connectScatterPoints bool
- fillRadarSeries bool
- showCategoryAxis bool
- showValueAxis bool
- showCategoryAxisLine bool
- showValueAxisLine bool
- showCategoryAxisLabels bool
- showValueAxisLabels bool
- horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition
- verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition
- horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition
- verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition
- reverseCategoryAxis bool
- overlayTitle bool
- titleTopPadding double?
- legendFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- axisTitleFontSize double?
- axisTitleFontFamily string?
- axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle?
- horizontalAxisDisplayUnitDivisor double?
- horizontalAxisDisplayUnitLabel string?
- verticalAxisDisplayUnitDivisor double?
- verticalAxisDisplayUnitLabel string?
- horizontalAxisMinimum double?
- horizontalAxisMaximum double?
- horizontalAxisMajorUnit double?
- horizontalAxisMinorUnit double?
- verticalAxisMinimum double?
- verticalAxisMaximum double?
- verticalAxisMajorUnit double?
- verticalAxisMinorUnit double?
- horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
- verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
- horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
- verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark
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
- Maximum chart-width ratio reserved for series legends.
- categoryLegendWidthRatio double? = null
- Maximum chart-width ratio reserved for category legends such as pie slices.
- legendRowHeight double? = null
- Legend row height.
- legendSwatchSize double? = null
- Legend color swatch size.
- legendTextGap double? = null
- Gap between a legend swatch and its label.
- legendFontSize double? = null
- Legend label font size.
- legendFontFamily string? = null
- Optional legend label font family.
- axisLabelFontSize double? = null
- Axis label font size.
- axisTextFontFamily string? = null
- Optional axis label/title font family.
- categoryAxisLabelWidth double? = null
- Maximum category-axis label width.
- radarCategoryLabelWidth double? = null
- Maximum radar category label width.
- maximumCategoryAxisLabels int? = null
- Maximum number of category-axis labels to render on cartesian charts.
- maximumHorizontalCategoryAxisLabels int? = null
- Maximum number of category-axis labels to render on horizontal bar charts.
- maximumRadarCategoryLabels int? = null
- Maximum number of category labels to render on radar charts.
- preventLabelOverlap bool = true
- Whether axis/category label stride should increase automatically to avoid obvious label overlap.
- showLegend bool = true
- Whether series or category legends should be rendered.
- legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition = Right
- Preferred legend placement when legends are rendered.
- showDataLabels bool = false
- Whether point data labels should be rendered when supported by a chart family.
- showDataLabelValues bool = false
- Whether point data labels should include values.
- showDataLabelPercentages bool = false
- Whether point data labels should include percentages.
- showDataLabelCategoryNames bool = false
- Whether point data labels should include category names.
- showDataLabelSeriesNames bool = false
- Whether point data labels should include series names.
- dataLabelSeparator string? = null
- Separator used between enabled data label parts.
- dataLabelFontSize double? = null
- Data label font size.
- dataLabelFontFamily string? = null
- Optional data label font family.
- dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition = BestFit
- Preferred data label position when labels are rendered.
- dataLabelNumberFormat string? = null
- Optional numeric format for data-label values.
- showMarkers bool = true
- Whether point markers should be rendered for marker-capable chart families.
- axisNumberFormat string? = null
- Optional numeric format for value-axis labels.
- categoryAxisTitle string? = null
- Optional category or horizontal axis title.
- valueAxisTitle string? = null
- Optional value or vertical axis title.
- horizontalAxisNumberFormat string? = null
- Optional numeric format for horizontal value-axis labels.
- verticalAxisNumberFormat string? = null
- Optional numeric format for vertical value-axis labels.
- connectScatterPoints bool = true
- Whether scatter points should be connected by series lines.
- fillRadarSeries bool = true
- Whether radar series polygons should be filled.
- showCategoryAxis bool = true
- Whether the category or horizontal axis should be rendered.
- showValueAxis bool = true
- Whether the value or vertical axis should be rendered.
- showCategoryAxisLine bool = true
- Whether the category or horizontal axis line should be rendered.
- showValueAxisLine bool = true
- Whether the value or vertical axis line should be rendered.
- showCategoryAxisLabels bool = true
- Whether category or horizontal tick labels should be rendered.
- showValueAxisLabels bool = true
- Whether value or vertical tick labels should be rendered.
- horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo
- Preferred tick-label side for the physical horizontal axis.
- verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo
- Preferred tick-label side for the physical vertical axis.
- horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero
- Physical crossing side for the horizontal axis.
- verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero
- Physical crossing side for the vertical axis.
- reverseCategoryAxis bool = false
- Whether category-axis slots should be rendered in reverse order.
- overlayTitle bool = false
- Whether category-axis orientation was explicitly supplied by the source chart.
- titleTopPadding double? = null
- Whether the title should overlay the plot instead of reserving layout space.
- legendFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Top padding before the chart title inside the chart canvas.
- axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Optional legend label font style.
- dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Optional axis label font style and axis title fallback style.
- axisTitleFontSize double? = null
- Optional data label font style.
- axisTitleFontFamily string? = null
- Optional axis title font size.
- axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Optional axis title font family.
- horizontalAxisDisplayUnitDivisor double? = null
- Optional axis title font style.
- horizontalAxisDisplayUnitLabel string? = null
- Optional divisor applied to horizontal value-axis labels.
- verticalAxisDisplayUnitDivisor double? = null
- Optional display-unit label shown for horizontal value axes.
- verticalAxisDisplayUnitLabel string? = null
- Optional divisor applied to vertical value-axis labels.
- horizontalAxisMinimum double? = null
- Optional display-unit label shown for vertical value axes.
- horizontalAxisMaximum double? = null
- Optional minimum for horizontal value axes.
- horizontalAxisMajorUnit double? = null
- Optional maximum for horizontal value axes.
- horizontalAxisMinorUnit double? = null
- Optional major tick/grid unit for horizontal value axes.
- verticalAxisMinimum double? = null
- Optional minor tick/grid unit for horizontal value axes.
- verticalAxisMaximum double? = null
- Optional minimum for vertical value axes.
- verticalAxisMajorUnit double? = null
- Optional maximum for vertical value axes.
- verticalAxisMinorUnit double? = null
- Optional major tick/grid unit for vertical value axes.
- horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional minor tick/grid unit for vertical value axes.
- verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional major tick mark placement for the horizontal axis.
- horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional major tick mark placement for the vertical axis.
- verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional minor tick mark placement for the horizontal axis.
- categoryAxisNumberFormat string? = null
- Optional minor tick mark placement for the vertical axis.
- categoryAxisOrientationSpecified bool = false
- Optional numeric format for numeric category-axis labels.
- dataLabelSeriesIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null
- Optional zero-based series indexes that should render data labels.
- dataLabelPointIndexes System.Collections.Generic.IReadOnlyDictionary<int, System.Collections.Generic.IReadOnlyCollection<int>>? = null
- 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 zero-based point indexes that should suppress data labels per series.
- hiddenCategoryLegendIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null
- 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
- Whether a legend should be drawn over the plot instead of reserving layout space.
- seriesLegendWidthRatio double? = null
- Maximum chart-width ratio reserved for series legends.
- categoryLegendWidthRatio double? = null
- Maximum chart-width ratio reserved for category legends such as pie slices.
- legendRowHeight double? = null
- Legend row height.
- legendSwatchSize double? = null
- Legend color swatch size.
- legendTextGap double? = null
- Gap between a legend swatch and its label.
- legendFontSize double? = null
- Legend label font size.
- legendFontFamily string? = null
- Optional legend label font family.
- axisLabelFontSize double? = null
- Axis label font size.
- axisTextFontFamily string? = null
- Optional axis label font family and axis title fallback family.
- categoryAxisLabelWidth double? = null
- Maximum category-axis label width.
- radarCategoryLabelWidth double? = null
- Maximum radar category label width.
- maximumCategoryAxisLabels int? = null
- Maximum number of category-axis labels to render on cartesian charts.
- maximumHorizontalCategoryAxisLabels int? = null
- Maximum number of category-axis labels to render on horizontal bar charts.
- maximumRadarCategoryLabels int? = null
- Maximum number of category labels to render on radar charts.
- preventLabelOverlap bool = true
- Whether axis/category label stride should increase automatically to avoid obvious label overlap.
- showLegend bool = true
- Whether series or category legends should be rendered.
- legendPosition OfficeIMO.Drawing.OfficeChartLegendPosition = Right
- Preferred legend placement when legends are rendered.
- showDataLabels bool = false
- Whether point data labels should be rendered when supported by a chart family.
- showDataLabelValues bool = false
- Whether point data labels should include values.
- showDataLabelPercentages bool = false
- Whether point data labels should include percentages.
- showDataLabelCategoryNames bool = false
- Whether point data labels should include category names.
- showDataLabelSeriesNames bool = false
- Whether point data labels should include series names.
- dataLabelSeparator string? = null
- Separator used between enabled data label parts.
- dataLabelFontSize double? = null
- Data label font size.
- dataLabelFontFamily string? = null
- Optional data label font family.
- dataLabelPosition OfficeIMO.Drawing.OfficeChartDataLabelPosition = BestFit
- Preferred data label position when labels are rendered.
- dataLabelNumberFormat string? = null
- Optional numeric format for data-label values.
- showMarkers bool = true
- Whether point markers should be rendered for marker-capable chart families.
- axisNumberFormat string? = null
- Optional numeric format for value-axis labels.
- categoryAxisTitle string? = null
- Optional category or horizontal axis title.
- valueAxisTitle string? = null
- Optional value or vertical axis title.
- horizontalAxisNumberFormat string? = null
- Optional numeric format for horizontal value-axis labels.
- verticalAxisNumberFormat string? = null
- Optional numeric format for vertical value-axis labels.
- connectScatterPoints bool = true
- Whether scatter points should be connected by series lines.
- fillRadarSeries bool = true
- Whether radar series polygons should be filled.
- showCategoryAxis bool = true
- Whether the category or horizontal axis should be rendered.
- showValueAxis bool = true
- Whether the value or vertical axis should be rendered.
- showCategoryAxisLine bool = true
- Whether the category or horizontal axis line should be rendered.
- showValueAxisLine bool = true
- Whether the value or vertical axis line should be rendered.
- showCategoryAxisLabels bool = true
- Whether category or horizontal tick labels should be rendered.
- showValueAxisLabels bool = true
- Whether value or vertical tick labels should be rendered.
- horizontalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo
- Preferred tick-label side for the physical horizontal axis.
- verticalAxisTickLabelPosition OfficeIMO.Drawing.OfficeChartAxisTickLabelPosition = NextTo
- Preferred tick-label side for the physical vertical axis.
- horizontalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero
- Physical crossing side for the horizontal axis.
- verticalAxisCrossingPosition OfficeIMO.Drawing.OfficeChartAxisCrossingPosition = AutoZero
- Physical crossing side for the vertical axis.
- reverseCategoryAxis bool = false
- Whether category-axis slots should be rendered in reverse order.
- overlayTitle bool = false
- Whether category-axis orientation was explicitly supplied by the source chart.
- titleTopPadding double? = null
- Whether the title should overlay the plot instead of reserving layout space.
- legendFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Top padding before the chart title inside the chart canvas.
- axisTextFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Optional legend label font style.
- dataLabelFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Optional axis label font style and axis title fallback style.
- axisTitleFontSize double? = null
- Optional data label font style.
- axisTitleFontFamily string? = null
- Optional axis title font size.
- axisTitleFontStyle OfficeIMO.Drawing.OfficeFontStyle? = null
- Optional axis title font family.
- horizontalAxisDisplayUnitDivisor double? = null
- Optional axis title font style.
- horizontalAxisDisplayUnitLabel string? = null
- Optional divisor applied to horizontal value-axis labels.
- verticalAxisDisplayUnitDivisor double? = null
- Optional display-unit label shown for horizontal value axes.
- verticalAxisDisplayUnitLabel string? = null
- Optional divisor applied to vertical value-axis labels.
- horizontalAxisMinimum double? = null
- Optional display-unit label shown for vertical value axes.
- horizontalAxisMaximum double? = null
- Optional minimum for horizontal value axes.
- horizontalAxisMajorUnit double? = null
- Optional maximum for horizontal value axes.
- horizontalAxisMinorUnit double? = null
- Optional major tick/grid unit for horizontal value axes.
- verticalAxisMinimum double? = null
- Optional minor tick/grid unit for horizontal value axes.
- verticalAxisMaximum double? = null
- Optional minimum for vertical value axes.
- verticalAxisMajorUnit double? = null
- Optional maximum for vertical value axes.
- verticalAxisMinorUnit double? = null
- Optional major tick/grid unit for vertical value axes.
- horizontalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional minor tick/grid unit for vertical value axes.
- verticalAxisMajorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional major tick mark placement for the horizontal axis.
- horizontalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional major tick mark placement for the vertical axis.
- verticalAxisMinorTickMark OfficeIMO.Drawing.OfficeChartAxisTickMark = None
- Optional minor tick mark placement for the horizontal axis.
- categoryAxisNumberFormat string? = null
- Optional minor tick mark placement for the vertical axis.
- categoryAxisOrientationSpecified bool = false
- Optional numeric format for numeric category-axis labels.
- dataLabelSeriesIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null
- Optional zero-based series indexes that should render data labels.
- dataLabelPointIndexes System.Collections.Generic.IReadOnlyDictionary<int, System.Collections.Generic.IReadOnlyCollection<int>>? = null
- 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 zero-based point indexes that should suppress data labels per series.
- hiddenCategoryLegendIndexes System.Collections.Generic.IReadOnlyCollection<int>? = null
- 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
- The gap between clusters as a percentage of one bar's width, from 0 to 500.
- overlapPercent int
- The overlap of clustered bars, from -100 to 100.
Returns
OfficeChartLayoutpublic 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
Returns
OfficeChartLayoutpublic OfficeChartLayout WithDataLabelLeaderLines(bool show) #Returns a layout copy with the requested outside radial leader-line setting.
Parameters
- show bool
Returns
OfficeChartLayoutpublic 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
- Whether to draw high-low lines.
- color OfficeIMO.OfficeColor? = null
- The line colour, or null for the chart text colour.
- width double? = null
- The line width in points, greater than zero and at most 1584, or null for 0.75 points.
Returns
OfficeChartLayoutpublic OfficeChartLayout WithSecondaryValueAxis(OfficeChartValueAxisLayout? axis) #Returns a layout copy with an independent secondary value-axis scale and format.
Parameters
- axis OfficeIMO.Drawing.OfficeChartValueAxisLayout?
Returns
OfficeChartLayoutInherited Methods
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 LegendTextGap { get; } #Gap between a legend swatch and its label.
public string? LegendFontFamily { get; } #Optional legend label font family.
public OfficeFontStyle? LegendFontStyle { get; } #Optional legend label font style.
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 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 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 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.
64