ItemsFormula Property (SpreadChart)

Gets or sets the items formula. This action will re-build the chart's axis items.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ItemsFormula As System.String

'Usage
 
Dim instance As SpreadChart
Dim value As System.String
 
instance.ItemsFormula = value
 
value = instance.ItemsFormula

public System.string ItemsFormula {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 ItemsFormula 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.Windows.SpreadSheet.Data.SpreadChart chart = GcSpreadSheet1.ActiveSheet.AddChart("Chart", GrapeCity.Windows.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";

VB.NET

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.Windows.SpreadSheet.Data.SpreadChart = GcSpreadSheet1.ActiveSheet.AddChart("Chart", GrapeCity.Windows.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"

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SpreadChart Class
SpreadChart Members