📚
OpenXML-Office
v3.x (Discontinued)
v3.x (Discontinued)
  • Welcome
    • Getting Started
    • Introduction
    • Privacy Policy
    • License
  • Presentation
    • PowerPoint
    • Slide
    • Shape
    • Picture
    • Textbox
    • Table
    • Chart
      • Area
      • Bar
      • Column
      • Line
      • Pie
      • Scatter
      • Combo
      • Waterfall
  • Spreadsheet
    • Excel
    • Worksheet
    • Shape
    • Picture
    • Table
    • Chart
      • Area
      • Bar
      • Column
      • Line
      • Pie
      • Scatter
      • Combo
    • Style
    • Shared
  • Document
    • Word
    • Pages
    • Shape
    • Picture
    • Table
    • Chart
Powered by GitBook
On this page
  • Basic Code Sample
  • LineChartSetting Options
  • LineChartDataLabel Options
  • LineChartSeriesSetting Options
  • LineChartLineFormat Options

Was this helpful?

  1. Spreadsheet
  2. Chart

Line

PreviousColumnNextPie

Was this helpful?

Add chart method present in worksheet component. By default the anchor is at 1,1 aka A1 cell.

Basic Code Sample

Worksheet worksheet = excel1.AddSheet("Line Chart");
	worksheet.AddChart(new()
	{
		cellIdStart = "A1",
		cellIdEnd = "D4"
	}, new LineChartSetting<ExcelSetting>()
	{
		applicationSpecificSetting = new()
		{
			from = new()
			{
				row = 5,
				column = 5
			},
			to = new()
			{
				row = 20,
				column = 20
			}
		}
	});

LineChartSetting Options

Property
Type
Details

lineChartDataLabel

General Data label option applied for all series

lineChartSeriesSettings

Data Series specific options are used from the list. The position on the list is matched with the data series position. you can use null to skip a series

lineChartTypes

LineChartTypes

Type of chart

chartAxesOptions

Chart axes options

LineChartDataLabel Options

Property
Type
Details

dataLabelPosition

DataLabelPositionValues

Data Label placement options.

LineChartSeriesSetting Options

Property
Type
Details

lineChartDataLabel

Data Label Option specific to one series

lineChartLineFormat

lineChartDataPointSettings

List<LineChartDataPointSetting?>

TODO

LineChartLineFormat Options

Property
Type
Details

transparency

int?

width

int?

outlineCapTypeValues

OutlineCapTypeValues?

outlineLineTypeValues

OutlineLineTypeValues?

beginArrowValues

DrawingBeginArrowValues?

endArrowValues

DrawingEndArrowValues?

dashType

DrawingPresetLineDashValues?

lineStartWidth

LineWidthValues?

lineEndWidth

LineWidthValues?

Contains options details extended from that are specific to line chart.

List<?>

Contains options details extended from that are specific to line chart.

Contains options details extended from that are specific to column chart.

LineChartDataLabel
LineChartSeriesSetting
LineChartDataLabel
LineChartLineFormat
ChartSetting
ChartDataLabel
ChartSeriesSetting
ChartAxesOptions