ChartAxisGroupType Enum

Lists values that specify an axis group for chart series and views.

Namespace: DevExpress.Docs.Office

Assembly: DevExpress.Docs.Core.v26.1.dll

Declaration

C#

public enum ChartAxisGroupType

VB.NET

Public Enum ChartAxisGroupType

Members

Name	Description
Primary	Uses primary axes.
Secondary	Uses secondary axes.

Related API Members

The following properties accept/return ChartAxisGroupType values:

• AreaSeries.AxisGroup
• BarSeries.AxisGroup
• ChartViewBase.AxisGroup
• LineSeries.AxisGroup
• PieSeriesBase.AxisGroup
• RadarSeries.AxisGroup
• ScatterSeries.AxisGroup
• StockSeries.AxisGroup

Example

The following code snippet adds two line series to the primary axes and one line series to the secondary axes:

C#

using DevExpress.Docs.Office;
using DevExpress.Docs.Presentation;

namespace PresentationApiSample;

public class Program {
    public static async Task Main(string[] _) {

        Presentation presentation = new Presentation();

        presentation.Slides.Clear();

        Slide slide = new Slide(SlideLayoutType.Blank);
        presentation.Slides.Add(slide);

        Chart chart = new Chart();
        slide.Shapes.Add(chart);

        chart.Width = presentation.SlideSize.Width;
        chart.Height = presentation.SlideSize.Height;

        // Specify data for the chart.
        chart.Data[0, "A1"].NumericValue = 120;
        chart.Data[0, "A2"].NumericValue = 95;
        chart.Data[0, "A3"].NumericValue = 140;
        chart.Data[0, "A4"].NumericValue = 100;
        chart.Data[0, "A5"].NumericValue = 80;
        chart.Data[0, "B1"].NumericValue = 10;
        chart.Data[0, "B2"].NumericValue = 20;
        chart.Data[0, "B3"].NumericValue = 30;
        chart.Data[0, "B4"].NumericValue = 40;
        chart.Data[0, "B5"].NumericValue = 50;

        chart.Data[0, "C1"].NumericValue = 6000;
        chart.Data[0, "C2"].NumericValue = 10500;
        chart.Data[0, "C3"].NumericValue = 10000;
        chart.Data[0, "C4"].NumericValue = 7000;
        chart.Data[0, "C5"].NumericValue = 9500;

        chart.Data[0, "D1"].NumericValue = 180;
        chart.Data[0, "D2"].NumericValue = 95;
        chart.Data[0, "D3"].NumericValue = 120;
        chart.Data[0, "D4"].NumericValue = 80;
        chart.Data[0, "D5"].NumericValue = 130;

        // Add the first series to the chart.
        LineSeries series1 = new LineSeries();
        series1.Values = new ChartDataReference(sheetIndex: 0, fromCellReference: "A1", toCellReference: "A5");
        series1.Arguments = new ChartDataReference(sheetIndex: 0, fromCellReference: "B1", toCellReference: "B5");
        chart.Series.Add(series1);

        // Add the second series to the chart.
        LineSeries series2 = new LineSeries();
        series2.Values = new ChartDataReference(sheetIndex: 0, fromCellReference: "D1", toCellReference: "D5");
        series2.Arguments = new ChartDataReference(sheetIndex: 0, fromCellReference: "B1", toCellReference: "B5");
        chart.Series.Add(series2);

        // Add the third series to the chart and assign it to the secondary axes.
        LineSeries series3 = new LineSeries();
        series3.Values = new ChartDataReference(sheetIndex: 0, fromCellReference: "C1", toCellReference: "C5");
        series3.Arguments = new ChartDataReference(sheetIndex: 0, fromCellReference: "B1", toCellReference: "B5");
        series3.AxisGroup = ChartAxisGroupType.Secondary;
        chart.Series.Add(series3);

        // Remove the legend.
        chart.Legend = null;

        // Customize the primary argument axis.
        CategoryAxis? xAxis = chart.ArgumentAxis as CategoryAxis;
        if (xAxis != null) {
            xAxis.MajorTickMark = AxisTickMarkType.Cross;
            xAxis.MinorTickMark = AxisTickMarkType.Inside;
            xAxis.LabelTextProperties = new TextProperties { FontSize = 30 };
        }
        // Customize the primary value axis.
        ValueAxis? yAxis = chart.ValueAxis;
        if (yAxis != null) {
            yAxis.CrossPositionType = AxisCrossPositionType.OnTickMarks;
            yAxis.LabelTextProperties = new TextProperties { FontSize = 30 };
        }
        // Hide the secondary argument axis.
        chart.SecondaryArgumentAxis.Visible = false;

        // Customize the secondary value axis.
        ValueAxis? secYAxis = chart.SecondaryValueAxis;
        if (secYAxis != null) {
            secYAxis.Position = AxisPositionType.Right;
            secYAxis.LabelTextProperties = new TextProperties { FontSize = 30 };

        }
        // Customize data labels for the first two series.
        LineChartView lineView1 = (LineChartView)chart.Views[0];
        lineView1.DataLabels.ShowCategoryName = true;
        lineView1.DataLabels.ShowValue = true;

        // Customize data labels for the third series.
        LineChartView lineView2 = (LineChartView)chart.Views[1];
        lineView2.DataLabels.ShowValue = true;
    }
}

