public string Title {get; set;}

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);