Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class ChartImpl

    Show / Hide Table of Contents

    Class ChartImpl

    Represents a chart sheet in the workbook.

    Inheritance
    System.Object
    CommonObject
    WorksheetBaseImpl
    ChartImpl
    Implements
    System.IDisposable
    IChart
    ITabSheet
    IParentApplication
    ISerializableNamedObject
    INamedObject
    IParseable
    ICloneParent
    Inherited Members
    WorksheetBaseImpl.DEF_MAX_PASSWORDLEN
    WorksheetBaseImpl.DEF_MIN_COLUMN_INDEX
    WorksheetBaseImpl.DEF_MIN_ROW_INDEX
    WorksheetBaseImpl.DEF_DEFAULT_TAB_COLOR
    WorksheetBaseImpl.DEF_MAX_ROW_ONE_INDEX
    WorksheetBaseImpl.DEF_MAX_COLUMN_ONE_INDEX
    WorksheetBaseImpl.m_book
    WorksheetBaseImpl.m_iMsoStartIndex
    WorksheetBaseImpl.m_parseOptions
    WorksheetBaseImpl.m_arrRecords
    WorksheetBaseImpl.m_rangeProtectionRecord
    WorksheetBaseImpl.m_strCodeName
    WorksheetBaseImpl.m_iFirstColumn
    WorksheetBaseImpl.m_iLastColumn
    WorksheetBaseImpl.m_iFirstRow
    WorksheetBaseImpl.m_iLastRow
    WorksheetBaseImpl.KeepRecord
    WorksheetBaseImpl.m_dataHolder
    WorksheetBaseImpl.m_isCustomHeight
    WorksheetBaseImpl.m_errorIndicators
    WorksheetBaseImpl.FindParents()
    WorksheetBaseImpl.OnNameChanged(ValueChangedEventArgs)
    WorksheetBaseImpl.RaiseNameChangedEvent(ValueChangedEventArgs)
    WorksheetBaseImpl.SetChanged()
    WorksheetBaseImpl.ClearAll(ExcelWorksheetCopyFlags)
    WorksheetBaseImpl.Activate()
    WorksheetBaseImpl.Select()
    WorksheetBaseImpl.Unselect()
    WorksheetBaseImpl.Unselect(Boolean)
    WorksheetBaseImpl.Protect(String)
    WorksheetBaseImpl.Protect(String, ExcelSheetProtection)
    WorksheetBaseImpl.Unprotect()
    WorksheetBaseImpl.Unprotect(String)
    WorksheetBaseImpl.OnRealIndexChanged(Int32)
    WorksheetBaseImpl.SelectTab()
    WorksheetBaseImpl.UpdateExtendedFormatIndex(Dictionary<Int32, Int32>)
    WorksheetBaseImpl.Clone(Object, Boolean)
    WorksheetBaseImpl.CloneShapes(WorksheetBaseImpl)
    WorksheetBaseImpl.UpdateStyleIndexes(Int32[])
    WorksheetBaseImpl.Parse(BiffReader, ExcelParseOptions, Boolean, Dictionary<Int32, Int32>, IDecryptor)
    WorksheetBaseImpl.PrepareProtection()
    WorksheetBaseImpl.ParseNextRecord(BiffReader, Int32, ExcelParseOptions, Boolean, Dictionary<Int32, Int32>, IDecryptor)
    WorksheetBaseImpl.ParseProtect(ProtectRecord)
    WorksheetBaseImpl.ParsePassword(PasswordRecord)
    WorksheetBaseImpl.ParseObjectProtect(ObjectProtectRecord)
    WorksheetBaseImpl.ParseScenProtect(ScenProtectRecord)
    WorksheetBaseImpl.PrepareVariables(ExcelParseOptions, Boolean)
    WorksheetBaseImpl.ParseWindowTwo(WindowTwoRecord)
    WorksheetBaseImpl.ParseRecord(BiffRecordRaw, Boolean, Dictionary<Int32, Int32>)
    WorksheetBaseImpl.ParseDimensions(DimensionsRecord)
    WorksheetBaseImpl.ParseWindowZoom(WindowZoomRecord)
    WorksheetBaseImpl.ParseSheetLayout(SheetLayoutRecord)
    WorksheetBaseImpl.SerializeMsoDrawings(OffsetArrayList)
    WorksheetBaseImpl.SerializeProtection(OffsetArrayList, Boolean)
    WorksheetBaseImpl.SerializeSheetProtection(OffsetArrayList)
    WorksheetBaseImpl.SerializeHeaderFooterPictures(OffsetArrayList)
    WorksheetBaseImpl.SerializeWindowTwo(OffsetArrayList)
    WorksheetBaseImpl.SerializePageLayoutView(OffsetArrayList)
    WorksheetBaseImpl.SerializeMacrosSupport(OffsetArrayList)
    WorksheetBaseImpl.SerializeWindowZoom(OffsetArrayList)
    WorksheetBaseImpl.SerializeSheetLayout(OffsetArrayList)
    WorksheetBaseImpl.GetPasswordHash(String)
    WorksheetBaseImpl.Round(Int32, Int32)
    WorksheetBaseImpl.add_NameChanged(ValueChangedEventHandler)
    WorksheetBaseImpl.remove_NameChanged(ValueChangedEventHandler)
    WorksheetBaseImpl.ParseData()
    WorksheetBaseImpl.ExtractMSODrawing(Int32, ExcelParseOptions)
    WorksheetBaseImpl.CombineArrays(Int32, List<Byte[]>)
    WorksheetBaseImpl.CopyFrom(WorksheetBaseImpl, Dictionary<String, String>, Dictionary<String, String>, Dictionary<Int32, Int32>, ExcelWorksheetCopyFlags, Dictionary<Int32, Int32>)
    WorksheetBaseImpl.CopyHeaderFooterImages(WorksheetBaseImpl, Dictionary<String, String>, IDictionary)
    WorksheetBaseImpl.CopyShapes(WorksheetBaseImpl, Dictionary<String, String>, Dictionary<Int32, Int32>)
    WorksheetBaseImpl.CopyOptions(WorksheetBaseImpl)
    WorksheetBaseImpl.Dispose()
    WorksheetBaseImpl.CreateSalt(Int32)
    WorksheetBaseImpl.Name
    WorksheetBaseImpl.IsSaved
    WorksheetBaseImpl.InnerComments
    WorksheetBaseImpl.InnerPictures
    WorksheetBaseImpl.InnerCharts
    WorksheetBaseImpl.InnerShapes
    WorksheetBaseImpl.Shapes
    WorksheetBaseImpl.InnerShapesBase
    WorksheetBaseImpl.HeaderFooterShapes
    WorksheetBaseImpl.InnerHeaderFooterShapes
    WorksheetBaseImpl.Comments
    WorksheetBaseImpl.Charts
    WorksheetBaseImpl.Pictures
    WorksheetBaseImpl.CodeName
    WorksheetBaseImpl.WindowTwo
    WorksheetBaseImpl.ProtectContents
    WorksheetBaseImpl.IsPasswordProtected
    WorksheetBaseImpl.IsParsed
    WorksheetBaseImpl.IsParsing
    WorksheetBaseImpl.IsSkipParsing
    WorksheetBaseImpl.IsSupported
    WorksheetBaseImpl.ParentWorkbook
    WorksheetBaseImpl.FirstRow
    WorksheetBaseImpl.FirstColumn
    WorksheetBaseImpl.LastRow
    WorksheetBaseImpl.LastColumn
    WorksheetBaseImpl.Zoom
    WorksheetBaseImpl.TabColorObject
    WorksheetBaseImpl.TabColorRGB
    WorksheetBaseImpl.GridLineColor
    WorksheetBaseImpl.DefaultGridlineColor
    WorksheetBaseImpl.Workbook
    WorksheetBaseImpl.IsRightToLeft
    WorksheetBaseImpl.IsSelected
    WorksheetBaseImpl.Index
    WorksheetBaseImpl.InnerProtection
    WorksheetBaseImpl.UnprotectedOptions
    WorksheetBaseImpl.Visibility
    WorksheetBaseImpl.TopVisibleRow
    WorksheetBaseImpl.LeftVisibleColumn
    WorksheetBaseImpl.UnknownVmlShapes
    WorksheetBaseImpl.TypedTextBoxes
    WorksheetBaseImpl.TextBoxes
    WorksheetBaseImpl.TypedCheckBoxes
    WorksheetBaseImpl.TypedOptionButtons
    WorksheetBaseImpl.TypedComboBoxes
    WorksheetBaseImpl.InnerCheckBoxes
    WorksheetBaseImpl.CheckBoxes
    WorksheetBaseImpl.OptionButtons
    WorksheetBaseImpl.ComboBoxes
    WorksheetBaseImpl.HasPictures
    WorksheetBaseImpl.HasCharts
    WorksheetBaseImpl.HasVmlShapes
    WorksheetBaseImpl.VmlShapesCount
    WorksheetBaseImpl.ContainsProtection
    WorksheetBaseImpl.SheetProtection
    WorksheetBaseImpl.IsTransitionEvaluation
    WorksheetBaseImpl.ParseOnDemand
    WorksheetBaseImpl.AlgorithmName
    WorksheetBaseImpl.HashValue
    WorksheetBaseImpl.SaltValue
    WorksheetBaseImpl.SpinCount
    WorksheetBaseImpl.RealIndex
    WorksheetBaseImpl.ITabSheet.TabIndex
    WorksheetBaseImpl.NameChanged
    CommonObject.m_bIsDisposed
    CommonObject.Finalize()
    CommonObject.FindParent(Type)
    CommonObject.FindParent(Type, Boolean)
    CommonObject.FindParent(Object, Type)
    CommonObject.FindParent(Object, Type, Boolean)
    CommonObject.FindParents(Type[])
    CommonObject.FindParent(Type[])
    CommonObject.SetParent(Object)
    CommonObject.CheckDisposed()
    CommonObject.AddReference()
    CommonObject.ReleaseReference()
    CommonObject.OnDispose()
    CommonObject.Application
    CommonObject.Parent
    CommonObject.AppImplementation
    CommonObject.ReferenceCount
    Namespace: Syncfusion.XlsIO.Implementation.Charts
    Assembly: Syncfusion.XlsIO.Portable.dll
    Syntax
    public class ChartImpl : WorksheetBaseImpl, IDisposable, IChart, ITabSheet, IParentApplication, ISerializableNamedObject, INamedObject, IParseable, ICloneParent

    Constructors

    ChartImpl(IApplication, Object)

    Initializes a new instance of ChartImpl class.

    Declaration
    public ChartImpl(IApplication application, object parent)
    Parameters
    Type Name Description
    IApplication application

    Application object for the chart.

    System.Object parent

    Parent object for the chart.

    ChartImpl(IApplication, Object, BiffReader, ExcelParseOptions, Boolean, Dictionary<Int32, Int32>, IDecryptor)

    Initializes a new instance of ChartImpl class from biff reader and specified decryptor.

    Declaration
    public ChartImpl(IApplication application, object parent, BiffReader reader, ExcelParseOptions options, bool bSkipParsing, Dictionary<int, int> hashXFormatIndexes, IDecryptor decryptor)
    Parameters
    Type Name Description
    IApplication application

    Application object for the chart.

    System.Object parent

    Parent object for the chart.

    BiffReader reader

    BiffReader to extract data from.

    ExcelParseOptions options

    Parse options.

    System.Boolean bSkipParsing

    Indicates whether to skip parsing.

    System.Collections.Generic.Dictionary<System.Int32, System.Int32> hashXFormatIndexes

    Dictionary with new extended format indexes for ignore styles mode.

    IDecryptor decryptor

    Object used to decrypt encrypted records.

    ChartImpl(IApplication, Object, IList, ref Int32, ExcelParseOptions)

    Initializes a new instance of ChartImpl class from the array of BiffRecords.

    Declaration
    public ChartImpl(IApplication application, object parent, IList data, ref int iPos, ExcelParseOptions options)
    Parameters
    Type Name Description
    IApplication application

    Application object for the chart.

    System.Object parent

    Parent object for the chart.

    System.Collections.IList data

    Array of BiffRecords with chart's data.

    System.Int32 iPos

    Position of the first chart's record.

    ExcelParseOptions options

    Parse options.

    Fields

    CHARTS_100

    Represent 100% charts.

    Declaration
    public static ExcelChartType[] CHARTS_100
    Field Value
    Type Description
    ExcelChartType[]
    Remarks

    Here each value in a series is shown as a portion of 100%.

    CHARTS_BUBBLE

    Represent bubble charts.

    Declaration
    public static ExcelChartType[] CHARTS_BUBBLE
    Field Value
    Type Description
    ExcelChartType[]
    Remarks

    These are variation of scatter charts in which the data points are replaced with bubbles.

    CHARTS_CLUSTERED

    Represent clustered charts.

    Declaration
    public static ExcelChartType[] CHARTS_CLUSTERED
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_EXPLODED

    Represent exploded charts.

    Declaration
    public static ExcelChartType[] CHARTS_EXPLODED
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_LINE

    Represent line charts.

    Declaration
    public static ExcelChartType[] CHARTS_LINE
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_PERSPECTIVE

    Represent charts with perspective.

    Declaration
    public static ExcelChartType[] CHARTS_PERSPECTIVE
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_SCATTER

    Represent scatter charts.

    Declaration
    public static ExcelChartType[] CHARTS_SCATTER
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_SMOOTHED_LINE

    Represent charts with smoothed lines.

    Declaration
    public static ExcelChartType[] CHARTS_SMOOTHED_LINE
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_STOCK

    Represent stock charts.

    Declaration
    public static ExcelChartType[] CHARTS_STOCK
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_VARYCOLOR

    Represent charts that need different color for each value.

    Declaration
    public static ExcelChartType[] CHARTS_VARYCOLOR
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS_WITH_PLOT_AREA

    Represent charts with plot area (by default).

    Declaration
    public static ExcelChartType[] CHARTS_WITH_PLOT_AREA
    Field Value
    Type Description
    ExcelChartType[]

    CHARTS3D

    Represent 3D charts.

    Declaration
    public static ExcelChartType[] CHARTS3D
    Field Value
    Type Description
    ExcelChartType[]

    DEF_CHANGE_INTIMATE

    Represent chart types that can change as intimate types.

    Declaration
    public static ExcelChartType[] DEF_CHANGE_INTIMATE
    Field Value
    Type Description
    ExcelChartType[]

    DEF_CHANGE_SERIE

    Represent types of charts that allow serie change.

    Declaration
    public static ExcelChartType[] DEF_CHANGE_SERIE
    Field Value
    Type Description
    ExcelChartType[]

    DEF_CHART_PERCENTAGE

    Represent charts with percentage data labels.

    Declaration
    public static ExcelChartType[] DEF_CHART_PERCENTAGE
    Field Value
    Type Description
    ExcelChartType[]

    DEF_COMBINATION_CHART

    Represent chart types that are combination of two different charts.

    Declaration
    public static ExcelChartType[] DEF_COMBINATION_CHART
    Field Value
    Type Description
    ExcelChartType[]

    DEF_DONT_NEED_PLOT

    Represent chart start types that does not need plot or walls.

    Declaration
    public static ExcelChartType[] DEF_DONT_NEED_PLOT
    Field Value
    Type Description
    ExcelChartType[]

    DEF_FIRST_SERIE_NAME

    Represent default name for the first series of the chart.

    Declaration
    public const string DEF_FIRST_SERIE_NAME = "Serie1"
    Field Value
    Type Description
    System.String

    DEF_LEGEND_NEED_DATA_POINT

    Represent start types of chart that support data point.

    Declaration
    public static string[] DEF_LEGEND_NEED_DATA_POINT
    Field Value
    Type Description
    System.String[]

    DEF_NEED_SECONDARY_AXIS

    Represent serie types that must be in secondary axis.

    Declaration
    public static ExcelChartType[] DEF_NEED_SECONDARY_AXIS
    Field Value
    Type Description
    ExcelChartType[]

    DEF_NEED_VIEW_3D

    Represent pivot chart types which need view tag to be rendered.

    Declaration
    public static ExcelChartType[] DEF_NEED_VIEW_3D
    Field Value
    Type Description
    ExcelChartType[]

    DEF_NOT_3D

    Represent types of charts that are not 3D.

    Declaration
    public static ExcelChartType[] DEF_NOT_3D
    Field Value
    Type Description
    ExcelChartType[]

    DEF_NOT_SUPPORT_GRIDLINES

    Represent serie types that does not support gridlines.

    Declaration
    public static ExcelChartType[] DEF_NOT_SUPPORT_GRIDLINES
    Field Value
    Type Description
    ExcelChartType[]

    DEF_PRIORITY_START_TYPES

    Represents array of start serie types sorted by drawing order.

    Declaration
    public static string[] DEF_PRIORITY_START_TYPES
    Field Value
    Type Description
    System.String[]

    DEF_SI_BUBBLE

    Si bubble index.

    Declaration
    public const int DEF_SI_BUBBLE = 3
    Field Value
    Type Description
    System.Int32

    DEF_SI_CATEGORY

    Si category index.

    Declaration
    public const int DEF_SI_CATEGORY = 2
    Field Value
    Type Description
    System.Int32

    DEF_SI_VALUE

    Si value index.

    Declaration
    public const int DEF_SI_VALUE = 1
    Field Value
    Type Description
    System.Int32

    DEF_SPECIAL_DATA_LABELS

    Represent the charts with data labels stored in different ways.

    Declaration
    public static ExcelChartType[] DEF_SPECIAL_DATA_LABELS
    Field Value
    Type Description
    ExcelChartType[]

    DEF_SUPPORT_DATA_TABLE

    Represent the charts that support data table.

    Declaration
    public static string[] DEF_SUPPORT_DATA_TABLE
    Field Value
    Type Description
    System.String[]

    DEF_SUPPORT_ERROR_BARS

    Represent the charts that support error bars.

    Declaration
    public static string[] DEF_SUPPORT_ERROR_BARS
    Field Value
    Type Description
    System.String[]

    DEF_SUPPORT_SERIES_AXIS

    Represent the charts that support series axis.

    Declaration
    public static ExcelChartType[] DEF_SUPPORT_SERIES_AXIS
    Field Value
    Type Description
    ExcelChartType[]

    DEF_SUPPORT_TREND_LINES

    Represent the charts that support trendlines.

    Declaration
    public static ExcelChartType[] DEF_SUPPORT_TREND_LINES
    Field Value
    Type Description
    ExcelChartType[]

    DEF_UNSUPPORT_PIVOT_CHART

    Represent the charts that do not support pivot charts.

    Declaration
    public static ExcelChartType[] DEF_UNSUPPORT_PIVOT_CHART
    Field Value
    Type Description
    ExcelChartType[]

    DEF_WALLS_OR_FLOOR_TYPES

    Represent the charts that contain walls or floor.

    Declaration
    public static ExcelChartType[] DEF_WALLS_OR_FLOOR_TYPES
    Field Value
    Type Description
    ExcelChartType[]

    DEFAULT_CHART_TYPE

    Represents the default chart type.

    Declaration
    public const ExcelChartType DEFAULT_CHART_TYPE
    Field Value
    Type Description
    ExcelChartType

    LEGEND_VERTICAL

    Represent the legend types that are displayed vertically.

    Declaration
    public static ExcelLegendPosition[] LEGEND_VERTICAL
    Field Value
    Type Description
    ExcelLegendPosition[]

    NO_CATEGORY_AXIS

    Represent the charts that can be without category axis.

    Declaration
    public static ExcelChartType[] NO_CATEGORY_AXIS
    Field Value
    Type Description
    ExcelChartType[]

    PREFIX_3D

    Represents the prefix for 3D charts.

    Declaration
    public const string PREFIX_3D = "_3D"
    Field Value
    Type Description
    System.String

    PREFIX_BAR

    Represents the prefix for bar charts.

    Declaration
    public const string PREFIX_BAR = "_Bar"
    Field Value
    Type Description
    System.String

    PREFIX_CLUSTERED

    Represents the prefix for clustered charts.

    Declaration
    public const string PREFIX_CLUSTERED = "_Clustered"
    Field Value
    Type Description
    System.String

    PREFIX_CONTOUR

    Represents the prefix for contour charts.

    Declaration
    public const string PREFIX_CONTOUR = "_Contour"
    Field Value
    Type Description
    System.String

    PREFIX_EXPLODED

    Represents the prefix for exploded charts.

    Declaration
    public const string PREFIX_EXPLODED = "_Exploded"
    Field Value
    Type Description
    System.String

    PREFIX_LINE

    Represents the prefix for line charts.

    Declaration
    public const string PREFIX_LINE = "_Line"
    Field Value
    Type Description
    System.String

    PREFIX_MARKERS

    Represents the prefix for charts with markers.

    Declaration
    public const string PREFIX_MARKERS = "_Markers"
    Field Value
    Type Description
    System.String

    PREFIX_NOCOLOR

    Represents the prefix for charts with no color.

    Declaration
    public const string PREFIX_NOCOLOR = "_NoColor"
    Field Value
    Type Description
    System.String

    PREFIX_SHOW_PERCENT

    Represents the prefix for 100% charts.

    Declaration
    public const string PREFIX_SHOW_PERCENT = "_100"
    Field Value
    Type Description
    System.String

    PREFIX_SMOOTHEDLINE

    Represents the prefix for charts with smoothed lines.

    Declaration
    public const string PREFIX_SMOOTHEDLINE = "_SmoothedLine"
    Field Value
    Type Description
    System.String

    PREFIX_STACKED

    Represents the prefix for stacked charts.

    Declaration
    public const string PREFIX_STACKED = "_Stacked"
    Field Value
    Type Description
    System.String

    STACKEDCHARTS

    Represent the stacked charts.

    Declaration
    public static ExcelChartType[] STACKEDCHARTS
    Field Value
    Type Description
    ExcelChartType[]

    START_AREA

    Represents the defined start for area charts.

    Declaration
    public const string START_AREA = "Area"
    Field Value
    Type Description
    System.String

    START_BAR

    Represents the defined start for bar charts.

    Declaration
    public const string START_BAR = "Bar"
    Field Value
    Type Description
    System.String

    START_BUBBLE

    Represents the defined start for bubble charts.

    Declaration
    public const string START_BUBBLE = "Bubble"
    Field Value
    Type Description
    System.String

    START_COLUMN

    Represents the defined start for column charts.

    Declaration
    public const string START_COLUMN = "Column"
    Field Value
    Type Description
    System.String

    START_CONE

    Represents the defined start for cone charts.

    Declaration
    public const string START_CONE = "Cone"
    Field Value
    Type Description
    System.String

    START_CYLINDER

    Represents the defined start for cylinder charts.

    Declaration
    public const string START_CYLINDER = "Cylinder"
    Field Value
    Type Description
    System.String

    START_DOUGHNUT

    Represents the defined start for doughnut charts.

    Declaration
    public const string START_DOUGHNUT = "Doughnut"
    Field Value
    Type Description
    System.String

    START_LINE

    Represents the defined start for line charts.

    Declaration
    public const string START_LINE = "Line"
    Field Value
    Type Description
    System.String

    START_PIE

    Represents the defined start for pie charts.

    Declaration
    public const string START_PIE = "Pie"
    Field Value
    Type Description
    System.String

    START_PYRAMID

    Represents the defined start for pyramid charts.

    Declaration
    public const string START_PYRAMID = "Pyramid"
    Field Value
    Type Description
    System.String

    START_RADAR

    Represents the defined start for radar charts.

    Declaration
    public const string START_RADAR = "Radar"
    Field Value
    Type Description
    System.String

    START_SCATTER

    Represents the defined start for scatter charts.

    Declaration
    public const string START_SCATTER = "Scatter"
    Field Value
    Type Description
    System.String

    START_SURFACE

    Represents the defined start for surface charts.

    Declaration
    public const string START_SURFACE = "Surface"
    Field Value
    Type Description
    System.String

    Properties

    AutoScaling

    True to automatically scale the chart. otherwise False. The RightAngleAxes property must be True.

    Declaration
    public bool AutoScaling { get; set; }
    Property Value
    Type Description
    System.Boolean
    Remarks

    Excel scales a 3-D chart so that it is closer in size to the equivalent 2-D chart when this property is enabled.

    BackWall

    Gets the back wall of the 3D chart. Read-only.

    Declaration
    public IChartWallOrFloor BackWall { get; set; }
    Property Value
    Type Description
    IChartWallOrFloor

    CanChartBubbleLabel

    True if chart has bubble data labels. False otherwise. Read-only.

    Declaration
    public bool CanChartBubbleLabel { get; }
    Property Value
    Type Description
    System.Boolean

    CanChartHaveSeriesLines

    True if chart has series lines. False otherwise. Read-only.

    Declaration
    public bool CanChartHaveSeriesLines { get; }
    Property Value
    Type Description
    System.Boolean

    CanChartPercentageLabel

    True if chart has percentage data labels. False otherwise. Read-only.

    Declaration
    public bool CanChartPercentageLabel { get; }
    Property Value
    Type Description
    System.Boolean

    Categories

    Gets a collection of categories of the chart. Read-only.

    Declaration
    public IChartCategories Categories { get; }
    Property Value
    Type Description
    IChartCategories
    Remarks

    Charts are plotted using X and Y axes. X axes typically have categorical scales. Categories can include string, numeric, and date values.

    CategoryAxisTitle

    Gets or sets the title of the category axis.

    Declaration
    public string CategoryAxisTitle { get; set; }
    Property Value
    Type Description
    System.String

    CategoryFormula

    Represents the category lable reference as range

    Declaration
    public string CategoryFormula { get; set; }
    Property Value
    Type Description
    System.String

    CategoryLabelLevel

    Gets or sets a value referring to the source level for the category labels.

    Declaration
    public ExcelCategoriesLabelLevel CategoryLabelLevel { get; set; }
    Property Value
    Type Description
    ExcelCategoriesLabelLevel

    CategoryLabelValues

    Represents the common category label values.

    Declaration
    public object[] CategoryLabelValues { get; set; }
    Property Value
    Type Description
    System.Object[]

    ChartArea

    Gets the chart area. Read-only.

    Declaration
    public IChartFrameFormat ChartArea { get; }
    Property Value
    Type Description
    IChartFrameFormat

    ChartProperties

    Gets the chart options. Read-only.

    Declaration
    public ChartShtpropsRecord ChartProperties { get; }
    Property Value
    Type Description
    ChartShtpropsRecord

    ChartStartType

    Gets the start serie type of chart. Read-only.

    Declaration
    public string ChartStartType { get; }
    Property Value
    Type Description
    System.String

    ChartTitle

    Gets or sets the title of the chart.

    Declaration
    public string ChartTitle { get; set; }
    Property Value
    Type Description
    System.String

    ChartTitleArea

    Gets the area for chart title. Read-only.

    Declaration
    public IChartTextArea ChartTitleArea { get; }
    Property Value
    Type Description
    IChartTextArea

    ChartTitleFont

    Gets the font used for title display. Read-only.

    Declaration
    public IFont ChartTitleFont { get; }
    Property Value
    Type Description
    IFont

    ChartType

    Gets or sets the ExcelChartType.

    Declaration
    public ExcelChartType ChartType { get; set; }
    Property Value
    Type Description
    ExcelChartType

    DataRange

    Gets or sets the data range for the chart series.

    Declaration
    public IRange DataRange { get; set; }
    Property Value
    Type Description
    IRange

    DataTable

    Gets the data table of the chart. Read-only.

    Declaration
    public IChartDataTable DataTable { get; }
    Property Value
    Type Description
    IChartDataTable

    DefaultLinePattern

    Gets the default line pattern for the chart. Read-only.

    Declaration
    public ExcelChartLinePattern DefaultLinePattern { get; }
    Property Value
    Type Description
    ExcelChartLinePattern

    DefaultProtectionOptions

    Gets default protection options for the worksheet.

    Declaration
    protected override ExcelSheetProtection DefaultProtectionOptions { get; }
    Property Value
    Type Description
    ExcelSheetProtection
    Overrides
    WorksheetBaseImpl.DefaultProtectionOptions

    DefaultTextIndex

    Gets the font index from the default font records. Read-only.

    Declaration
    public int DefaultTextIndex { get; }
    Property Value
    Type Description
    System.Int32

    DepthPercent

    Gets or sets the depth of a 3D chart as a percentage of the chart width (20 - 2000 percent).

    Declaration
    public int DepthPercent { get; set; }
    Property Value
    Type Description
    System.Int32

    DestinationType

    Gets or sets the resulting chart type after type change operation.

    Declaration
    public ExcelChartType DestinationType { get; set; }
    Property Value
    Type Description
    ExcelChartType

    DisplayBlanksAs

    Gets or sets a value indicating how the blank cells are plotted on chart.

    Declaration
    public ExcelChartPlotEmpty DisplayBlanksAs { get; set; }
    Property Value
    Type Description
    ExcelChartPlotEmpty

    Elevation

    Gets or sets the elevation of the 3-D chart view, in degrees (–90 to +90 degrees).

    Declaration
    public int Elevation { get; set; }
    Property Value
    Type Description
    System.Int32
    Remarks

    The chart elevation is the height at which you view the chart, in degrees. The default is 15 for most chart types. The value of this property must be between -90 and 90, except for 3-D bar charts, where it must be between 0 and 44.

    Floor

    Gets the floor of the 3D chart. Read-only.

    Declaration
    public IChartWallOrFloor Floor { get; set; }
    Property Value
    Type Description
    IChartWallOrFloor

    Font

    Gets the font used for axis text display. Read-only.

    Declaration
    public IFont Font { get; }
    Property Value
    Type Description
    IFont

    FormatId

    Gets or sets the format id of the chart.

    Declaration
    public int FormatId { get; set; }
    Property Value
    Type Description
    System.Int32

    GapDepth

    Gets or sets the distance between data series in a 3D chart, as a percentage of marker width ( 0 - 500 ).

    Declaration
    public int GapDepth { get; set; }
    Property Value
    Type Description
    System.Int32

    HasChartArea

    Gets or sets whether the chart has chart area.

    Declaration
    public bool HasChartArea { get; set; }
    Property Value
    Type Description
    System.Boolean

    HasChartTitle

    True if the chart has title. False otherwise. Read-only.

    Declaration
    public bool HasChartTitle { get; }
    Property Value
    Type Description
    System.Boolean

    HasDataTable

    True if the chart has data table. otherwise False.

    Declaration
    public bool HasDataTable { get; set; }
    Property Value
    Type Description
    System.Boolean

    HasFloor

    Gets a value indicating whether chart floor object is created. False otherwise.

    Declaration
    public bool HasFloor { get; }
    Property Value
    Type Description
    System.Boolean

    HasLegend

    True if the chart has a legend object. otherwise False.

    Declaration
    public bool HasLegend { get; set; }
    Property Value
    Type Description
    System.Boolean

    HasPivotSource

    True if the chart has pivot source. False otherwise.

    Declaration
    public bool HasPivotSource { get; }
    Property Value
    Type Description
    System.Boolean

    HasPlotArea

    Gets or sets a boolean value indicating whether the chart has plot area.

    Declaration
    public bool HasPlotArea { get; set; }
    Property Value
    Type Description
    System.Boolean

    HasTitle

    True if the chart has title. False otherwise.

    Declaration
    public bool HasTitle { get; set; }
    Property Value
    Type Description
    System.Boolean

    HasWalls

    True if the chart walls are present. False otherwise. Read-only.

    Declaration
    public bool HasWalls { get; }
    Property Value
    Type Description
    System.Boolean

    Height

    Gets or sets the height of the chart in points (1/72 inch).

    Declaration
    public double Height { get; set; }
    Property Value
    Type Description
    System.Double

    HeightPercent

    Gets or sets the height of a 3D chart as a percentage of the chart width (5 - 500 percent).

    Declaration
    public int HeightPercent { get; set; }
    Property Value
    Type Description
    System.Int32

    InnerChartArea

    Gets the inner chart area. Read-only.

    Declaration
    public ChartFrameFormatImpl InnerChartArea { get; }
    Property Value
    Type Description
    ChartFrameFormatImpl

    InnerPlotArea

    Gets the inner plot area. Read-only.

    Declaration
    public ChartFrameFormatImpl InnerPlotArea { get; }
    Property Value
    Type Description
    ChartFrameFormatImpl

    InnerWorkbook

    Gets the parent workbook. Read-only.

    Declaration
    public WorkbookImpl InnerWorkbook { get; }
    Property Value
    Type Description
    WorkbookImpl

    IsCategoryAxisAvail

    True if chart has a category axis. False otherwise. Read-only.

    Declaration
    public bool IsCategoryAxisAvail { get; }
    Property Value
    Type Description
    System.Boolean

    IsChart_100

    True if chart is 100%. False otherwise. Read-only.

    Declaration
    public bool IsChart_100 { get; }
    Property Value
    Type Description
    System.Boolean
    Remarks

    The chart assumes that the values add up to 100%, so all the columns will occupy the entire area.

    IsChart3D

    True if chart is a 3D- chart. False otherwise. Read-only.

    Declaration
    public bool IsChart3D { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartBar

    True if chart is a bar chart. False otherwise. Read-only.

    Declaration
    public bool IsChartBar { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartBubble

    True if chart is a bubble chart. False otherwise. Read-only.

    Declaration
    public bool IsChartBubble { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartCone

    True if chart is in a conical shape. False otherwise. Read-only.

    Declaration
    public bool IsChartCone { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartCylinder

    True if chart is in a cylinder shape. False otherwise. Read-only.

    Declaration
    public bool IsChartCylinder { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartDoughnut

    True if chart is a doughnut shaped chart. False otherwise. Read-only.

    Declaration
    public bool IsChartDoughnut { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartExploded

    True if chart is in in exploded view. False otherwise. Read-only.

    Declaration
    public bool IsChartExploded { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartFloor

    True if chart has floor. False otherwise. Read-only.

    Declaration
    public bool IsChartFloor { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartLine

    True if chart is a line chart. False otherwise. Read-only.

    Declaration
    public bool IsChartLine { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartPie

    True if chart is a pie chart. False otherwise. Read-only.

    Declaration
    public bool IsChartPie { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartPyramid

    True if chart is in a pyramid shape. False otherwise. Read-only.

    Declaration
    public bool IsChartPyramid { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartRadar

    True if chart is a radar chart. False otherwise. Read-only.

    Declaration
    public bool IsChartRadar { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartScatter

    True if chart is a scatter chart. False otherwise. Read-only.

    Declaration
    public bool IsChartScatter { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartSmoothedLine

    True if chart has smoothed lines. False otherwise. Read-only.

    Declaration
    public bool IsChartSmoothedLine { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartStock

    True if this is a stock chart. False otherwise. Read-only.

    Declaration
    public bool IsChartStock { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartVaryColor

    True if chart should have a different color for each series value. False otherwise. Read-only.

    Declaration
    public bool IsChartVaryColor { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartVolume

    True if chart is a stock chart with volume. False otherwise. Read-only.

    Declaration
    public bool IsChartVolume { get; }
    Property Value
    Type Description
    System.Boolean

    IsChartWalls

    True if chart has walls. False otherwise. Read-only.

    Declaration
    public bool IsChartWalls { get; }
    Property Value
    Type Description
    System.Boolean

    IsClustered

    True if the chart is a clustered chart. False otherwise. Read-only.

    Declaration
    public bool IsClustered { get; }
    Property Value
    Type Description
    System.Boolean

    IsEmbeded

    Gets a value indicating whether chart is embeded into worksheet. False otherwise. Read-only.

    Declaration
    public bool IsEmbeded { get; }
    Property Value
    Type Description
    System.Boolean

    IsManuallyFormatted

    True if the chart is manually formatted. False otherwise.

    Declaration
    public bool IsManuallyFormatted { get; set; }
    Property Value
    Type Description
    System.Boolean

    IsPerspective

    True if chart has perspective. False otherwise. Read-only.

    Declaration
    public bool IsPerspective { get; }
    Property Value
    Type Description
    System.Boolean

    IsPivotChart3D

    Gets a value indicating whether this instance is 3D pivot chart.

    Declaration
    public bool IsPivotChart3D { get; }
    Property Value
    Type Description
    System.Boolean

    true if this instance is 3D pivot chart; false otherwise. Read-only.

    IsSecondaryAxes

    True if at least one of the secondary axes is present. False otherwise. Read-only.

    Declaration
    public bool IsSecondaryAxes { get; set; }
    Property Value
    Type Description
    System.Boolean

    IsSecondaryCategoryAxisAvail

    True if secondary category axis is present. False otherwise. Read-only.

    Declaration
    public bool IsSecondaryCategoryAxisAvail { get; }
    Property Value
    Type Description
    System.Boolean

    IsSecondaryValueAxisAvail

    True if secondary value axis is present. False otherwise. Read-only.

    Declaration
    public bool IsSecondaryValueAxisAvail { get; }
    Property Value
    Type Description
    System.Boolean

    IsSeriesAxisAvail

    True if chart has a series axis. False otherwise. Read-only.

    Declaration
    public bool IsSeriesAxisAvail { get; }
    Property Value
    Type Description
    System.Boolean

    IsSeriesInRows

    True to swap the data in DataRange over the axis. Series data is charted on the Y axis by default.

    Declaration
    public bool IsSeriesInRows { get; set; }
    Property Value
    Type Description
    System.Boolean
    Remarks

    Data being charted on the X axis will move to the Y axis and vice versa.

    IsSeriesLines

    True if the chart has series lines. False otherwise. Read-only.

    Declaration
    public bool IsSeriesLines { get; }
    Property Value
    Type Description
    System.Boolean

    IsSpecialDataLabels

    True if chart needs special data labels serialization. False otherwise. Read-only.

    Declaration
    public bool IsSpecialDataLabels { get; }
    Property Value
    Type Description
    System.Boolean

    IsStacked

    True if chart is stacked. False otherwise. Read-only.

    Declaration
    public bool IsStacked { get; }
    Property Value
    Type Description
    System.Boolean

    IsValueAxisAvail

    True if chart has a value axis. False otherwise. Read-only.

    Declaration
    public bool IsValueAxisAvail { get; }
    Property Value
    Type Description
    System.Boolean

    Legend

    Gets legend in the chart. Read-only.

    Declaration
    public IChartLegend Legend { get; }
    Property Value
    Type Description
    IChartLegend
    Remarks

    This is a key that identifies patterns, colors or symbols associated with the markers of a chart data series. It shows data series name corresponding to each data marker.

    Loading

    Gets the parsing status of chart. Read-only.

    Declaration
    public bool Loading { get; }
    Property Value
    Type Description
    System.Boolean

    NeedDataFormat

    True if chart needs data format to be saved. False otherwise. Read-only.

    Declaration
    public bool NeedDataFormat { get; }
    Property Value
    Type Description
    System.Boolean

    NeedDropBar

    True if chart needs drop bars to be saved. False otherwise. Read-only.

    Declaration
    public bool NeedDropBar { get; }
    Property Value
    Type Description
    System.Boolean

    NeedMarkerFormat

    True if chart needs marker format to be saved. Read-only.

    Declaration
    public bool NeedMarkerFormat { get; }
    Property Value
    Type Description
    System.Boolean

    NoPlotArea

    True if chart has no plot area. False otherwise. Read-only.

    Declaration
    public bool NoPlotArea { get; }
    Property Value
    Type Description
    System.Boolean

    PageSetup

    Gets the page setup for the chart. Read-only.

    Declaration
    public IChartPageSetup PageSetup { get; }
    Property Value
    Type Description
    IChartPageSetup

    PageSetupBase

    Page setup for the chart. Read-only.

    Declaration
    public override PageSetupBaseImpl PageSetupBase { get; }
    Property Value
    Type Description
    PageSetupBaseImpl
    Overrides
    WorksheetBaseImpl.PageSetupBase

    Perspective

    Gets or sets the perspective for the 3D chart view (0 to 100).

    Declaration
    public int Perspective { get; set; }
    Property Value
    Type Description
    System.Int32
    Remarks

    This property is ignored if the RightAngleAxes property is True.

    PivotChartType

    Gets or sets the type of the pivot chart.

    Declaration
    public ExcelChartType PivotChartType { get; set; }
    Property Value
    Type Description
    ExcelChartType

    The type of the pivot chart.

    PivotFormatsStream

    Gets or sets pivot formats stream.

    Declaration
    public Stream PivotFormatsStream { get; set; }
    Property Value
    Type Description
    System.IO.Stream

    PivotSource

    Gets or sets the pivot source.

    Declaration
    public IPivotTable PivotSource { get; set; }
    Property Value
    Type Description
    IPivotTable

    The pivot source.

    PlotArea

    Gets the plot area where the chart data is plotted. Read-only.

    Declaration
    public IChartFrameFormat PlotArea { get; set; }
    Property Value
    Type Description
    IChartFrameFormat
    Remarks

    The plot area on a 2-D chart contains the data markers, grid lines, data labels, trend lines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls and floor. The plot area is surrounded by the chart area.

    PlotAreaLayout

    Gets the plot area layout record. Read-only.

    Declaration
    public ChartPlotAreaLayoutRecord PlotAreaLayout { get; }
    Property Value
    Type Description
    ChartPlotAreaLayoutRecord

    PlotVisibleOnly

    True if only visible cells are plotted. False if both visible and hidden cells are plotted.

    Declaration
    public bool PlotVisibleOnly { get; set; }
    Property Value
    Type Description
    System.Boolean

    PreservedBandFormats

    Gets or sets preserved band formats for surface chart.

    Declaration
    public Stream PreservedBandFormats { get; set; }
    Property Value
    Type Description
    System.IO.Stream

    PreservedPivotSource

    Gets or sets name of the preserved pivot source stream.

    Declaration
    public string PreservedPivotSource { get; set; }
    Property Value
    Type Description
    System.String

    PrimaryCategoryAxis

    Gets the primary category axis of the chart. Read-only.

    Declaration
    public IChartCategoryAxis PrimaryCategoryAxis { get; }
    Property Value
    Type Description
    IChartCategoryAxis
    Remarks

    Charts are plotted using X and Y axes. The Y axes typically have numerical scales, whereas the X axes typically have categorical scales. Some charts, for example, have axes, and others, like PieChart don't. Most charts have horizontal axis of type PrimaryCategoryAxis and vertical axis of type PrimaryValueAxis but some, like BarChart, have the opposite. PrimaryCategoryAxis represents an axis used for categories. Categories can include string, numeric, and date values.

    PrimaryFormats

    Gets chart format collection in primary axis.

    Declaration
    public ChartFormatCollection PrimaryFormats { get; }
    Property Value
    Type Description
    ChartFormatCollection

    PrimaryParentAxis

    Gets the primary parent axis. Read-only.

    Declaration
    public ChartParentAxisImpl PrimaryParentAxis { get; }
    Property Value
    Type Description
    ChartParentAxisImpl

    PrimarySerieAxis

    Gets the primary series axis. Read-only.

    Declaration
    public IChartSeriesAxis PrimarySerieAxis { get; }
    Property Value
    Type Description
    IChartSeriesAxis
    Remarks

    This is the depth axis showing the depth of the third dimension in 3D charts.

    PrimaryValueAxis

    Gets the primary value axis. Read-only.

    Declaration
    public IChartValueAxis PrimaryValueAxis { get; }
    Property Value
    Type Description
    IChartValueAxis
    Remarks

    Charts are plotted using X and Y axes. The Y axes typically have numerical scales, whereas the X axes typically have categorical scales. Some charts, for example, have axes, and others, like PieChart don't. Most charts have horizontal axis of type PrimaryCategoryAxis and vertical axis of type PrimaryValueAxis but some, like BarChart, have the opposite. PrimaryValueAxis represents an axis used for series values.

    ProtectDrawingObjects

    True if drawing objects in the tab sheet are protected. Read-only.

    Declaration
    public override bool ProtectDrawingObjects { get; }
    Property Value
    Type Description
    System.Boolean
    Overrides
    WorksheetBaseImpl.ProtectDrawingObjects

    Protection

    Gets protected options. Read-only.

    Declaration
    public override ExcelSheetProtection Protection { get; }
    Property Value
    Type Description
    ExcelSheetProtection
    Overrides
    WorksheetBaseImpl.Protection
    Remarks

    For setting protection options use "Protect" method.

    ProtectScenarios

    True if the scenarios of the current sheet are protected. False otherwise. Read-only.

    Declaration
    public override bool ProtectScenarios { get; }
    Property Value
    Type Description
    System.Boolean
    Overrides
    WorksheetBaseImpl.ProtectScenarios

    Relations

    Gets the collection of chart relations. Read-only.

    Declaration
    public RelationCollection Relations { get; }
    Property Value
    Type Description
    RelationCollection

    RightAngleAxes

    True if the chart axes are at right angles, independent of chart rotation or elevation. otherwise False.

    Declaration
    public bool RightAngleAxes { get; set; }
    Property Value
    Type Description
    System.Boolean

    Rotation

    Gets or sets the rotation of the 3D chart view (the rotation of the plot area around the z-axis, in degrees)-(0 to 360 degrees).

    Declaration
    public int Rotation { get; set; }
    Property Value
    Type Description
    System.Int32
    Remarks

    The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.

    SecondaryCategoryAxis

    Gets the secondary category axis of the chart. Read-only.

    Declaration
    public IChartCategoryAxis SecondaryCategoryAxis { get; }
    Property Value
    Type Description
    IChartCategoryAxis
    Remarks

    The most commonly used charts have a set of primary axes and may have a set of secondary axes. You can enable and disable this through Visible property.

    SecondaryCategoryAxisTitle

    Gets or sets the title of the secondary category axis.

    Declaration
    public string SecondaryCategoryAxisTitle { get; set; }
    Property Value
    Type Description
    System.String

    SecondaryFormats

    Gets the chart format collection in secondary axis.

    Declaration
    public ChartFormatCollection SecondaryFormats { get; }
    Property Value
    Type Description
    ChartFormatCollection

    SecondaryParentAxis

    Gets the secondary parent axis. Read-only.

    Declaration
    public ChartParentAxisImpl SecondaryParentAxis { get; }
    Property Value
    Type Description
    ChartParentAxisImpl

    SecondaryValueAxis

    Gets the secondary value axis of the chart. Read-only.

    Declaration
    public IChartValueAxis SecondaryValueAxis { get; }
    Property Value
    Type Description
    IChartValueAxis
    Remarks

    The most commonly used charts have a set of primary axes and may have a set of secondary axes. You can enable and disable this through UsePrimaryAxis property.

    SecondaryValueAxisTitle

    Gets or sets the title of the secondary value axis.

    Declaration
    public string SecondaryValueAxisTitle { get; set; }
    Property Value
    Type Description
    System.String

    Series

    Gets the collection of series of the chart. Read-only.

    Declaration
    public IChartSeries Series { get; }
    Property Value
    Type Description
    IChartSeries

    SeriesAxisTitle

    Gets or sets the title of the series axis.

    Declaration
    public string SeriesAxisTitle { get; set; }
    Property Value
    Type Description
    System.String

    SeriesNameLevel

    Gets or sets a value referring to the source level for series names.

    Declaration
    public ExcelSeriesNameLevel SeriesNameLevel { get; set; }
    Property Value
    Type Description
    ExcelSeriesNameLevel

    ShowAllFieldButtons

    Gets or sets a boolean value indicating whether to show all field buttons on a pivot chart.

    Declaration
    public bool ShowAllFieldButtons { get; set; }
    Property Value
    Type Description
    System.Boolean

    true to show all field buttons; false otherwise.

    ShowAxisFieldButtons

    Gets or sets a boolean value indicating whether to show axis field buttons on a pivot chart.

    Declaration
    public bool ShowAxisFieldButtons { get; set; }
    Property Value
    Type Description
    System.Boolean

    true to show axis field buttons; false otherwise.

    ShowLegendFieldButtons

    Gets or sets a boolean value indicating whether to show legend field buttons on a pivot chart.

    Declaration
    public bool ShowLegendFieldButtons { get; set; }
    Property Value
    Type Description
    System.Boolean

    true to show legend field buttons; false otherwise.

    ShowPlotVisible

    Gets or sets a value indicating whether to show the PlotVisibleOnly attribute.

    Declaration
    public bool ShowPlotVisible { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowReportFilterFieldButtons

    Gets or sets a boolean value indicating whether to show report filter field buttons on a pivot chart.

    Declaration
    public bool ShowReportFilterFieldButtons { get; set; }
    Property Value
    Type Description
    System.Boolean

    true to show report filter field buttons; false otherwise.

    ShowValueFieldButtons

    Gets or sets a boolean value indicating whether to show value field buttons on a pivot chart.

    Declaration
    public bool ShowValueFieldButtons { get; set; }
    Property Value
    Type Description
    System.Boolean

    true to show value field buttons; false otherwise.

    SideWall

    Gets the side wall of the 3D chart. Read-only.

    Declaration
    public IChartWallOrFloor SideWall { get; set; }
    Property Value
    Type Description
    IChartWallOrFloor

    SizeWithWindow

    True if the chart is resized to match the size of the chart sheet window. False if the chart size is not attached to the window size. Applies only to chart sheets.

    Declaration
    public bool SizeWithWindow { get; set; }
    Property Value
    Type Description
    System.Boolean

    Style

    Gets or sets the style index chart.

    Declaration
    public int Style { get; set; }
    Property Value
    Type Description
    System.Int32

    SupportWallsAndFloor

    Gets a Boolean value indicating whether this chart supports walls and floor. Read-only.

    Declaration
    public bool SupportWallsAndFloor { get; }
    Property Value
    Type Description
    System.Boolean

    TabColor

    Gets or sets the chart sheet tab color.

    Declaration
    public override ExcelKnownColors TabColor { get; set; }
    Property Value
    Type Description
    ExcelKnownColors
    Overrides
    WorksheetBaseImpl.TabColor

    TypeChanging

    True if the chart or series type is changed. False otherwise.

    Declaration
    public bool TypeChanging { get; set; }
    Property Value
    Type Description
    System.Boolean

    ValueAxisTitle

    Gets or sets the title of the value axis.

    Declaration
    public string ValueAxisTitle { get; set; }
    Property Value
    Type Description
    System.String

    Walls

    Gets the walls of the 3D chart. Read-only.

    Declaration
    public IChartWallOrFloor Walls { get; set; }
    Property Value
    Type Description
    IChartWallOrFloor

    WallsAndGridlines2D

    True if grid lines are drawn two-dimensionally on a 3-D chart. otherwise False.

    Declaration
    public bool WallsAndGridlines2D { get; set; }
    Property Value
    Type Description
    System.Boolean

    Width

    Gets or sets the width of the chart in points (1/72 inch).

    Declaration
    public double Width { get; set; }
    Property Value
    Type Description
    System.Double

    XPos

    Gets or sets the X coordinate of upper-left corner of the chart in points (1/72 inch).

    Declaration
    public double XPos { get; set; }
    Property Value
    Type Description
    System.Double

    YPos

    Gets or sets the Y coordinate of upper-left corner of the chart in points (1/72 inch).

    Declaration
    public double YPos { get; set; }
    Property Value
    Type Description
    System.Double

    ZoomToFit

    Gets or sets a Bolean value indicating whether chart sheet is zoom to fit window.

    Declaration
    public bool ZoomToFit { get; set; }
    Property Value
    Type Description
    System.Boolean

    Methods

    ChangePrimaryAxis(Boolean)

    Changes primary axis of the chart to secondary.

    Declaration
    public void ChangePrimaryAxis(bool isParsing)
    Parameters
    Type Name Description
    System.Boolean isParsing

    If parsing - true; Otherwise false.

    CheckDataTablePossibility(String, Boolean)

    Checks whether data table is compatible with specified start type.

    Declaration
    public static bool CheckDataTablePossibility(string startType, bool bThrowException)
    Parameters
    Type Name Description
    System.String startType

    Start type of the chart.

    System.Boolean bThrowException

    Boolean value indicating whether to throw exception.

    Returns
    Type Description
    System.Boolean

    True if data table is compatible with specified start type. False otherwise.

    Exceptions
    Type Condition
    System.NotSupportedException

    When the chart type is not supported by the data table.

    CheckForSupportGridLine()

    Checks for existing gridlines in chart.

    Declaration
    public bool CheckForSupportGridLine()
    Returns
    Type Description
    System.Boolean

    Returns true if gridlines exist; Otherwise false.

    Clone(Dictionary<String, String>, Object, Dictionary<Int32, Int32>)

    Creates a copy of the current instance with the specified dictionary of worksheet names.

    Declaration
    public ChartImpl Clone(Dictionary<string, string> hashNewNames, object parent, Dictionary<int, int> dicFontIndexes)
    Parameters
    Type Name Description
    System.Collections.Generic.Dictionary<System.String, System.String> hashNewNames

    Hash table with new Worksheet names.

    System.Object parent

    Parent object.

    System.Collections.Generic.Dictionary<System.Int32, System.Int32> dicFontIndexes

    Dictionary with new font indexes.

    Returns
    Type Description
    ChartImpl

    Cloned object which is a copy of the current object.

    Clone(Object)

    Creates a copy of current instance.

    Declaration
    public override object Clone(object parent)
    Parameters
    Type Name Description
    System.Object parent

    Parent object.

    Returns
    Type Description
    System.Object

    Returns clone of current object.

    Overrides
    WorksheetBaseImpl.Clone(Object)

    CreateNecessaryAxes(Boolean)

    Creates necessary primary axes.

    Declaration
    public void CreateNecessaryAxes(bool bPrimary)
    Parameters
    Type Name Description
    System.Boolean bPrimary

    Value indicating whether axis is primary.

    DetectChartType()

    Detects the type of the chart.

    Declaration
    public void DetectChartType()
    Exceptions
    Type Condition
    System.ArgumentOutOfRangeException

    When it is not possible to detect chart type.

    DetectIsInRowOnParsing()

    Detects if series in rows.

    Declaration
    public void DetectIsInRowOnParsing()

    DoubleToFixedPoint(Double)

    Converts the specified double value into 32-bits fixed-point value.

    Declaration
    public static int DoubleToFixedPoint(double value)
    Parameters
    Type Name Description
    System.Double value

    Value to convert.

    Returns
    Type Description
    System.Int32

    Converted 32-bits fixed-point value.

    FixedPointToDouble(Int32)

    Converts the specified 32-bits fixed-point value into double.

    Declaration
    public static double FixedPointToDouble(int value)
    Parameters
    Type Name Description
    System.Int32 value

    Value to convert.

    Returns
    Type Description
    System.Double

    Converted double value.

    GetCategoryRange(IRange, out IRange, Int32, Boolean)

    Finds the category range in the specified chart range.

    Declaration
    public static IRange GetCategoryRange(IRange Chartvalues, out IRange values, int count, bool bIsInRow)
    Parameters
    Type Name Description
    IRange Chartvalues

    Range of chart values.

    IRange values

    Outputted category range values.

    System.Int32 count

    Chart values count.

    System.Boolean bIsInRow

    Boolean value indicating if series is in row.

    Returns
    Type Description
    IRange

    Category range in the specified chart range.

    GetIs100(ExcelChartType)

    Determines if the chart is 100% in view.

    Declaration
    public static bool GetIs100(ExcelChartType chartType)
    Parameters
    Type Name Description
    ExcelChartType chartType

    The type of the chart.

    Returns
    Type Description
    System.Boolean

    True if the chart is 100%. False otherwise.

    GetIsChartPie(ExcelChartType)

    Determines whether specified chart type is pie chart.

    Declaration
    public static bool GetIsChartPie(ExcelChartType chartType)
    Parameters
    Type Name Description
    ExcelChartType chartType

    The chart type to check.

    Returns
    Type Description
    System.Boolean

    Value indicating whether specified chart type is pie chart.

    GetIsClustered(ExcelChartType)

    Determines if the specified chart type is clustered chart.

    Declaration
    public static bool GetIsClustered(ExcelChartType chartType)
    Parameters
    Type Name Description
    ExcelChartType chartType

    The chart type to check.

    Returns
    Type Description
    System.Boolean

    True if teh chart type is clustered. False otherwise.

    GetIsStacked(ExcelChartType)

    Determines if the specified chart type is stacked.

    Declaration
    public static bool GetIsStacked(ExcelChartType chartType)
    Parameters
    Type Name Description
    ExcelChartType chartType

    The chart type to check.

    Returns
    Type Description
    System.Boolean

    True if the chart is clustered chart. False otherwise.

    GetSerieOrAxisRange(IRange, Boolean, out IRange)

    Gets data range that represents series name or category axis.

    Declaration
    public IRange GetSerieOrAxisRange(IRange range, bool bIsInRow, out IRange serieRange)
    Parameters
    Type Name Description
    IRange range

    Represents data range.

    System.Boolean bIsInRow

    Represents if series in row.

    IRange serieRange

    Represents range that contain series value range.

    Returns
    Type Description
    IRange

    Returns series name or category axis range, if possible; otherwise null.

    InitializeCollections()

    Initializes all internal collections.

    Declaration
    protected override void InitializeCollections()
    Overrides
    WorksheetBaseImpl.InitializeCollections()

    MarkUsedReferences(Boolean[])

    Sets items with used reference indexes to true.

    Declaration
    public override void MarkUsedReferences(bool[] usedItems)
    Parameters
    Type Name Description
    System.Boolean[] usedItems

    Array to mark used references in.

    Overrides
    WorksheetBaseImpl.MarkUsedReferences(Boolean[])

    Parse()

    Parses internal records.

    Declaration
    public override void Parse()
    Overrides
    WorksheetBaseImpl.Parse()

    ParseData(Dictionary<Int32, Int32>)

    Parses object's records.

    Declaration
    protected override void ParseData(Dictionary<int, int> dictUpdatedSSTIndexes)
    Parameters
    Type Name Description
    System.Collections.Generic.Dictionary<System.Int32, System.Int32> dictUpdatedSSTIndexes
    Overrides
    WorksheetBaseImpl.ParseData(Dictionary<Int32, Int32>)

    ParseLegend(IList<BiffRecordRaw>, ref Int32)

    Parses the legend in the chart.

    Declaration
    public void ParseLegend(IList<BiffRecordRaw> data, ref int iPos)
    Parameters
    Type Name Description
    System.Collections.Generic.IList<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw> data

    Record storage.

    System.Int32 iPos

    Position in storage.

    PrepareProtectionOptions(ExcelSheetProtection)

    Prepares protection options before setting protection.

    Declaration
    protected override ExcelSheetProtection PrepareProtectionOptions(ExcelSheetProtection options)
    Parameters
    Type Name Description
    ExcelSheetProtection options
    Returns
    Type Description
    ExcelSheetProtection
    Overrides
    WorksheetBaseImpl.PrepareProtectionOptions(ExcelSheetProtection)

    RemoveFormat(IChartFormat)

    Removes the specified chart format.

    Declaration
    public void RemoveFormat(IChartFormat formatToRemove)
    Parameters
    Type Name Description
    IChartFormat formatToRemove

    Format to remove.

    Serialize(OffsetArrayList)

    Saves chart into OffsetArrayList.

    Declaration
    public override void Serialize(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    OffsetArrayList that will receive all chart's records.

    Overrides
    WorksheetBaseImpl.Serialize(OffsetArrayList)
    Exceptions
    Type Condition
    System.ArgumentNullException

    When specified OffsetArrayList is NULL.

    SerializeFloor(OffsetArrayList)

    Serialize the chart's floor.

    Declaration
    public void SerializeFloor(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    Records collection.

    SerializeLegend(OffsetArrayList)

    Serialize the chart's legend.

    Declaration
    public void SerializeLegend(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    Represents record list to serialize into.

    SerializePlotArea(OffsetArrayList)

    Serialize plot area to stg stream.

    Declaration
    public void SerializePlotArea(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    Represents record storage.

    SerializeWalls(OffsetArrayList)

    Serialize chart walls.

    Declaration
    public void SerializeWalls(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    Records collection.

    SetToDefaultGridlines(ExcelChartType)

    Sets default chart grid lines on chart type or series type changing.

    Declaration
    public void SetToDefaultGridlines(ExcelChartType type)
    Parameters
    Type Name Description
    ExcelChartType type

    Represents chart type to change.

    UpdateCategory(ChartSeriesCollection, Boolean)

    Updates chart categories from the specified series collection.

    Declaration
    public void UpdateCategory(ChartSeriesCollection series, bool fromDataRange)
    Parameters
    Type Name Description
    ChartSeriesCollection series

    Series collection.

    System.Boolean fromDataRange

    Boolean value indicating if the chart is from data range.

    UpdateChartFbiIndexes(IDictionary)

    Updates scalable font indexes in the chart sheet.

    Declaration
    public void UpdateChartFbiIndexes(IDictionary dicFontIndexes)
    Parameters
    Type Name Description
    System.Collections.IDictionary dicFontIndexes

    Dictionary with new indexes.

    UpdateChartFontXIndexes(IDictionary)

    Updates font indexes in the chart sheet.

    Declaration
    public void UpdateChartFontXIndexes(IDictionary dicFontIndexes)
    Parameters
    Type Name Description
    System.Collections.IDictionary dicFontIndexes

    Dictionary with new indexes.

    UpdateChartTitle()

    Updates chart title on chart creation.

    Declaration
    public void UpdateChartTitle()

    UpdateFormula(Int32, Int32, Rectangle, Int32, Rectangle)

    Updates formulas after copy operation.

    Declaration
    public override void UpdateFormula(int iCurIndex, int iSourceIndex, Rectangle sourceRect, int iDestIndex, Rectangle destRect)
    Parameters
    Type Name Description
    System.Int32 iCurIndex

    Current worksheet index.

    System.Int32 iSourceIndex

    Source worksheet index.

    Rectangle sourceRect

    Source rectangle.

    System.Int32 iDestIndex

    Destination worksheet index.

    Rectangle destRect

    Destination rectangle.

    Overrides
    WorksheetBaseImpl.UpdateFormula(Int32, Int32, Rectangle, Int32, Rectangle)

    UpdateReferenceIndexes(Int32[])

    Updates reference indexes.

    Declaration
    public override void UpdateReferenceIndexes(int[] arrUpdatedIndexes)
    Parameters
    Type Name Description
    System.Int32[] arrUpdatedIndexes

    Array with updated indexes.

    Overrides
    WorksheetBaseImpl.UpdateReferenceIndexes(Int32[])

    UpdateSeries(ChartSeriesCollection)

    Updates series filter from the specified series collection.

    Declaration
    public void UpdateSeries(ChartSeriesCollection series)
    Parameters
    Type Name Description
    ChartSeriesCollection series

    Series collection.

    Implements

    System.IDisposable
    IChart
    ITabSheet
    IParentApplication
    ISerializableNamedObject
    INamedObject
    IParseable
    ICloneParent
    Back to top Generated by DocFX
    Copyright © 2001 - 2023 Syncfusion Inc. All Rights Reserved