VB.NET

Imports DevExpress.Docs.Office
Imports DevExpress.Docs.Presentation

Namespace PresentationApiSample

Public Class Program
    Public Shared Async Function Main(ByVal _ As String()) As Task

        Dim presentation As New Presentation()

        presentation.Slides.Clear()

        Dim slide As New Slide(SlideLayoutType.Blank)
        presentation.Slides.Add(slide)

        Dim chart As New Chart()
        slide.Shapes.Add(chart)

        chart.Width = presentation.SlideSize.Width
        chart.Height = presentation.SlideSize.Height

        ' Specify data for the chart.
        chart.Data(0, "A1").NumericValue = 120
        chart.Data(0, "A2").NumericValue = 95
        chart.Data(0, "A3").NumericValue = 140
        chart.Data(0, "A4").NumericValue = 100
        chart.Data(0, "A5").NumericValue = 80

        chart.Data(0, "B1").NumericValue = 10
        chart.Data(0, "B2").NumericValue = 20
        chart.Data(0, "B3").NumericValue = 30
        chart.Data(0, "B4").NumericValue = 40
        chart.Data(0, "B5").NumericValue = 50

        chart.Data(0, "C1").NumericValue = 6000
        chart.Data(0, "C2").NumericValue = 10500
        chart.Data(0, "C3").NumericValue = 10000
        chart.Data(0, "C4").NumericValue = 7000
        chart.Data(0, "C5").NumericValue = 9500

        chart.Data(0, "D1").NumericValue = 180
        chart.Data(0, "D2").NumericValue = 95
        chart.Data(0, "D3").NumericValue = 120
        chart.Data(0, "D4").NumericValue = 80
        chart.Data(0, "D5").NumericValue = 130

        ' Add the first series to the chart.
        Dim series1 As New LineSeries()
        series1.Values = New ChartDataReference(sheetIndex:=0, fromCellReference:="A1", toCellReference:="A5")
        series1.Arguments = New ChartDataReference(sheetIndex:=0, fromCellReference:="B1", toCellReference:="B5")
        chart.Series.Add(series1)

        ' Add the second series to the chart.
        Dim series2 As New LineSeries()
        series2.Values = New ChartDataReference(sheetIndex:=0, fromCellReference:="D1", toCellReference:="D5")
        series2.Arguments = New ChartDataReference(sheetIndex:=0, fromCellReference:="B1", toCellReference:="B5")
        chart.Series.Add(series2)

        ' Add the third series to the chart and assign it to the secondary axes.
        Dim series3 As New LineSeries()
        series3.Values = New ChartDataReference(sheetIndex:=0, fromCellReference:="C1", toCellReference:="C5")
        series3.Arguments = New ChartDataReference(sheetIndex:=0, fromCellReference:="B1", toCellReference:="B5")
        series3.AxisGroup = ChartAxisGroupType.Secondary
        chart.Series.Add(series3)

        ' Remove the legend.
        chart.Legend = Nothing

        ' Customize the primary argument axis.
        Dim xAxis As CategoryAxis = TryCast(chart.ArgumentAxis, CategoryAxis)
        If xAxis IsNot Nothing Then
            xAxis.MajorTickMark = AxisTickMarkType.Cross
            xAxis.MinorTickMark = AxisTickMarkType.Inside

            xAxis.LabelTextProperties = New TextProperties With {.FontSize = 30}
        End If

        ' Customize the primary value axis.
        Dim yAxis As ValueAxis = chart.ValueAxis
        If yAxis IsNot Nothing Then
            yAxis.CrossPositionType = AxisCrossPositionType.OnTickMarks
            yAxis.LabelTextProperties = New TextProperties With {.FontSize = 30}
        End If

        ' Hide the secondary argument axis.
        chart.SecondaryArgumentAxis.Visible = False

        ' Customize the secondary value axis.
        Dim secYAxis As ValueAxis = chart.SecondaryValueAxis
        If secYAxis IsNot Nothing Then
            secYAxis.Position = AxisPositionType.Right
            secYAxis.LabelTextProperties = New TextProperties With {.FontSize = 30}
        End If

        ' Customize data labels for the first two series.
        Dim lineView1 As LineChartView = CType(chart.Views(0), LineChartView)
        lineView1.DataLabels.ShowCategoryName = True
        lineView1.DataLabels.ShowValue = True

        ' Customize data labels for the third series.
        Dim lineView2 As LineChartView = CType(chart.Views(1), LineChartView)
        lineView2.DataLabels.ShowValue = True
    End Function
End Class
End Namespace