Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelChartSeriesRange

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
0eef6a5756b9 with working tree changes
Modifiers
sealed

Describes the worksheet ranges of one chart series: categories (X) and values (Y) for category and scatter charts, plus bubble sizes for bubble charts.

Inheritance

  • object
  • ExcelChartSeriesRange

Usage

Explore 3 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Accepted by parameters 3

Constructors

ExcelChartSeriesRange 2 overloads
public ExcelChartSeriesRange(string xRangeA1, string yRangeA1) #

Creates a series range definition from a category or X range and a values or Y range.

Parameters

xRangeA1 string required
yRangeA1 string required
public ExcelChartSeriesRange(string name, string xRangeA1, string yRangeA1, string? bubbleSizeRangeA1 = null) #

Creates a named series range definition; bubble charts also take a bubble size range.

Parameters

name string required
xRangeA1 string required
yRangeA1 string required
bubbleSizeRangeA1 string? = null optional

Properties

public string Name { get; } #

Gets the series display name.

public string XRangeA1 { get; } #

Gets the categories range of a category chart, or the X values range of a scatter or bubble chart (A1 notation).

public string YRangeA1 { get; } #

Gets the values range of a category chart, or the Y values range of a scatter or bubble chart (A1 notation).

public string? BubbleSizeRangeA1 { get; } #

Gets the bubble size range (A1 notation), when applicable.