

'DeclarationPublic Class Line3DChart Inherits Chart3D
'UsageDim instance As Line3DChart
public class Line3DChart : Chart3D
The code below would display the following Chart:
var workbook = Workbook.Create( ChartSample.ChartSampleOutputDirectory + @"AddCharts.xlsx" ); // Gets the first Worksheet. A Workbook always contains at least 1 Worksheet. var worksheet = workbook.Worksheets[ 0 ]; // Adds Values for Category. worksheet.Cells[ "B4" ].Value = 2020; worksheet.Cells[ "B5" ].Value = 2021; worksheet.Cells[ "B6" ].Value = 2022; worksheet.Cells[ "B7" ].Value = 2023; worksheet.Cells[ "B8" ].Value = 2024; // Adds Values for Series. worksheet.Cells[ "C4" ].Value = 20; worksheet.Cells[ "C5" ].Value = 28; worksheet.Cells[ "C6" ].Value = 33; worksheet.Cells[ "C7" ].Value = 12; worksheet.Cells[ "C8" ].Value = 45; worksheet.Cells[ "D4" ].Value = 7; worksheet.Cells[ "D5" ].Value = 33; worksheet.Cells[ "D6" ].Value = 15; worksheet.Cells[ "D7" ].Value = 35; worksheet.Cells[ "D8" ].Value = 25; // Adds a Line3DChart with the generic Add method. The size of the Chart will be from Cell E4 to L18. var line3DChart = worksheet.Charts.Add<Line3DChart>( "E4", "L18" ); // Sets the Chart's Title. line3DChart.Title.Text = "Profits"; line3DChart.Title.TextOptions.Font.Bold = true; // Sets the Legend. line3DChart.Legend.Position = LegendPositionType.Right; // Sets the Category data(x values) for the Column3DChart : Cells B4 to B8. line3DChart.CategoryData = CategoryData.FromCells( worksheet, "B4", "B8" ); // Adds LineSeries to the LineChart (y values) by specifying fixed values, a Range of Cells’ Adresses and a Range of Cells’ Row & Column ids. var lineSeries1 = line3DChart.SeriesCollection.AddFromValues<LineSeries>( 5, 10, 15, 20, 40 ); lineSeries1.Name = "IBM"; var lineSeries2 = line3DChart.SeriesCollection.AddFromCells<LineSeries>( "C4", "C8" ); lineSeries2.Name = "Apple"; var lineSeries3 = line3DChart.SeriesCollection.AddFromCells<LineSeries>( 3, 3, 7, 3 ); lineSeries3.Name = "Amazon"; // Saves Workbook to disk. workbook.Save();
System.Object
Xceed.Workbooks.NET.WorkbookElement
Xceed.Workbooks.NET.WorksheetElement
Xceed.Workbooks.NET.PositionedElement
Xceed.Workbooks.NET.Chart
Xceed.Workbooks.NET.Chart3D
Xceed.Workbooks.NET.Line3DChart
| Name | Description | |
|---|---|---|
![]() | Line3DChart Constructor | Creates a Line3DChart in the Worksheet. |
| Name | Description | |
|---|---|---|
![]() | AbsolutePosition | Gets or sets the absolute Position of the PositionedElement. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | AnchorPosition | Gets or sets the position of the Anchor in the Worksheet. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | AnchorType | Gets the Anchor's type. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | BackWall | Gets the area that corresponds to the Chart3D's back wall. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | Border | Gets the Chart's Border. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | BottomRightOffsets | Gets or sets the value used to offset the bottom right corner of a TwoCellAnchor PositionedElement. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | CategoryAxis | Gets the Chart's CategoryAxis. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | CategoryData | Gets or sets the CategoryData that will be used for the Chart's CategoryAxis. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | DepthPercent | Gets or sets the Series' depth, in percentage. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | Description | Gets or sets the PositionedElement's description. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | DrawingClientData | Gets the DrawingClientData, which is how the data should behave when the Worksheet is protected. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | Fill | Gets the Chart's Fill. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | Floor | Gets the area that corresponds to the Chart3D's floor. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | GapDepth | Gets or sets the spacing between the LineSeries; in other words, this determines the LineSeries' depth. |
![]() | Height | Gets or sets the height of an AbsoluteAnchor or OneCellAnchor PositionedElement. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | HeightPercent | Gets or sets the Series' height, in percentage. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | IsColorVariedByPoint | Gets or sets if the Chart automatically varies Colors for its Series' data. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | IsRightAngleAxes | Gets or sets if the Chart3D's Axes are displayed so that they are at a right angle (90 degrees) from each other. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | IsRoundedCorners | Gets or sets if the Chart has rounded corners. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | Legend | Gets the Chart's Legend. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | MeasureUnit | Gets or sets the Units used for measuring the PositionedElement's Width & Height. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | Name | Gets or sets the name of the PositionedElement. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | PerspectiveAngle | Gets or sets the angle of perspective used for viewing the Chart3D. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | PlotArea | Gets the Chart's PlotArea. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | RotationX | Gets or sets how the Chart3D is rotated around a vertical pivot. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | RotationY | Gets or sets how the Chart3D is rotated around a horizontal pivot. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | SecondaryCategoryAxis | Gets the Chart's secondary CategoryAxis. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | SecondaryValueAxis | Gets the Chart's secondary ValueAxis. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | SeriesAxis | Gets the Chart3D's SeriesAxis. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | SeriesCollection | Gets the Chart's SeriesCollection. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | SideWall | Gets the area that corresponds to the Chart3D's side wall. (Inherited from Xceed.Workbooks.NET.Chart3D) |
![]() | Title | Gets or sets the Chart's title. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | TopLeftOffsets | Gets or sets the value used to offset the top right corner of a TwoCellAnchor PositionedElement. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | TwoCellAnchorBehavior | Gets or sets the behavior of a TwoCellAnchor PositionedElement when moving or deleting Rows or Columns. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
![]() | ValueAxis | Gets the Chart's ValueAxis. (Inherited from Xceed.Workbooks.NET.Chart) |
![]() | Width | Gets or sets the width of an AbsoluteAnchor or OneCellAnchor PositionedElement. (Inherited from Xceed.Workbooks.NET.PositionedElement) |
.NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.
.NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.