private void PrepareOptions()
{
var valuesX = new List<double?>() { 161.4, 169.0, 166.2, 159.4, 162.5, 159.0, 162.8, 159.0, 179.8, 162.9, 161.0, 151.1, 168.2, 168.9, 173.2, 174.0, 162.6, 174.0, 162.6, 161.3, 156.2, 149.9, 169.5, 160.0, 175.3, 169.5, 160.0, 172.7, 162.6, 157.5, 176.5, 164.4, 160.7, 174.0, 163.8 };
var valuesY = new List<double?>() { 63.4, 58.2, 58.6, 45.7, 52.2, 48.6, 57.8, 55.6, 66.8, 59.4, 53.6, 73.2, 53.4, 69.0, 58.4, 73.6, 61.4, 55.5, 63.6, 60.9, 60.0, 46.8, 57.3, 64.1, 63.6, 67.3, 75.5, 68.2, 61.4, 76.8, 71.8, 55.5, 48.6, 66.4, 67.3 };
//serieslist Female
var series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Circle;
series.Data.X.AddRange(valuesX.ToArray<double?>());
series.Data.Y.AddRange(valuesY.ToArray<double?>());
series.Label = "Female";
series.LegendEntry = true;
series.Visible = true;
//series Male
valuesX = new List<double?>() { 175.0, 174.0, 165.1, 177.0, 192.0, 176.5, 169.4, 182.1, 179.8, 175.3, 184.9, 177.3, 167.4, 178.1, 168.9, 174.0, 167.6, 170.2, 167.6, 188.0, 174.0, 176.5, 180.3, 167.6, 188.0, 180.3, 167.6, 183.0, 183.0, 179.1, 170.2, 177.8, 179.1, 190.5, 177.8, 180.3, 180.3 };
valuesY = new List<double?>() { 70.2, 73.4, 70.5, 68.9, 102.3, 68.4, 65.9, 75.7, 84.5, 87.7, 86.4, 73.2, 53.9, 72.0, 55.5, 70.9, 64.5, 77.3, 72.3, 87.3, 80.0, 82.3, 73.6, 74.1, 85.9, 73.2, 76.3, 65.9, 90.9, 89.1, 62.3, 82.7, 79.1, 98.2, 84.1, 83.2, 83.2 };
series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Diamond;
series.Data.X.AddRange(valuesX.ToArray<double?>());
series.Data.Y.AddRange(valuesY.ToArray<double?>());
series.Label = "Male";
series.LegendEntry = true;
series.Visible = true;
}
private void PrepareOptions()
{
var valuesX = new List<double?>() { 569.99, 329.00, 302.27, 309.99, 289.99, 293.71, 370.33, 339.99, 382.64,
399.99, 219.99, 219.99, 208.88, 189.29, 199.99, 288.42, 227.00, 280.39,
177.97, 202.99, 312.00, 186.13, 379.95, 399.00, 249.99, 285.00 };
var valuesY = new List<double?>() { 12095, 10141, 9972, 9578, 9421, 9003, 8875, 8467, 8310, 7528, 7509, 7108,
6992, 6577, 6450, 6370, 6234, 5972, 5889, 5787, 5683, 5681, 5456,
5181, 5099, 5023 };
//serieslist Intel
var series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Circle;
series.Data.X.AddRange(valuesX.ToArray<double?>());
series.Data.Y.AddRange(valuesY.ToArray<double?>());
series.Label = "Intel";
series.LegendEntry = true;
series.Visible = true;
//series AMD
valuesX = new List<double?>() {199.99, 159.99, 149.79, 139.99, 114.99, 459.00, 119.99, 170.00, 299.00, 109.99, 125.00, 109.98,
215.00, 179.99, 249.95, 59.98};
valuesY = new List<double?>() { 9081, 8130, 7727, 6602, 6406, 5711, 5420, 5055, 4912, 4693, 4286, 4057, 4017,
3740, 3359, 1741};
series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Diamond;
series.Data.X.AddRange(valuesX.ToArray<double?>());
series.Data.Y.AddRange(valuesY.ToArray<double?>());
series.Label = "AMD";
series.LegendEntry = true;
series.Visible = true;
}
private void PrepareOptions()
{
var valuesX = new List <double?>()
{
569.99, 329.00, 302.27, 309.99, 289.99, 293.71, 370.33, 339.99, 382.64,
399.99, 219.99, 219.99, 208.88, 189.29, 199.99, 288.42, 227.00, 280.39,
177.97, 202.99, 312.00, 186.13, 379.95, 399.00, 249.99, 285.00
};
var valuesY = new List <double?>()
{
12095, 10141, 9972, 9578, 9421, 9003, 8875, 8467, 8310, 7528, 7509, 7108,
6992, 6577, 6450, 6370, 6234, 5972, 5889, 5787, 5683, 5681, 5456,
5181, 5099, 5023
};
//serieslist Intel
var series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Circle;
series.Data.X.AddRange(valuesX.ToArray <double?>());
series.Data.Y.AddRange(valuesY.ToArray <double?>());
series.Label = "Intel";
series.LegendEntry = true;
series.Visible = true;
//series AMD
valuesX = new List <double?>()
{
199.99, 159.99, 149.79, 139.99, 114.99, 459.00, 119.99, 170.00, 299.00, 109.99, 125.00, 109.98,
215.00, 179.99, 249.95, 59.98
};
valuesY = new List <double?>()
{
9081, 8130, 7727, 6602, 6406, 5711, 5420, 5055, 4912, 4693, 4286, 4057, 4017,
3740, 3359, 1741
};
series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Diamond;
series.Data.X.AddRange(valuesX.ToArray <double?>());
series.Data.Y.AddRange(valuesY.ToArray <double?>());
series.Label = "AMD";
series.LegendEntry = true;
series.Visible = true;
}
/// <summary>
/// Updates the chart.
/// </summary>
/// <param name="chart">The chart.</param>
/// <param name="sheetName">Name of the sheet.</param>
protected override void UpdateChart(OpenXmlCompositeElement chart, string sheetName)
{
if (chart != null)
{
chart.RemoveAllChildren <ScatterChartSeries>();
ScatterChartSeries scatterChartSeries = chart.AppendChild <ScatterChartSeries>(new ScatterChartSeries());
Outline outline = new Outline()
{
Width = 28575
};
NoFill noFill = new NoFill();
outline.Append(noFill);
scatterChartSeries.ChartShapeProperties = new ChartShapeProperties(outline);
UpdateSeriesText(sheetName, scatterChartSeries, "B", 1, chartData.yColumnName);
XValues xValues = scatterChartSeries.AppendChild <XValues>(new XValues());
YValues yValues = scatterChartSeries.AppendChild <YValues>(new YValues());
NumberReference referenceX = CreateNumberReference(xValues, sheetName + "!$A$2:$A$" + (chartData.Count + 1).ToString());
NumberReference referenceY = CreateNumberReference(yValues, sheetName + "!$B$2:$B$" + (chartData.Count + 1).ToString());
NumberingCache ncX;
PointCount ptXCount;
NumberingCache ncY;
PointCount ptYCount;
SetNumberingCache(referenceX, out ncX, out ptXCount);
SetNumberingCache(referenceY, out ncY, out ptYCount);
int rowIndex = 0;
foreach (var xToY in chartData.xValToYValMap)
{
AddNumericPoint(ncX, ptXCount, rowIndex, xToY.Key.ToString());
AddNumericPoint(ncY, ptYCount, rowIndex, xToY.Value.ToString());
rowIndex += 1;
}
}
}
private void PrepareOptions()
{
var valuesX = new List <double?>()
{
161.4, 169.0, 166.2, 159.4, 162.5, 159.0, 162.8, 159.0, 179.8, 162.9, 161.0, 151.1, 168.2, 168.9, 173.2, 174.0, 162.6, 174.0, 162.6, 161.3, 156.2, 149.9, 169.5, 160.0, 175.3, 169.5, 160.0, 172.7, 162.6, 157.5, 176.5, 164.4, 160.7, 174.0, 163.8
};
var valuesY = new List <double?>()
{
63.4, 58.2, 58.6, 45.7, 52.2, 48.6, 57.8, 55.6, 66.8, 59.4, 53.6, 73.2, 53.4, 69.0, 58.4, 73.6, 61.4, 55.5, 63.6, 60.9, 60.0, 46.8, 57.3, 64.1, 63.6, 67.3, 75.5, 68.2, 61.4, 76.8, 71.8, 55.5, 48.6, 66.4, 67.3
};
//serieslist Female
var series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Circle;
series.Data.X.AddRange(valuesX.ToArray <double?>());
series.Data.Y.AddRange(valuesY.ToArray <double?>());
series.Label = "Female";
series.LegendEntry = true;
series.Visible = true;
//series Male
valuesX = new List <double?>()
{
175.0, 174.0, 165.1, 177.0, 192.0, 176.5, 169.4, 182.1, 179.8, 175.3, 184.9, 177.3, 167.4, 178.1, 168.9, 174.0, 167.6, 170.2, 167.6, 188.0, 174.0, 176.5, 180.3, 167.6, 188.0, 180.3, 167.6, 183.0, 183.0, 179.1, 170.2, 177.8, 179.1, 190.5, 177.8, 180.3, 180.3
};
valuesY = new List <double?>()
{
70.2, 73.4, 70.5, 68.9, 102.3, 68.4, 65.9, 75.7, 84.5, 87.7, 86.4, 73.2, 53.9, 72.0, 55.5, 70.9, 64.5, 77.3, 72.3, 87.3, 80.0, 82.3, 73.6, 74.1, 85.9, 73.2, 76.3, 65.9, 90.9, 89.1, 62.3, 82.7, 79.1, 98.2, 84.1, 83.2, 83.2
};
series = new ScatterChartSeries();
this.C1ScatterChart1.SeriesList.Add(series);
series.MarkerType = MarkerType.Diamond;
series.Data.X.AddRange(valuesX.ToArray <double?>());
series.Data.Y.AddRange(valuesY.ToArray <double?>());
series.Label = "Male";
series.LegendEntry = true;
series.Visible = true;
}
private void PrepareOptions()
{
var coordinates = new []{
new {Latitude= -6.6003, Longitude= 154.8109 },
new{ Latitude= 18.6364, Longitude= 145.2596 },
new { Latitude= 77.1576, Longitude= 59.5431 },
new{ Latitude= -16.0907, Longitude= 168.417 },
new{ Latitude= -37.4779, Longitude= -73.7132 },
new{ Latitude= -22.3357, Longitude= 171.5891 },
new{ Latitude= -1.7906, Longitude= 138.6322 },
new { Latitude= 13.9832, Longitude= -92.0492 },
new { Latitude= 62.0401, Longitude= -150.5026 },
new { Latitude= 31.747, Longitude= 76.0954 },
new { Latitude= 23.73864, Longitude= -73.0425 },
new { Latitude= 53.5235, Longitude= -163.656 },
new { Latitude= 14.1968, Longitude= 93.0794 },
new { Latitude= 44.5736, Longitude= -129.6263 },
new { Latitude= -19.0698, Longitude= 169.3928 },
new { Latitude= 26.3966, Longitude= 93.6705 },
new { Latitude= 26.6053, Longitude= 128.9131 },
new { Latitude= 23.33537, Longitude= 89.6659 },
new { Latitude= -15.2379, Longitude= -174.9825 },
new { Latitude= 34.732, Longitude= 24.907 },
new{ Latitude= -57.7216, Longitude= -25.2586 },
new { Latitude= -35.3534, Longitude= -72.8385 },
new { Latitude= -6.5142, Longitude= 145.9331 },
new { Latitude= 41.0279, Longitude= 143.1955 },
new{ Latitude= 4.1835, Longitude= 126.5818 },
new { Latitude= -18.05, Longitude= -69.0994 },
new { Latitude= 22.02200, Longitude= -73.0346 },
new { Latitude= -33.1344, Longitude= -176.7905 },
new{ Latitude= 30.3284, Longitude= 140.3675 },
new{ Latitude= 30.7049, Longitude= 141.5523 },
new{ Latitude= -6.063, Longitude= 146.5122 },
new { Latitude= -3.7014, Longitude= 140.2867 },
new { Latitude= 36.594, Longitude= 27.5124 },
new { Latitude= -3.6341, Longitude= 140.3296 },
new { Latitude= 28.65177, Longitude= -40.4791 },
new { Latitude= 36.7109, Longitude= 141.1474 },
new { Latitude= -3.7336, Longitude= 140.207 },
new { Latitude= 14.3189, Longitude= 93.1447 },
new { Latitude= 39.7744, Longitude= 75.4501 },
new { Latitude= 41.1331, Longitude= -127.321 },
new { Latitude= -55.3358, Longitude= -28.426 },
new { Latitude= -37.5198, Longitude= 176.4955 },
new { Latitude= 58.7996, Longitude= 149.1842 },
new { Latitude= -57.8741, Longitude= -25.7113 },
new { Latitude= -18.5562, Longitude= -175.4453 },
new { Latitude= 28.89860, Longitude= 92.8679 },
new { Latitude= 26.0212, Longitude= 128.3591 },
new{ Latitude= 26.0296, Longitude= 128.4044 },
new{ Latitude= -17.8997, Longitude= -178.5269 },
new{ Latitude= 26.0834, Longitude= 128.4265 },
new { Latitude= 15.47260, Longitude= 123.3577 },
new { Latitude= 37.6665, Longitude= 21.2943 },
new { Latitude= -19.2369, Longitude= -172.5179 },
new { Latitude= 38.332, Longitude= 142.7084 },
new { Latitude= 18.4298, Longitude= -69.2189 },
new { Latitude= 18.85050, Longitude= 67.0158 },
new { Latitude= 35.5787, Longitude= 88.2794 },
new { Latitude= 11.84026, Longitude= 92.8079 },
new { Latitude= -23.654, Longitude= -112.8086 },
new{ Latitude= 38.5159, Longitude= 93.4779 },
new{ Latitude= 51.8132, Longitude= 98.8893 },
new{ Latitude= -52.8979, Longitude= 27.5707 },
new { Latitude= 35.9449, Longitude= 140.1241 },
new{ Latitude= -5.0771, Longitude= 152.1161 },
new{ Latitude= 55.5174, Longitude= -162.2645 },
new { Latitude= 44.6862, Longitude= 124.0826 },
new { Latitude= 23.6635, Longitude= 121.4875 },
new { Latitude= -5.885, Longitude= 148.7996 },
new { Latitude= -8.0055, Longitude= 107.8368 },
new { Latitude= -7.18, Longitude= 120.8211 },
new { Latitude= -24.0389, Longitude= -66.7325 },
new{ Latitude= 44.1975, Longitude= 148.1701 },
new{ Latitude= -49.5402, Longitude= 117.3437 },
new { Latitude= 53.5738, Longitude= -163.6987 },
new { Latitude= 15.3714, Longitude= 146.1102 },
new { Latitude= -20.7337, Longitude= 168.5044 },
new{ Latitude= -19.2447, Longitude= -172.3905 },
new { Latitude= -19.2283, Longitude= -172.6304 },
new { Latitude= -19.1815, Longitude= -172.6644 },
new { Latitude= -24.3679, Longitude= -67.9324 },
new { Latitude= 2.155, Longitude= 92.4728 },
new { Latitude= -11.7382, Longitude= 166.6981 },
new { Latitude= -23.5664, Longitude= -112.6109 },
new { Latitude= -17.1246, Longitude= -70.0386 },
new { Latitude= 36.6554, Longitude= 71.0538 },
new { Latitude= 14.6884, Longitude= -90.9153 },
new { Latitude= -18.5119, Longitude= -176.5967 },
new { Latitude= 48.6576, Longitude= 139.1972 },
new { Latitude= -1.5403, Longitude= 135.0778 },
new { Latitude= 36.7381, Longitude= 71.2583 },
new { Latitude= -33.7964, Longitude= -178.4857 },
new { Latitude= -5.5687, Longitude= 105.4131 },
new { Latitude= -8.8615, Longitude= 31.3003 },
new { Latitude= 44.6292, Longitude= 148.109 },
new { Latitude= 23.55329, Longitude= 124.1864 },
new { Latitude= 13.2502, Longitude= -88.72 },
new { Latitude= -52.9451, Longitude= 18.5107 },
new { Latitude= -6.6306, Longitude= 128.2232 },
new { Latitude= 36.6017, Longitude= 145.1569 },
new { Latitude= -8.2584, Longitude= 146.8998 },
new { Latitude= -20.7396, Longitude= -178.4655 }
};
var series = new ScatterChartSeries();
var valueX = new List<double?>();
var valueY = new List<double?>();
foreach(var d in coordinates)
{
valueX.Add(d.Longitude);
valueY.Add(d.Latitude);
}
series.Data.X.AddRange(valueX.ToArray<double?>());
series.Data.Y.AddRange(valueY.ToArray<double?>());
series.Label="Earthquakes";
series.LegendEntry = true;
series.Visible = true;
series.MarkerType = MarkerType.Circle;
this.C1ScatterChart1.SeriesList.Add(series);
}
private void PrepareOptions()
{
var coordinates = new [] {
new { Latitude = -6.6003, Longitude = 154.8109 },
new{ Latitude = 18.6364, Longitude = 145.2596 },
new { Latitude = 77.1576, Longitude = 59.5431 },
new{ Latitude = -16.0907, Longitude = 168.417 },
new{ Latitude = -37.4779, Longitude = -73.7132 },
new{ Latitude = -22.3357, Longitude = 171.5891 },
new{ Latitude = -1.7906, Longitude = 138.6322 },
new { Latitude = 13.9832, Longitude = -92.0492 },
new { Latitude = 62.0401, Longitude = -150.5026 },
new { Latitude = 31.747, Longitude = 76.0954 },
new { Latitude = 23.73864, Longitude = -73.0425 },
new { Latitude = 53.5235, Longitude = -163.656 },
new { Latitude = 14.1968, Longitude = 93.0794 },
new { Latitude = 44.5736, Longitude = -129.6263 },
new { Latitude = -19.0698, Longitude = 169.3928 },
new { Latitude = 26.3966, Longitude = 93.6705 },
new { Latitude = 26.6053, Longitude = 128.9131 },
new { Latitude = 23.33537, Longitude = 89.6659 },
new { Latitude = -15.2379, Longitude = -174.9825 },
new { Latitude = 34.732, Longitude = 24.907 },
new{ Latitude = -57.7216, Longitude = -25.2586 },
new { Latitude = -35.3534, Longitude = -72.8385 },
new { Latitude = -6.5142, Longitude = 145.9331 },
new { Latitude = 41.0279, Longitude = 143.1955 },
new{ Latitude = 4.1835, Longitude = 126.5818 },
new { Latitude = -18.05, Longitude = -69.0994 },
new { Latitude = 22.02200, Longitude = -73.0346 },
new { Latitude = -33.1344, Longitude = -176.7905 },
new{ Latitude = 30.3284, Longitude = 140.3675 },
new{ Latitude = 30.7049, Longitude = 141.5523 },
new{ Latitude = -6.063, Longitude = 146.5122 },
new { Latitude = -3.7014, Longitude = 140.2867 },
new { Latitude = 36.594, Longitude = 27.5124 },
new { Latitude = -3.6341, Longitude = 140.3296 },
new { Latitude = 28.65177, Longitude = -40.4791 },
new { Latitude = 36.7109, Longitude = 141.1474 },
new { Latitude = -3.7336, Longitude = 140.207 },
new { Latitude = 14.3189, Longitude = 93.1447 },
new { Latitude = 39.7744, Longitude = 75.4501 },
new { Latitude = 41.1331, Longitude = -127.321 },
new { Latitude = -55.3358, Longitude = -28.426 },
new { Latitude = -37.5198, Longitude = 176.4955 },
new { Latitude = 58.7996, Longitude = 149.1842 },
new { Latitude = -57.8741, Longitude = -25.7113 },
new { Latitude = -18.5562, Longitude = -175.4453 },
new { Latitude = 28.89860, Longitude = 92.8679 },
new { Latitude = 26.0212, Longitude = 128.3591 },
new{ Latitude = 26.0296, Longitude = 128.4044 },
new{ Latitude = -17.8997, Longitude = -178.5269 },
new{ Latitude = 26.0834, Longitude = 128.4265 },
new { Latitude = 15.47260, Longitude = 123.3577 },
new { Latitude = 37.6665, Longitude = 21.2943 },
new { Latitude = -19.2369, Longitude = -172.5179 },
new { Latitude = 38.332, Longitude = 142.7084 },
new { Latitude = 18.4298, Longitude = -69.2189 },
new { Latitude = 18.85050, Longitude = 67.0158 },
new { Latitude = 35.5787, Longitude = 88.2794 },
new { Latitude = 11.84026, Longitude = 92.8079 },
new { Latitude = -23.654, Longitude = -112.8086 },
new{ Latitude = 38.5159, Longitude = 93.4779 },
new{ Latitude = 51.8132, Longitude = 98.8893 },
new{ Latitude = -52.8979, Longitude = 27.5707 },
new { Latitude = 35.9449, Longitude = 140.1241 },
new{ Latitude = -5.0771, Longitude = 152.1161 },
new{ Latitude = 55.5174, Longitude = -162.2645 },
new { Latitude = 44.6862, Longitude = 124.0826 },
new { Latitude = 23.6635, Longitude = 121.4875 },
new { Latitude = -5.885, Longitude = 148.7996 },
new { Latitude = -8.0055, Longitude = 107.8368 },
new { Latitude = -7.18, Longitude = 120.8211 },
new { Latitude = -24.0389, Longitude = -66.7325 },
new{ Latitude = 44.1975, Longitude = 148.1701 },
new{ Latitude = -49.5402, Longitude = 117.3437 },
new { Latitude = 53.5738, Longitude = -163.6987 },
new { Latitude = 15.3714, Longitude = 146.1102 },
new { Latitude = -20.7337, Longitude = 168.5044 },
new{ Latitude = -19.2447, Longitude = -172.3905 },
new { Latitude = -19.2283, Longitude = -172.6304 },
new { Latitude = -19.1815, Longitude = -172.6644 },
new { Latitude = -24.3679, Longitude = -67.9324 },
new { Latitude = 2.155, Longitude = 92.4728 },
new { Latitude = -11.7382, Longitude = 166.6981 },
new { Latitude = -23.5664, Longitude = -112.6109 },
new { Latitude = -17.1246, Longitude = -70.0386 },
new { Latitude = 36.6554, Longitude = 71.0538 },
new { Latitude = 14.6884, Longitude = -90.9153 },
new { Latitude = -18.5119, Longitude = -176.5967 },
new { Latitude = 48.6576, Longitude = 139.1972 },
new { Latitude = -1.5403, Longitude = 135.0778 },
new { Latitude = 36.7381, Longitude = 71.2583 },
new { Latitude = -33.7964, Longitude = -178.4857 },
new { Latitude = -5.5687, Longitude = 105.4131 },
new { Latitude = -8.8615, Longitude = 31.3003 },
new { Latitude = 44.6292, Longitude = 148.109 },
new { Latitude = 23.55329, Longitude = 124.1864 },
new { Latitude = 13.2502, Longitude = -88.72 },
new { Latitude = -52.9451, Longitude = 18.5107 },
new { Latitude = -6.6306, Longitude = 128.2232 },
new { Latitude = 36.6017, Longitude = 145.1569 },
new { Latitude = -8.2584, Longitude = 146.8998 },
new { Latitude = -20.7396, Longitude = -178.4655 }
};
var series = new ScatterChartSeries();
var valueX = new List <double?>();
var valueY = new List <double?>();
foreach (var d in coordinates)
{
valueX.Add(d.Longitude);
valueY.Add(d.Latitude);
}
series.Data.X.AddRange(valueX.ToArray <double?>());
series.Data.Y.AddRange(valueY.ToArray <double?>());
series.Label = "Earthquakes";
series.LegendEntry = true;
series.Visible = true;
series.MarkerType = MarkerType.Circle;
this.C1ScatterChart1.SeriesList.Add(series);
}
