menu

Xamarin.Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IOfficeChartValueAxis - Xamarin.Forms API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface IOfficeChartValueAxis

    Represents the chart value axis.

    Inherited Members
    IOfficeChartAxis.AutoTickLabelSpacing
    IOfficeChartAxis.AxisType
    IOfficeChartAxis.Border
    IOfficeChartAxis.Chart3DOptions
    IOfficeChartAxis.Font
    IOfficeChartAxis.HasMajorGridLines
    IOfficeChartAxis.HasMinorGridLines
    IOfficeChartAxis.MajorGridLines
    IOfficeChartAxis.MajorTickMark
    IOfficeChartAxis.MinorGridLines
    IOfficeChartAxis.MinorTickMark
    IOfficeChartAxis.NumberFormat
    IOfficeChartAxis.ReversePlotOrder
    IOfficeChartAxis.Shadow
    IOfficeChartAxis.TextRotationAngle
    IOfficeChartAxis.TickLabelPosition
    IOfficeChartAxis.Title
    IOfficeChartAxis.TitleArea
    IOfficeChartAxis.Visible
    Namespace: Syncfusion.OfficeChart
    Assembly: Syncfusion.OfficeChart.Portable.dll
    Syntax
    public interface IOfficeChartValueAxis : IOfficeChartAxis

    Properties

    CrossesAt

    Gets or sets the point on the value axis where the category axis crosses it. Applies only to the value axis.

    Declaration
    double CrossesAt { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Set the crosses At
    chart.PrimaryValueAxis.CrossesAt = 1.2;
    //Set the display unit
    chart.PrimaryValueAxis.DisplayUnit = OfficeChartDisplayUnit.Hundreds;
    //Set the display unit custom
    chart.PrimaryValueAxis.DisplayUnitCustom = 12.34;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    DisplayUnit

    Gets or sets the unit label for the value axis.

    Declaration
    OfficeChartDisplayUnit DisplayUnit { get; set; }
    Property Value
    Type
    OfficeChartDisplayUnit
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Set the crosses At
    chart.PrimaryValueAxis.CrossesAt = 1.2;
    //Set the display unit
    chart.PrimaryValueAxis.DisplayUnit = OfficeChartDisplayUnit.Hundreds;
    //Set the display unit custom
    chart.PrimaryValueAxis.DisplayUnitCustom = 12.34;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    DisplayUnitCustom

    Gets or sets the value of the displayed units. while DisplayUnit type is custom.

    Declaration
    double DisplayUnitCustom { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Set the crosses At
    chart.PrimaryValueAxis.CrossesAt = 1.2;
    //Set the display unit
    chart.PrimaryValueAxis.DisplayUnit = OfficeChartDisplayUnit.Hundreds;
    //Set the display unit custom
    chart.PrimaryValueAxis.DisplayUnitCustom = 12.34;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    DisplayUnitLabel

    Gets the DisplayUnitLabel object for the value axis. Gets a Null reference if the HasDisplayUnitLabel property is set to False. Read-only.

    Declaration
    IOfficeChartTextArea DisplayUnitLabel { get; }
    Property Value
    Type
    IOfficeChartTextArea
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Set the display unit
    chart.PrimaryValueAxis.DisplayUnit = OfficeChartDisplayUnit.MillionMillions;
    //Set the italic font style for the lable
    chart.PrimaryValueAxis.DisplayUnitLabel.Italic = true;
    //Set the RGB color of the label
    chart.PrimaryValueAxis.DisplayUnitLabel.RGBColor = System.Drawing.Color.Bisque;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    HasDisplayUnitLabel

    Gets or sets a value that indicates whether the label is displayed on the value axis or not.

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

    if the label is displayed on the value axis.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Set the display unit
    chart.PrimaryValueAxis.DisplayUnit = OfficeChartDisplayUnit.MillionMillions;
    //Hide the display unit label
    chart.PrimaryValueAxis.HasDisplayUnitLabel = false;  
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    IsAutoCross

    Gets or sets a value that indicates whether the automatic category crossing point selected on the value axis or not.

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

    Trueif automatically category crossing point selected on the value axis.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Disable the auto cross
    chart.PrimaryValueAxis.IsAutoCross = false;   
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    IsAutoMajor

    Gets or set a value that indicates whether automatically calculates the major units for the value axis.

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

    Trueif Essential Presentation calculates the major units for the value axis.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMajor = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMax = false;
    //Set the major unit
    chart.PrimaryValueAxis.MajorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MaximumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    IsAutoMax

    Gets or set a value that indicates whether automatically calculates the maximum value for the value axis.

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

    Trueif Essential Presentation calculates the maximum value for the value axis.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMajor = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMax = false;
    //Set the major unit
    chart.PrimaryValueAxis.MajorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MaximumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    IsAutoMin

    Gets or set a value that indicates whether automatically calculates the minimum value for the value axis.

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

    Trueif Essential Presentation calculates the minimum value for the value axis.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMin = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMinor = false;
    //Set the major unit
    chart.PrimaryValueAxis.MinorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MinimumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    IsAutoMinor

    Gets or set a value that indicates whether automatically calculates the minor units for the value axis.

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

    Trueif Essential Presentation calculates the minor units for the value axis.Otherwise False.

    IsLogScale

    Gets or sets a value that indicates whether the Logarithmic scale is using or not.

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

    Trueif using logarithmic scale.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];  
    //Set the log scale
    chart.PrimaryValueAxis.IsLogScale = true;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    IsMaxCross

    Gets or sets a value that indicates whether category axis to cross at maximum value or not.

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

    Trueif category axis to cross at maximum value.Otherwise False.

    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Disable the auto cross
    chart.PrimaryValueAxis.IsAutoCross = false;
    //Set the Max cross
    chart.PrimaryValueAxis.IsMaxCross = true;   
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    LogBase

    Returns or sets the base of the logarithm when you are using log scales. The default value is 10.

    Declaration
    double LogBase { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range (start row, start column, end row, end column) of chart series
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range (start row, start column, end row, end column) of chart series
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];  
    //Set the log scale and log base
    chart.PrimaryValueAxis.IsLogScale = true;
    chart.PrimaryValueAxis.LogBase = 2;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    MajorUnit

    Gets or sets the major units on the value axis.

    Declaration
    double MajorUnit { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMajor = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMax = false;
    //Set the major unit
    chart.PrimaryValueAxis.MajorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MaximumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    MaximumValue

    Gets or sets the maximum value on the value axis.

    Declaration
    double MaximumValue { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMajor = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMax = false;
    //Set the major unit
    chart.PrimaryValueAxis.MajorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MaximumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    MinimumValue

    Gets or sets the minimum value on the value axis.

    Declaration
    double MinimumValue { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMin = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMinor = false;
    //Set the major unit
    chart.PrimaryValueAxis.MinorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MinimumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();

    MinorUnit

    Gets or sets the minor units on the value axis.

    Declaration
    double MinorUnit { get; set; }
    Property Value
    Type
    System.Double
    Examples
    //Create a presentation instance
    IPresentation presentation = Presentation.Create();
    //Add a blank slide to the presentation
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500);
    //Specify the chart title
    chart.ChartTitle = "Sales Analysis";
    //Specify the chart type
    chart.ChartType = OfficeChartType.Column_Clustered;
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2010");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2011");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2012");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Diable auto major
    chart.PrimaryValueAxis.IsAutoMin = false;
    //Disable auto max
    chart.PrimaryValueAxis.IsAutoMinor = false;
    //Set the major unit
    chart.PrimaryValueAxis.MinorUnit = 24.34;
    //Set the maximum value
    chart.PrimaryValueAxis.MinimumValue = 60;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved