Version

SparklineGroup Class Members

The following tables list the members exposed by SparklineGroup.

Public Properties
 NameDescription
Public PropertyColorAxisDetermines the color of the axis  
Public PropertyColorFirstPointDetermines the color of the first point  
Public PropertyColorHighPointDetermines the color of the high point  
Public PropertyColorLastPointDetermines the color of the last point  
Public PropertyColorLowPointDetermines the color of the low point  
Public PropertyColorMarkersDetermines the color of the markers  
Public PropertyColorNegativePointsDetermines the color of the negative point  
Public PropertyColorSeriesDetermines the default color for the series  
Public PropertyDateAxisDetermines whether to use a date axis  
Public PropertyDateRangeThe date range (read-only)  
Public PropertyDateRangeFormulaThe date range formula (read-only)  
Public PropertyDisplayBlanksAsDetermines how blanks will be displayed  
Public PropertyDisplayHiddenDetermines whether values from cells that are hidden will be displayed  
Public PropertyDisplayXAxisDetermines if the x-axis will be displayed  
Public PropertyFirstPointDetermines if the first point is displayed differently.  
Public PropertyGuidA unique identifier for this group (read-only).  
Public PropertyHighPointDetermines if the high point is displayed differently.  
Public PropertyLastPointDetermines if the last point is displayed differently.  
Public PropertyLineWeightDetermines the weight of a line in points.  
Public PropertyLowPointDetermines if the low point is displayed differently.  
Public PropertyMarkersDetermines if markers are displayed.  
Public PropertyNegativePointsDetermines if the negative points are displayed differently.  
Public PropertyRightToLeftDetermines if the sparkline goes from right to left.  
Public PropertySparklinesThe collection of sparklines in the group (read-only)  
Public PropertyTypeThe type of sparkline  
Public PropertyVerticalAxisMaxA custom maximum value for the Y axis.  
Public PropertyVerticalAxisMaxTypeDetermines how the maximum value for the Y axis is calculated.  
Public PropertyVerticalAxisMinA custom minimum value for the Y axis.  
Public PropertyVerticalAxisMinTypeDetermines how the minimum value for the Y axis is calculated.  
Public PropertyWorkbookReturns a reference to the associated workbook.  
Public PropertyWorksheetReturns a reference to the associated worksheet.  
Public Methods
 NameDescription
Public MethodSetDateRangeAssigns a new DateRange.  
See Also

View on GitHub