Title Property (ValueAxis)

Gets or sets the title.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Title As String

'Usage
 
Dim instance As ValueAxis
Dim value As String
 
instance.Title = value
 
value = instance.Title

public string Title {get; set;}

Exceptions

Exception	Description
System.ArgumentNullException	value is a null reference (Nothing in VB).

Example

This example creates a chart and sets titles for the axis.

fpSpread1.Sheets[0].Cells[0, 0].Text = "Name";
fpSpread1.Sheets[0].Cells[0, 1].Text = "Math";
fpSpread1.Sheets[0].Cells[0, 2].Text = "LA";
fpSpread1.Sheets[0].Cells[0, 3].Text = "Science";
fpSpread1.Sheets[0].Cells[1, 0].Text = "Steve";
fpSpread1.Sheets[0].Cells[1, 1].Text = "85";
fpSpread1.Sheets[0].Cells[1, 2].Text = "91";
fpSpread1.Sheets[0].Cells[1, 3].Text = "94";
fpSpread1.Sheets[0].Cells[2, 0].Text = "Lisa";
fpSpread1.Sheets[0].Cells[2, 1].Text = "95";
fpSpread1.Sheets[0].Cells[2, 2].Text = "76";
fpSpread1.Sheets[0].Cells[2, 3].Text = "73";
fpSpread1.Sheets[0].Cells[3, 0].Text = "Mark";
fpSpread1.Sheets[0].Cells[3, 1].Text = "79";
fpSpread1.Sheets[0].Cells[3, 2].Text = "83";
fpSpread1.Sheets[0].Cells[3, 3].Text = "77";
fpSpread1.Sheets[0].Cells[4, 0].Text = "Tony";
fpSpread1.Sheets[0].Cells[4, 1].Text = "91";
fpSpread1.Sheets[0].Cells[4, 2].Text = "76";
fpSpread1.Sheets[0].Cells[4, 3].Text = "73";
fpSpread1.Sheets[0].Cells[5, 0].Text = "Julie";
fpSpread1.Sheets[0].Cells[5, 1].Text = "75";
fpSpread1.Sheets[0].Cells[5, 2].Text = "86";
fpSpread1.Sheets[0].Cells[5, 3].Text = "83";

FarPoint.Win.Chart.BarSeries s1 = new FarPoint.Win.Chart.BarSeries();
s1.SeriesName = fpSpread1.Sheets[0].Cells[0, 1].Value.ToString();
s1.Values.DataSource = new FarPoint.Win.Spread.Chart.SeriesDataField(fpSpread1, "c1", "Sheet1!$B$2:$B$6");
FarPoint.Win.Chart.BarSeries s2 = new FarPoint.Win.Chart.BarSeries();
s2.SeriesName = fpSpread1.Sheets[0].Cells[0, 2].Value.ToString();
s2.Values.DataSource = new FarPoint.Win.Spread.Chart.SeriesDataField(fpSpread1, "c2", "Sheet1!$C$2:$C$6");
FarPoint.Win.Chart.BarSeries s3 = new FarPoint.Win.Chart.BarSeries();
s3.SeriesName = fpSpread1.Sheets[0].Cells[0, 3].Value.ToString();
s3.Values.DataSource = new FarPoint.Win.Spread.Chart.SeriesDataField(fpSpread1, "c3", "Sheet1!$D$2:$D$6");

s1.CategoryNames.Add(fpSpread1.ActiveSheet.Cells[1, 0].Text);
s1.CategoryNames.Add(fpSpread1.ActiveSheet.Cells[2, 0].Text);
s1.CategoryNames.Add(fpSpread1.ActiveSheet.Cells[3, 0].Text);
s1.CategoryNames.Add(fpSpread1.ActiveSheet.Cells[4, 0].Text);
s1.CategoryNames.Add(fpSpread1.ActiveSheet.Cells[5, 0].Text);

FarPoint.Win.Chart.ClusteredBarSeries ss1 = new FarPoint.Win.Chart.ClusteredBarSeries();
ss1.Series.Add(s1);
ss1.Series.Add(s2);
ss1.Series.Add(s3);
FarPoint.Win.Chart.YPlotArea yplotarea1 = new FarPoint.Win.Chart.YPlotArea();
yplotarea1.Series.Add(ss1);
yplotarea1.Vertical = false;
yplotarea1.XAxis.Title = "Name";
yplotarea1.YAxes[0].Title = "Score";

FarPoint.Win.Chart.LabelArea label1 = new FarPoint.Win.Chart.LabelArea();
label1.Text = "Test Score";
label1.Location = new PointF(0.5f, 0.02f);
label1.AlignmentX = 0.5f;
label1.AlignmentY = 0.0f;
FarPoint.Win.Chart.LegendArea legend1 = new FarPoint.Win.Chart.LegendArea();
legend1.Location = new PointF(0.98f, 0.5f);
legend1.AlignmentX = 1.0f;
legend1.AlignmentY = 0.5f;

