GrapeCity.Xaml.SpreadSheet.Data
AxisColor Property (SparklineSetting)
Example 


Gets or sets the color of the axis.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property AxisColor As Color
'Usage
 
Dim instance As SparklineSetting
Dim value As Color
 
instance.AxisColor = value
 
value = instance.AxisColor
[DefaultValue()]
public Color AxisColor {get; set;}

Property Value

The color of the axis.
Example
This example sets the AxisColor property.
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 1, 3);
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr2 = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 3);
GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting();
ex.AxisColor = Windows.UI.Colors.CadetBlue;
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = Convert.ToDateTime("1/2/2011");
gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = Convert.ToDateTime("1/3/2011");
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = Convert.ToDateTime("1/5/2011");
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 2;
gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 11;
gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = 4;
gcSpreadSheet1.Sheets[0].Cells[0, 0, 0, 2].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("M/dd/yyyy");
gcSpreadSheet1.Sheets[0].SetSparkline(1, 4, cellr2, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, ex);    
Dim cellr As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 1, 3)
Dim cellr2 As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(1, 0, 1, 3)
Dim ex As New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting()
ex.AxisColor = Windows.UI.Colors.CadetBlue
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = Convert.ToDateTime("1/2/2011")
GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = Convert.ToDateTime("1/3/2011")
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = Convert.ToDateTime("1/5/2011")
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 2
GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 11
GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = 4
GcSpreadSheet1.Sheets(0).Cells(0, 0, 0, 2).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("M/dd/yyyy")
GcSpreadSheet1.Sheets(0).SetSparkline(1, 4, cellr2, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, ex)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SparklineSetting Class
SparklineSetting Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options