SparklineGroup.Location Property
Gets or sets the Range object that represents the location of the sparkline group.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Location As Range
Get
Set
'Usage
Dim instance As SparklineGroup
Dim value As Range
value = instance.Location
instance.Location = value
Range Location { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.Range
The Range object that represents the location of the sparkline group.
Remarks
Read/write.
The location for all sparklines in a sparkline group must be on the same sheet, but the source data for the sparkline group can be on a different sheet or workbook.
The size of the range that represents the Location property must equal the number of rows or columns in the SourceData property for the SparklineGroup object.
A continuous range associated with a sparkline group can only be one dimensional. If the range is not continuous, each cell must be specified individually.
Note
Do not use the [M:Microsoft.Office.Interop.Excel._Application.Union(Microsoft.Office.Interop.Excel.Range,Microsoft.Office.Interop.Excel.Range,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object] method to create a non-continuous range because the [M:Microsoft.Office.Interop.Excel._Application.Union(Microsoft.Office.Interop.Excel.Range,Microsoft.Office.Interop.Excel.Range,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object,System.Object] method returns a single range reference.