xlsgen > overview > Chart custom properties

Custom properties expose those properties that are specific to a given chart type.

Custom properties are available in two ways :

• for the current chart, thanks to the CustomProperties property of the chart object.
• whenever a combinatorial chart is used, for instance when you take one series, and switch the bars to lines, the CustomProperties property is available from that series object to let you customize it further.

Here are the meaning of custom properties, categorized.

• all bar/cylinder/cone/pyramid charts
  • HorizontalBars
• all stackable charts (bars, lines, areas)
  • Stacked
  • StackedAndStretched
• all charts
  • SeriesOverlap
  • SeriesGap
  • ChartPositionOffsetTop
  • ChartPositionOffsetLeft
  • ChartPositionOffsetBottom
  • ChartPositionOffsetRight
  • ChartInterpolateEmptyCells
  • ChartResizeOption
  • ChartPrintObject
  • ChartLocked
  • ChartOnlyShowVisibleCells
  • ChartStyle (XLSX/XLSB files)
• all stand-alone charts
  • ChartResizeWithWindow
• all bar pie line charts
  • VaryColorBySlice
• all pie charts
  • PieStartAngle
  • PieShowLeaderLines
  • PieDoughnutDistance
  • PieExplodedSliceDistance
  • PieBuddyOptions
  • PieDataLabelLineOptions
• all line charts
  • DropLines
  • HighLowLines
  • UpDownBars
  • LineAutoMarkers
  • LineAutoSmooth
• all bubble charts
  • BubbleShowNegatives
  • BubbleRepresentsArea
  • BubbleScalePercent
• all bar charts
  • BarLinesBetweenDataElements barlines
• all surface/contour charts
  • SurfaceWireframe
• Outlier chart
  • OutlierPercent
  • OutlierAbsoluteMaximum
  • OutlierAbsoluteMinimum
• LowPass filter chart
  • LowPassFilterAlpha
• Outlier and low pass filter charts
  • ReplaceSeries
• Waterfall chart
  • WaterfallConnectorLines
• Histogram chart
  • HistogramBinWidth
  • HistogramBinCount
  • HistogramOverflowValue
  • HistogramUnderflowValue
  • HistogramByCategory