A box whisker chart displays the distribution of data into quartiles. The boxes may also have lines extending vertically (whiskers). The lines indicate variability outside the upper and lower quartiles. A point outside the whisker is an outlier point. Box whisker charts are commonly used in statistical analysis.
You can use the BoxWhiskerSeries, the ClusteredBoxWhiskerSeries, and the YPlotArea classes to create a box whisker chart with multiple series as shown in the following image.
For information about creating charts in the Spread Designer or the Chart Designer, refer to Using the Chart Control on sheet or Adding a Chart Control.
This example creates a box whisker chart.
| C# |
Copy Code
|
|---|---|
| fpSpread1.ActiveSheet.Cells[0, 1].Text = "Cheese"; fpSpread1.ActiveSheet.Cells[0, 2].Text = "Store1"; fpSpread1.ActiveSheet.Cells[0, 3].Text = "Store2"; fpSpread1.ActiveSheet.Cells[0, 4].Text = "Store3"; fpSpread1.ActiveSheet.Cells[1, 1].Text = "Asiago"; fpSpread1.ActiveSheet.Cells[2, 1].Text = "Gouda"; fpSpread1.ActiveSheet.Cells[3, 1].Text = "Havarti"; fpSpread1.ActiveSheet.Cells[4, 1].Text = "Swiss"; fpSpread1.ActiveSheet.Cells[5, 1].Text = "Asiago"; fpSpread1.ActiveSheet.Cells[6, 1].Text = "Gouda"; fpSpread1.ActiveSheet.Cells[7, 1].Text = "Havarti"; fpSpread1.ActiveSheet.Cells[8, 1].Text = "Swiss"; fpSpread1.ActiveSheet.Cells[9, 1].Text = "Asiago"; fpSpread1.ActiveSheet.Cells[10, 1].Text = "Gouda"; fpSpread1.ActiveSheet.Cells[11, 1].Text = "Havarti"; fpSpread1.ActiveSheet.Cells[12, 1].Text = "Swiss"; fpSpread1.ActiveSheet.Cells[1, 2].Value = 20; fpSpread1.ActiveSheet.Cells[2, 2].Value = 25; fpSpread1.ActiveSheet.Cells[3, 2].Value = 21; fpSpread1.ActiveSheet.Cells[4, 2].Value = 30; fpSpread1.ActiveSheet.Cells[5, 2].Value = 10; fpSpread1.ActiveSheet.Cells[6, 2].Value = 26; fpSpread1.ActiveSheet.Cells[7, 2].Value = 18; fpSpread1.ActiveSheet.Cells[8, 2].Value = 28; fpSpread1.ActiveSheet.Cells[9, 2].Value = 12; fpSpread1.ActiveSheet.Cells[10, 2].Value = 20; fpSpread1.ActiveSheet.Cells[11, 2].Value = 17; fpSpread1.ActiveSheet.Cells[12, 2].Value = 35; fpSpread1.ActiveSheet.Cells[1, 3].Value = 15; fpSpread1.ActiveSheet.Cells[2, 3].Value = 18; fpSpread1.ActiveSheet.Cells[3, 3].Value = 19; fpSpread1.ActiveSheet.Cells[4, 3].Value = 22; fpSpread1.ActiveSheet.Cells[5, 3].Value = 10; fpSpread1.ActiveSheet.Cells[6, 3].Value = 19; fpSpread1.ActiveSheet.Cells[7, 3].Value = 15; fpSpread1.ActiveSheet.Cells[8, 3].Value = 25; fpSpread1.ActiveSheet.Cells[9, 3].Value = 14; fpSpread1.ActiveSheet.Cells[10, 3].Value = 19; fpSpread1.ActiveSheet.Cells[11, 3].Value = 16; fpSpread1.ActiveSheet.Cells[12, 3].Value = 24; fpSpread1.ActiveSheet.Cells[1, 4].Value = 5; fpSpread1.ActiveSheet.Cells[2, 4].Value = 12; fpSpread1.ActiveSheet.Cells[3, 4].Value = 20; fpSpread1.ActiveSheet.Cells[4, 4].Value = 25; fpSpread1.ActiveSheet.Cells[5, 4].Value = 8; fpSpread1.ActiveSheet.Cells[6, 4].Value = 10; fpSpread1.ActiveSheet.Cells[7, 4].Value = 11; fpSpread1.ActiveSheet.Cells[8, 4].Value = 22; fpSpread1.ActiveSheet.Cells[9, 4].Value = 13; fpSpread1.ActiveSheet.Cells[10, 4].Value = 12; fpSpread1.ActiveSheet.Cells[11, 4].Value = 15; fpSpread1.ActiveSheet.Cells[12, 4].Value = 21; fpSpread1.ActiveSheet.AddChart(new FarPoint.Win.Spread.Model.CellRange(0, 1, 13, 4), typeof(FarPoint.Win.Chart.ClusteredBoxWhiskerSeries), 550, 450, 300, 0); FarPoint.Win.Chart.ClusteredBoxWhiskerSeries cboxseries = (FarPoint.Win.Chart.ClusteredBoxWhiskerSeries)fpSpread1.Sheets[0].Charts[0].Model.PlotAreas[0].Series[0]; foreach(FarPoint.Win.Chart.BoxWhiskerSeries boxseries in cboxseries.Series) { boxseries.ShowInnerPoints = true; boxseries.ShowMeanLine = true; boxseries.ShowMeanMarkers = true; boxseries.ShowOutlierPoints = true; } |
|
| VB |
Copy Code
|
|---|---|
| fpSpread1.ActiveSheet.Cells(0, 1).Text = "Cheese" fpSpread1.ActiveSheet.Cells(0, 2).Text = "Store1" fpSpread1.ActiveSheet.Cells(0, 3).Text = "Store2" fpSpread1.ActiveSheet.Cells(0, 4).Text = "Store3" fpSpread1.ActiveSheet.Cells(1, 1).Text = "Asiago" fpSpread1.ActiveSheet.Cells(2, 1).Text = "Gouda" fpSpread1.ActiveSheet.Cells(3, 1).Text = "Havarti" fpSpread1.ActiveSheet.Cells(4, 1).Text = "Swiss" fpSpread1.ActiveSheet.Cells(5, 1).Text = "Asiago" fpSpread1.ActiveSheet.Cells(6, 1).Text = "Gouda" fpSpread1.ActiveSheet.Cells(7, 1).Text = "Havarti" fpSpread1.ActiveSheet.Cells(8, 1).Text = "Swiss" fpSpread1.ActiveSheet.Cells(9, 1).Text = "Asiago" fpSpread1.ActiveSheet.Cells(10, 1).Text = "Gouda" fpSpread1.ActiveSheet.Cells(11, 1).Text = "Havarti" fpSpread1.ActiveSheet.Cells(12, 1).Text = "Swiss" fpSpread1.ActiveSheet.Cells(1, 2).Value = 20 fpSpread1.ActiveSheet.Cells(2, 2).Value = 25 fpSpread1.ActiveSheet.Cells(3, 2).Value = 21 fpSpread1.ActiveSheet.Cells(4, 2).Value = 30 fpSpread1.ActiveSheet.Cells(5, 2).Value = 10 fpSpread1.ActiveSheet.Cells(6, 2).Value = 26 fpSpread1.ActiveSheet.Cells(7, 2).Value = 18 fpSpread1.ActiveSheet.Cells(8, 2).Value = 28 fpSpread1.ActiveSheet.Cells(9, 2).Value = 12 fpSpread1.ActiveSheet.Cells(10, 2).Value = 20 fpSpread1.ActiveSheet.Cells(11, 2).Value = 17 fpSpread1.ActiveSheet.Cells(12, 2).Value = 35 fpSpread1.ActiveSheet.Cells(1, 3).Value = 15 fpSpread1.ActiveSheet.Cells(2, 3).Value = 18 fpSpread1.ActiveSheet.Cells(3, 3).Value = 19 fpSpread1.ActiveSheet.Cells(4, 3).Value = 22 fpSpread1.ActiveSheet.Cells(5, 3).Value = 10 fpSpread1.ActiveSheet.Cells(6, 3).Value = 19 fpSpread1.ActiveSheet.Cells(7, 3).Value = 15 fpSpread1.ActiveSheet.Cells(8, 3).Value = 25 fpSpread1.ActiveSheet.Cells(9, 3).Value = 14 fpSpread1.ActiveSheet.Cells(10, 3).Value = 19 fpSpread1.ActiveSheet.Cells(11, 3).Value = 16 fpSpread1.ActiveSheet.Cells(12, 3).Value = 24 fpSpread1.ActiveSheet.Cells(1, 4).Value = 5 fpSpread1.ActiveSheet.Cells(2, 4).Value = 12 fpSpread1.ActiveSheet.Cells(3, 4).Value = 20 fpSpread1.ActiveSheet.Cells(4, 4).Value = 25 fpSpread1.ActiveSheet.Cells(5, 4).Value = 8 fpSpread1.ActiveSheet.Cells(6, 4).Value = 10 fpSpread1.ActiveSheet.Cells(7, 4).Value = 11 fpSpread1.ActiveSheet.Cells(8, 4).Value = 22 fpSpread1.ActiveSheet.Cells(9, 4).Value = 13 fpSpread1.ActiveSheet.Cells(10, 4).Value = 12 fpSpread1.ActiveSheet.Cells(11, 4).Value = 15 fpSpread1.ActiveSheet.Cells(12, 4).Value = 21 fpSpread1.ActiveSheet.AddChart(New FarPoint.Win.Spread.Model.CellRange(0, 1, 13, 4), GetType(FarPoint.Win.Chart.ClusteredBoxWhiskerSeries), 550, 450, 300, 0) Dim cboxseries As FarPoint.Win.Chart.ClusteredBoxWhiskerSeries = DirectCast(fpSpread1.Sheets(0).Charts(0).Model.PlotAreas(0).Series(0), FarPoint.Win.Chart.ClusteredBoxWhiskerSeries) For Each boxseries As FarPoint.Win.Chart.BoxWhiskerSeries In cboxseries.Series boxseries.ShowInnerPoints = True boxseries.ShowMeanLine = True boxseries.ShowMeanMarkers = True boxseries.ShowOutlierPoints = True Next |
|