FarPoint.Win.Spread.Chart.SpreadChart chart1 = new FarPoint.Win.Spread.Chart.SpreadChart();
chart1.Model.PlotAreas.Add(yplotarea1);
chart1.Model.LabelAreas.Add(label1);
chart1.Model.LegendAreas.Add(legend1);
chart1.Rectangle = new System.Drawing.Rectangle(150, 150, 150, 150);
chart1.Size = new System.Drawing.Size(700, 350);
fpSpread1.Sheets[0].Charts.Add(chart1);

Visual Basic

FpSpread1.Sheets(0).Cells(0, 0).Text = "Name"
FpSpread1.Sheets(0).Cells(0, 1).Text = "Math"
FpSpread1.Sheets(0).Cells(0, 2).Text = "LA"
FpSpread1.Sheets(0).Cells(0, 3).Text = "Science"
FpSpread1.Sheets(0).Cells(1, 0).Text = "Steve"
FpSpread1.Sheets(0).Cells(1, 1).Text = "85"
FpSpread1.Sheets(0).Cells(1, 2).Text = "91"
FpSpread1.Sheets(0).Cells(1, 3).Text = "94"
FpSpread1.Sheets(0).Cells(2, 0).Text = "Lisa"
FpSpread1.Sheets(0).Cells(2, 1).Text = "95"
FpSpread1.Sheets(0).Cells(2, 2).Text = "76"
FpSpread1.Sheets(0).Cells(2, 3).Text = "73"
FpSpread1.Sheets(0).Cells(3, 0).Text = "Mark"
FpSpread1.Sheets(0).Cells(3, 1).Text = "79"
FpSpread1.Sheets(0).Cells(3, 2).Text = "83"
FpSpread1.Sheets(0).Cells(3, 3).Text = "77"
FpSpread1.Sheets(0).Cells(4, 0).Text = "Tony"
FpSpread1.Sheets(0).Cells(4, 1).Text = "91"
FpSpread1.Sheets(0).Cells(4, 2).Text = "76"
FpSpread1.Sheets(0).Cells(4, 3).Text = "73"
FpSpread1.Sheets(0).Cells(5, 0).Text = "Julie"
FpSpread1.Sheets(0).Cells(5, 1).Text = "75"
FpSpread1.Sheets(0).Cells(5, 2).Text = "86"
FpSpread1.Sheets(0).Cells(5, 3).Text = "83"

Dim s1 As New FarPoint.Win.Chart.BarSeries()
s1.SeriesName = FpSpread1.Sheets(0).Cells(0, 1).Value.ToString()
s1.Values.DataSource = New FarPoint.Win.Spread.Chart.SeriesDataField(FpSpread1, "c1", "Sheet1!$B$2:$B$6")
Dim s2 As New FarPoint.Win.Chart.BarSeries()
s2.SeriesName = FpSpread1.Sheets(0).Cells(0, 2).Value.ToString()
s2.Values.DataSource = New FarPoint.Win.Spread.Chart.SeriesDataField(FpSpread1, "c2", "Sheet1!$C$2:$C$6")
Dim s3 As New FarPoint.Win.Chart.BarSeries()
s3.SeriesName = FpSpread1.Sheets(0).Cells(0, 3).Value.ToString()
s3.Values.DataSource = New FarPoint.Win.Spread.Chart.SeriesDataField(FpSpread1, "c3", "Sheet1!$D$2:$D$6")

s1.CategoryNames.Add(FpSpread1.ActiveSheet.Cells(1, 0).Text)
s1.CategoryNames.Add(FpSpread1.ActiveSheet.Cells(2, 0).Text)
s1.CategoryNames.Add(FpSpread1.ActiveSheet.Cells(3, 0).Text)
s1.CategoryNames.Add(FpSpread1.ActiveSheet.Cells(4, 0).Text)
s1.CategoryNames.Add(FpSpread1.ActiveSheet.Cells(5, 0).Text)

Dim ss1 As New FarPoint.Win.Chart.ClusteredBarSeries()
ss1.Series.Add(s1)
ss1.Series.Add(s2)
ss1.Series.Add(s3)
Dim yplotarea1 As New FarPoint.Win.Chart.YPlotArea()
yplotarea1.Series.Add(ss1)
yplotarea1.Vertical = False
yplotarea1.XAxis.Title = "Name"
yplotarea1.YAxes(0).Title = "Score"

Dim label1 As New FarPoint.Win.Chart.LabelArea()
label1.Text = "Test Score"
label1.Location = New PointF(0.5F, 0.02F)
label1.AlignmentX = 0.5F
label1.AlignmentY = 0.0F
Dim legend1 As New FarPoint.Win.Chart.LegendArea()
legend1.Location = New PointF(0.98F, 0.5F)
legend1.AlignmentX = 1.0F
legend1.AlignmentY = 0.5F

Dim chart1 As New FarPoint.Win.Spread.Chart.SpreadChart()
chart1.Model.PlotAreas.Add(yplotarea1)
chart1.Model.LabelAreas.Add(label1)
chart1.Model.LegendAreas.Add(legend1)
chart1.Rectangle = New System.Drawing.Rectangle(150, 150, 150, 150)
chart1.Size = New System.Drawing.Size(700, 350)
FpSpread1.Sheets(0).Charts.Add(chart1)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ValueAxis Class
ValueAxis Members