ExcelAddSparklineGroup Method

In This Topic

Syntax
See Also

Excels the add sparkline group.

Syntax

Visual Basic
C#

bool ExcelAddSparklineGroup( 
   short sheetIndex,
   Color colorSeries,
   Color colorNegative,
   Color colorAxis,
   Color colorMarkers,
   Color colorFirst,
   Color colorLast,
   Color colorHigh,
   Color colorLow,
   string formula,
   double manualMax,
   double manualMin,
   double lineWeight,
   short typeIndex,
   bool dateAxis,
   short displayEmptyCellsAs,
   bool markers,
   bool high,
   bool low,
   bool first,
   bool last,
   bool negative,
   bool displayXAxis,
   bool displayHidden,
   short minAxisType,
   short maxAxisType,
   bool rightToLeft
)

'Declaration
 
Function ExcelAddSparklineGroup( _
   ByVal sheetIndex As Short, _
   ByVal colorSeries As Color, _
   ByVal colorNegative As Color, _
   ByVal colorAxis As Color, _
   ByVal colorMarkers As Color, _
   ByVal colorFirst As Color, _
   ByVal colorLast As Color, _
   ByVal colorHigh As Color, _
   ByVal colorLow As Color, _
   ByVal formula As String, _
   ByVal manualMax As Double, _
   ByVal manualMin As Double, _
   ByVal lineWeight As Double, _
   ByVal typeIndex As Short, _
   ByVal dateAxis As Boolean, _
   ByVal displayEmptyCellsAs As Short, _
   ByVal markers As Boolean, _
   ByVal high As Boolean, _
   ByVal low As Boolean, _
   ByVal first As Boolean, _
   ByVal last As Boolean, _
   ByVal negative As Boolean, _
   ByVal displayXAxis As Boolean, _
   ByVal displayHidden As Boolean, _
   ByVal minAxisType As Short, _
   ByVal maxAxisType As Short, _
   ByVal rightToLeft As Boolean _
) As Boolean

'Usage
 
Dim instance As IExcelXml3
Dim sheetIndex As Short
Dim colorSeries As Color
Dim colorNegative As Color
Dim colorAxis As Color
Dim colorMarkers As Color
Dim colorFirst As Color
Dim colorLast As Color
Dim colorHigh As Color
Dim colorLow As Color
Dim formula As String
Dim manualMax As Double
Dim manualMin As Double
Dim lineWeight As Double
Dim typeIndex As Short
Dim dateAxis As Boolean
Dim displayEmptyCellsAs As Short
Dim markers As Boolean
Dim high As Boolean
Dim low As Boolean
Dim first As Boolean
Dim last As Boolean
Dim negative As Boolean
Dim displayXAxis As Boolean
Dim displayHidden As Boolean
Dim minAxisType As Short
Dim maxAxisType As Short
Dim rightToLeft As Boolean
Dim value As Boolean
 
value = instance.ExcelAddSparklineGroup(sheetIndex, colorSeries, colorNegative, colorAxis, colorMarkers, colorFirst, colorLast, colorHigh, colorLow, formula, manualMax, manualMin, lineWeight, typeIndex, dateAxis, displayEmptyCellsAs, markers, high, low, first, last, negative, displayXAxis, displayHidden, minAxisType, maxAxisType, rightToLeft)

Parameters

sheetIndex: Index of the sheet.
colorSeries: The color series.
colorNegative: The color negative.
colorAxis: The color axis.
colorMarkers: The color markers.
colorFirst: The color first.
colorLast: The color last.
colorHigh: The color high.
colorLow: The color low.
formula: The formula.
manualMax: The manual max.
manualMin: The manual min.
lineWeight: The line weight.
typeIndex: Index of the type.
dateAxis: if set to true [date axis].
displayEmptyCellsAs: The display empty cells as.
markers: if set to true [markers].
high: if set to true [high].
low: if set to true [low].
first: if set to true [first].
last: if set to true [last].
negative: if set to true [negative].
displayXAxis: if set to true [display X axis].
displayHidden: if set to true [display hidden].
minAxisType: Type of the min axis.
maxAxisType: Type of the max axis.
rightToLeft: if set to true [right to left].

Reference

IExcelXml3 Interface
IExcelXml3 Members

Product Support Forum | Print this page