ParetoSeries Class

A series that combines a histogram with a cumulative percentage line.

Namespace: DevExpress.Docs.Office

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

NuGet Package: DevExpress.Docs.Core

Declaration

C#

public sealed class ParetoSeries :
    SeriesExBase

VB.NET

Public NotInheritable Class ParetoSeries
    Inherits SeriesExBase

Related API Members

The following members return ParetoSeries objects:

• ParetoSeries.Clone()

Remarks

The following code snippet adds a Pareto series to a chart and configures its properties:

C#

using DevExpress.Docs.Office;
using DevExpress.Docs.Presentation;
using System.Drawing;

namespace PresentationApiSample;

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

        // Create a presentation.
        Presentation presentation = new Presentation();

        // Reset the slide collection.
        presentation.Slides.Clear();

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

        // Insert a chart on the slide.
        ChartEx chart = new ChartEx();
        slide.Shapes.Add(chart);

        // Set chart size to match the slide.
        chart.Width = presentation.SlideSize.Width;
        chart.Height = presentation.SlideSize.Height;

        // Create a histogram series and assign values.
        HistogramSeries histogramSeries = new HistogramSeries();
        histogramSeries.Values = new ChartNumericData(new double[] { 1, 2, 3, 2, 13, 12, 19, 34, 22, 21, 34, 30, 18, 16, 33 });

        // Configure histogram bins.
        histogramSeries.BinType = HistogramBinType.BinSize;
        histogramSeries.BinSize = 10;

        // Add the series to the chart.
        chart.Series.Add(histogramSeries);

        // Display and format data labels.
        histogramSeries.DataLabels.ShowValue = true;
        histogramSeries.DataLabels.TextProperties = new TextProperties { FontSize = 24, Fill = new SolidFill(Color.Magenta) };

        // Add a Pareto series.
        ParetoSeries paretoSeries = new ParetoSeries();
        paretoSeries.HistogramSeries = histogramSeries;
        chart.Series.Add(paretoSeries);

        // Set argument axis label formatting.
        CategoryAxisEx? xAxis = chart.ArgumentAxis;
        if (xAxis != null) {
            xAxis.LabelTextProperties = new TextProperties { FontSize = 24 };
        }

        // Hide the chart legend.
        chart.Legend = null;
        // Save the result to a file.
        var outputPath = @"D:\presentation.pptx";
        using FileStream outputStream = new(outputPath, FileMode.Create, FileAccess.Write, FileShare.None);
        presentation.SaveDocument(outputStream);

    }
}

VB.NET

Imports DevExpress.Docs.Office
Imports DevExpress.Docs.Presentation
Imports System.Drawing
Imports System.IO

Namespace PresentationApiSample

Public Class Program
  Public Shared Sub Main(ByVal args As String())
    ' Create a presentation.
    Dim presentation As New Presentation()

    ' Reset the slide collection.
    presentation.Slides.Clear()

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

    ' Insert a chart on the slide.
    Dim chart As New ChartEx()
    slide.Shapes.Add(chart)

    ' Set chart size to match the slide.
    chart.Width = presentation.SlideSize.Width
    chart.Height = presentation.SlideSize.Height

    ' Create a histogram series and assign values.
    Dim histogramSeries As New HistogramSeries()
    histogramSeries.Values = New ChartNumericData(New Double() {1, 2, 3, 2, 13, 12, 19, 34, 22, 21, 34, 30, 18, 16, 33})

    ' Configure histogram bins.
    histogramSeries.BinType = HistogramBinType.BinSize
    histogramSeries.BinSize = 10

    ' Add the series to the chart.
    chart.Series.Add(histogramSeries)

    ' Display and format data labels.
    histogramSeries.DataLabels.ShowValue = True
    histogramSeries.DataLabels.TextProperties = New TextProperties With {
      .FontSize = 24,
      .Fill = New SolidFill(Color.Magenta)
    }

    ' Add a Pareto series.
    Dim paretoSeries As New ParetoSeries()
    paretoSeries.HistogramSeries = histogramSeries
    chart.Series.Add(paretoSeries)

    ' Set argument axis label formatting.
    Dim xAxis As CategoryAxisEx = chart.ArgumentAxis
    If xAxis IsNot Nothing Then
      xAxis.LabelTextProperties = New TextProperties With {.FontSize = 24}
    End If

    ' Hide the chart legend.
    chart.Legend = Nothing
    ' Save the result to a file.
    Dim outputPath = "D:\presentation.pptx"
    Using outputStream As New FileStream(outputPath, FileMode.Create, FileAccess.Write, FileShare.None)
      presentation.SaveDocument(outputStream)
    End Using
  End Sub
End Class

End Namespace

Implements

ICloneable

Inheritance

Object

OfficeObject

SeriesExBase

ParetoSeries