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