Edit

Share via


SparklineGroup.Location Property

Definition

Gets or sets the Range object that represents the location of the sparkline group.

public:
 property Microsoft::Office::Interop::Excel::Range ^ Location { Microsoft::Office::Interop::Excel::Range ^ get(); void set(Microsoft::Office::Interop::Excel::Range ^ value); };
public Microsoft.Office.Interop.Excel.Range Location { get; set; }
Public Property Location As Range

Property Value

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 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 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.

Applies to