GrapeCity.Xaml.SpreadSheet.Data
NameFormula Property (SpreadChart)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > SpreadChart Class : NameFormula Property
Gets or sets the series name formula.
Syntax
'Declaration
 
Public Property NameFormula As String
'Usage
 
Dim instance As SpreadChart
Dim value As String
 
instance.NameFormula = value
 
value = instance.NameFormula
public string NameFormula {get; set;}

Property Value

This property is not designed for persisting so you should save and re-use the value and access infrequently.
Example
This example uses the NameFormula property.
object[,] values = {{"","Dep1","Dep2","Dep3","Dep4"},
                               {"a",12,13,14,15},
                               {"b",20,15,25,16},
                               {"c",4,9,5,11},
                               {"d",15,10,18,12},
                               {"d",17,6,14,11}};
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, values);
GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = GcSpreadSheet1.ActiveSheet.AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnClustered, 0, 0, 400, 400);
chart.ItemsFormula = "Sheet1!$A$2:$A$6";
chart.NameFormula = "Sheet1!$B$1:$E$1";
chart.DataFormula = "Sheet1!$B$2:$E$6";
Dim values As Object(,) = {{"", "Dep1", "Dep2", "Dep3", "Dep4"}, {"a", 12, 13, 14, 15}, {"b", 20, 15, 25, 16}, {"c", 4, 9, 5, 11}, {"d", 15, 10, 18, 12}, {"d", 17, 6, 14, 11}}
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, values)
Dim chart As GrapeCity.Xaml.SpreadSheet.Data.SpreadChart = GcSpreadSheet1.ActiveSheet.AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnClustered, 0, 0, 400, 400)
chart.ItemsFormula = "Sheet1!$A$2:$A$6"
chart.NameFormula = "Sheet1!$B$1:$E$1"
chart.DataFormula = "Sheet1!$B$2:$E$6"
See Also

Reference

SpreadChart Class
SpreadChart Members