tag:blogger.com,1999:blog-4548691747228904242024-02-21T22:11:18.014-08:00Microsoft Chart controlAmit Prasadhttp://www.blogger.com/profile/05594888985463092405noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-454869174722890424.post-88879516549228902752010-11-20T08:54:00.000-08:002010-11-22T20:26:33.067-08:00<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAMvTWabl9thJm66Y9ZaRb03_4uR4wvoHUtSlvLl1q0JvZifPGf0KW49QvLsOkLPVsQjFTU2K0bYPmyHSBRvrhLfoFSm32TguzldoqgBLFT4gijGo4IA-wRatkq2I2MspHasoi0Sf_qUc/s1600/aa.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a><br />
<div style="color: blue; font-size: x-large; font-variant: normal; font-weight: bold;">Creating Charts with Microsoft Chart Control</div><br />
<div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;">MS Chart Control</div><div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;"><br />
</div><div style="font-size: large;">The Microsoft Chart Control for .NET Framework provides rich data visualization for developers. It enables you to create ASP.NET pages or Windows Forms applications with simple, intuitive, and visually compelling charts for complex statistical or financial analysis.<br />
<br />
</div><div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;">Benefits of using Chart Control -</div><div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;"><br />
</div><div style="font-size: large;">* Created with 'Fast Loading' with efficient memory usage<br />
<br />
* Can be used in C#, VB.NET, and <br />
<br />
* Managed C++ as well as other languages which use .NET Framework.<br />
<br />
* Chart library provides the Chart Parameters control that allows you change all parts of the chart layout by using a single easy form.</div><br />
<div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;">Features of MSChart control:-</div><div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;"><br />
</div><div style="font-size: large;">* Unlimited number of chart areas.<br />
<br />
* Automatic and manual layout and alignment management.<br />
<br />
* Automatic and manual scaling.<br />
<br />
* Logarithmic scaling for any base.<br />
<br />
* Fully customizable legends.<br />
<br />
* Intelligent data label positioning.<br />
<br />
* Data binding. filtering.<br />
<br />
* Data exporting.<br />
<br />
* Binary and XML serialization.<br />
<br />
* Unlimited number of data series and data points. e.t.c.</div><br />
<br />
<div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;">Types of Chart</div><div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;"><br />
</div><div style="font-size: large;">There are around 40 different types of charts, including 2D and 3D charts,available in MSChart control. Some of them are as follows:-<br />
<br />
* Area * Bar<br />
<br />
* Column * Line <br />
<br />
* Pyramid * Bubble <br />
<br />
* Radar and many more… </div><br />
<table><tbody>
<tr><td><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvK4Dors6m6bIZn0wLWtxx9rtPYsv8srQiD_pFZBsNChJPgq4b_vGE0hJldje2SYa7lBuATy_oedr-ExxouO2n2JguD8k2hu6nxcORYyMH_eTcW4nqslVphXmkF78mQdrmMYsq29FZKrE/s1600/area_chart.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="214" ox="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvK4Dors6m6bIZn0wLWtxx9rtPYsv8srQiD_pFZBsNChJPgq4b_vGE0hJldje2SYa7lBuATy_oedr-ExxouO2n2JguD8k2hu6nxcORYyMH_eTcW4nqslVphXmkF78mQdrmMYsq29FZKrE/s320/area_chart.png" width="320" /></a></div></td><td><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjqIQKsor__S6zYu3eYJKdWJdBGXTT7NkJup6iahlecWXWmKzIytTQuUOTUwI7NyVY202_T2p75RYbUHCyGq6C3TWPc6s9xXbO_KPWxQhWoUEYV8fAPuCBRZIOCxGxDCOW1R7ZhyphenhyphenKbNDc/s1600/column_chart.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" ox="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjqIQKsor__S6zYu3eYJKdWJdBGXTT7NkJup6iahlecWXWmKzIytTQuUOTUwI7NyVY202_T2p75RYbUHCyGq6C3TWPc6s9xXbO_KPWxQhWoUEYV8fAPuCBRZIOCxGxDCOW1R7ZhyphenhyphenKbNDc/s320/column_chart.png" width="320" /></a></div></td></tr>
<tr><td><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuV2oWQgMATgCx4nt3x7PbKopAvI9YclQEbLD9F2gWXBOt-Ci2vFBN1iVaUWf1VZa9oMBJgd-dq7j257pKo_8wiT2v3-YwZLtFmrZjNu0HG1ZegNfPiIOVoczbYQc9xoyyoLu7_OvxGM/s1600/line_chart.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" ox="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuV2oWQgMATgCx4nt3x7PbKopAvI9YclQEbLD9F2gWXBOt-Ci2vFBN1iVaUWf1VZa9oMBJgd-dq7j257pKo_8wiT2v3-YwZLtFmrZjNu0HG1ZegNfPiIOVoczbYQc9xoyyoLu7_OvxGM/s320/line_chart.png" width="320" /></a></div></td><td><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRzvIcqSTL76F5tW4c1tFbudRORiIT-gkQJNeavg2RR60WEC-BPVJygMeDKoRciJ0lkia8bIHNS_5Mi9J1M8IB9s12NHn6v5luKWLtsNX-7MAOFh0VCT58ZMmu7yh_27RswUk0Mi0X0jU/s1600/line_chart1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" ox="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRzvIcqSTL76F5tW4c1tFbudRORiIT-gkQJNeavg2RR60WEC-BPVJygMeDKoRciJ0lkia8bIHNS_5Mi9J1M8IB9s12NHn6v5luKWLtsNX-7MAOFh0VCT58ZMmu7yh_27RswUk0Mi0X0jU/s320/line_chart1.png" width="320" /></a></div><br />
</td></tr>
</tbody></table><br />
<div style="color: blue; font-size: large; font-variant: normal; font-weight: bold;">Important properties of Chart control</div><div style="font-size: large;">Two important properties of the class are the Series and ChartAreas<br />
Series :-A Series stores DataPoint objects using the DataPointCollection class.<br />
<br />
ChartArea:- The chart area is the rectangular region that encompasses the plot position, the tick marks, the axis <br />
labels and the axis titles on the chart.</div><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTlC_DrGIuNgs7t4wy6pRbR2UZmdcCbo5YCSj-y_OXeum1ciq-CnWU4Bccux1GNjL65rHSS615093HbCuDQg8iO7qE7r29xMHYuQyrYvPDw8XVe-eqkF7iWevSUKtWdYZW7aISyeE_YEo/s1600/chart_component.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" ox="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTlC_DrGIuNgs7t4wy6pRbR2UZmdcCbo5YCSj-y_OXeum1ciq-CnWU4Bccux1GNjL65rHSS615093HbCuDQg8iO7qE7r29xMHYuQyrYvPDw8XVe-eqkF7iWevSUKtWdYZW7aISyeE_YEo/s640/chart_component.png" width="640" /></a></div><div align="left" class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">Most of the chart takes only one y value, but the chart like Bubble, Range, Stock etc. take more than one y value. Following are some of the example of creating chart.</div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">Line Chart:</span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Random</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">random</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: blue;">new</span> <span style="color: #2b91af;">Random</span>();</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;">for</span> (</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">int</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">pointIndex</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = 0; </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">pointIndex</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> < 10; </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">pointIndex</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">++)</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> {</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series1"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Points.AddY</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">random.Next</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(45, 95));</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series2"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Points.AddY</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">random.Next</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(5, 75));</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> }</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Set series chart type</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series1"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartType</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">SeriesChartType</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">.Line</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series2"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartType</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">SeriesChartType</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">.Spline</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Set point labels</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series1"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">IsValueShownAsLabel</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: blue;">true</span>;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series2"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">IsValueShownAsLabel</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: blue;">true</span>;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Enable 3D</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.ChartAreas[<span style="color: #a31515;">"ChartArea1"</span>].Area3DStyle.Enable3D = <span style="color: blue;">true</span>;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">CustomLabel</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: blue;">new</span> </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">CustomLabel</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">();</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl.FromPosition</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = 1;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl.ToPosition</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = 2;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl.Text</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: #a31515;">"custom Label"</span>;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.ChartAreas[0].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">AxisX.CustomLabels.Add</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">);</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">Range Chart:</span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series1"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartType</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">SeriesChartType</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">.SplineRange</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Populate series data with data</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;">double</span>[] yValue1 = { 56, 74, 45, 59, 34, 87, 50, 87, 64, 34 };</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;">double</span>[] yValue2 = { 42, 65, 30, 42, 25, 47, 40, 70, 34, 20 };</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series1"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Points.DataBindY</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(yValue1, yValue2);</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Enable 3D</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.ChartAreas[<span style="color: #a31515;">"ChartArea1"</span>].Area3DStyle.Enable3D = <span style="color: blue;">true</span>;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">One can create chart directly by setting its data source property:</span></span></div><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Chart</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">ID</span><span style="color: blue;">="Chart1"</span> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">runat</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="server"</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">DataSourceID</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="SqlDataSource1"</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">Width</span><span style="color: blue;">="508px"></span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"><</span><span style="color: maroon;">Series</span><span style="color: blue;">></span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"><</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Series</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">Name</span><span style="color: blue;">="Series1"</span> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">YValueMembers</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="Machinery etc"></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"></</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Series</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"></</span><span style="color: maroon;">Series</span><span style="color: blue;">></span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"><</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartAreas</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"><</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartArea</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">Name</span><span style="color: blue;">="ChartArea1"></span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"></</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartArea</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"></</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ChartAreas</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"></</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Chart</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"></</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">br</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"><</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Button</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">ID</span><span style="color: blue;">="</span></span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">btnBack</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">"</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">runat</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="server"</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">Text</span><span style="color: blue;">="Back"</span> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">OnClick</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">btnBack_Click</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">"</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;">/></span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;"><</span></span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">SqlDataSource</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: red;">ID</span><span style="color: blue;">="SqlDataSource1"</span> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">runat</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="server"</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ConnectionString</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="</span><span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">$</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> ConnectionStrings:ConnectionString4 <span style="background: yellow;">%></span><span style="color: blue;">"</span> </span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">ProviderName</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="</span><span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">$</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> ConnectionStrings:ConnectionString4.ProviderName <span style="background: yellow;">%></span><span style="color: blue;">"</span> </span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">SelectCommand</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">="SELECT * FROM [Financials]"></</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">asp</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">:</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">SqlDataSource</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;">Stock Chart:</span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="color: green; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> // Create a new random number generator</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: #2b91af;">Random</span> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">rnd</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: blue;">new</span> <span style="color: #2b91af;">Random</span>();</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Data points X value is using current date</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">DateTime</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> date = </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">DateTime</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">.Now.Date</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Add points to the stock chart series</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;">for</span> (</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">int</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> index = 0; index < 10; index++)</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> {</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.Series[<span style="color: #a31515;">"Series1"</span>].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">Points.AddXY</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> date, <span style="color: green;">// X value is a date</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">rnd.Next</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(40, 50), <span style="color: green;">// High Y value</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">rnd.Next</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(10, 20), <span style="color: green;">// Low Y value</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">rnd.Next</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(20, 40), <span style="color: green;">// Open Y value</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">rnd.Next</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(20, 40)); <span style="color: green;">// Close Y value</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: green;">// Add 1 day to our X value</span></span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> date = </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">date.AddDays</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(1);</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> }</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><span style="font-family: Calibri;"></span></span></div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: left;">You can use CustomLabel class to set custom label:</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";"> CustomLabel</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: blue;">new</span> </span><span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">CustomLabel</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">();</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl.FromPosition</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = 1;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl.ToPosition</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = 2;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl.Text</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = <span style="color: #a31515;">"custom Label"</span>;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.ChartAreas[0].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">AxisX.CustomLabels.Add</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">(</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">cl</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">);</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;"><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Chart1.ChartAreas[0].</span><span style="font-family: Consolas; font-size: 9.5pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman";">AxisX.LabelStyle.Angle</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> = -60;</span><span style="mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"></span></div><div class="separator" style="clear: both; text-align: left;"><br />
</div></span>Amit Prasadhttp://www.blogger.com/profile/05594888985463092405noreply@blogger.com1