Click or drag to resize

IChartFormat Properties

The IChartFormat type exposes the following members.

Properties
Name Description
Public property Code example BubbleScale
Percent of largest bubble compared to chart in general. ( 0 - 300 ).
Examples
The following code illustrates how to set BubbleScale for ExcelChartType.Bubble3D chart:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add(ExcelChartType.Bubble3D);</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>chart.Series[0].Bubbles = worksheet.Range["A2:C3"];</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set bubble scale</para><para>format.BubbleScale = 50;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example DoughnutHoleSize
Size of center hole in a doughnut chart (as a percentage).( 10 - 90 ).
Examples
The following code illustrates how to set DoughnutHoleSize for ExcelChartType.Doughnut chart:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Doughnut;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set Doughnut hole size</para><para>format.DoughnutHoleSize = 60;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example FirstDropBar
Returns object that represents first drop bar.
Examples
The following code illustrates how to access FirstDropBar:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Line;</para><para>//Set chart drop bar</para><para>IChartDropBar dropBar = chart.Series[0].Format.Options.FirstDropBar;</para>
Public property Code example FirstSliceAngle
Angle of the first pie slice expressed in degrees. ( 0 - 360 ).
Examples
The following code illustrates how to set FirstSliceAngle for ExcelChartType.Pie chart:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Pie;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set Gap width</para><para>format.FirstSliceAngle = 60;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example GapWidth
Space between categories (percent of bar width), default = 50.
Examples
The following code illustrates how to set GapWidth for ExcelChartType.Column3DStacked chart:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Column3DStacked;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set Gap width</para><para>format.GapWidth = 400;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example HasRadarAxisLabels
True if a radar chart has axis labels. Applies only to radar charts.
Examples
The following code illustrates how to hide the axis labels of radar charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Radar;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set radar label visibility</para><para>format.HasRadarAxisLabels = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example IsVaryColor
Vary color for each data point.
Examples
The following code illustrates how to set IsVaryColor for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set vary color</para><para>format.IsVaryColor = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example Overlap
Space between bars ( -100 : 100 ).
Examples
The following code illustrates how to set Overlap for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnStacked;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set overlap</para><para>format.Overlap = 20;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example PieSecondSize
Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. ( 5 - 200 ).
Examples
The following code illustrates how to set PieSecondSize for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.PieOfPie;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set second pie size</para><para>format.PieSecondSize = 40;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example PieSeriesLine
Represents series line properties. ( For pie of pie or pie of bar chart types only. ) Read only.
Examples
The following code illusrates how to set color to IChartBorder.Color property for ExcelChartType.PieOfPie chart using PieSeriesLine property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.PieOfPie;</para><para>//Set pie series line border</para><para>IChartBorder border =chart.Series[0].Format.Options.PieSeriesLine;</para><para>//Set color</para><para>border.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example SecondDropBar
Returns object that represents second drop bar.
Examples
The following code illustrates how to access SecondDropBar:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Line;</para><para>//Set chart first drop bar</para><para>IChartDropBar dropBar = chart.Series[0].Format.Options.FirstDropBar;</para><para>//Set chart second drop bar</para><para>dropBar = chart.Series[0].Format.Options.SecondDropBar;</para>
Public property Code example ShowNegativeBubbles
True to show negative bubbles.
Examples
The following code illustrates how to load negative values to ExcelChartType.Bubble3D chart value axis and set ShowNegativeBubbles to "true":
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add(ExcelChartType.Bubble3D);</para><para>chart.DataRange = worksheet.Range["A1:D2"];</para><para>chart.Series[0].Bubbles = worksheet.Range["A2:C3"];</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set negative bubble visibility</para><para>format.ShowNegativeBubbles = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example SizeRepresents
Returns or sets what the bubble size represents on a bubble chart.
Examples
The following code illustrates how to set BubbleSizeType.Width to SizeRepresents property:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add(ExcelChartType.Bubble3D);</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>chart.Series[0].Bubbles = worksheet.Range["A2:C3"];</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set bubble scale and size represents</para><para>format.BubbleScale = 50;</para><para>format.SizeRepresents = BubbleSizeType.Width;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example SplitType
Returns or sets the way the two sections of either a pie of pie chart or a bar of pie chart are split.
Examples
The following code illustrates how to set SplitType.Value to SplitType:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.PieOfPie;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set split type</para><para>format.SplitType = SplitType.Value;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example SplitValue
Returns or sets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart.
Examples
The following code illustrates how to set SplitValue for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.PieOfPie;</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set split value</para><para>format.SplitValue = 20;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Top
See Also