314 |
Occasionally, the margins of the axes may not align perfectly with the view
|
313 |
"candlestick" explained, an [open,high,low,close] chart
|
312 |
"candlestick", a candlestick chart (also called Japanese candlestick chart or K-line) is a style of financial chart used to describe price movements of a security, derivative, or currency. While similar in appearance to a bar chart, each candleStick represents four important pieces of information for that day: open and close in the thick body, and high and low in the "candle wick". Being densely packed with information, it tends to represent trading patterns over short periods of time, often a few days or a few trading sessions. (data requires array of array of four-numbers, such as [[open, high, low and close]], supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.ValueSize = 18; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Date"; var_CategoryAxis.Format = "value mid 9 left 2"; axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/msft.csv"; axGraph1.Series.Add("Open,High,Low,Close","msft").Type = "candlestick"; axGraph1.EndUpdate(); |
311 |
"ohlc" explained, an [open,high,low,close] chart
|
310 |
"ohlc", an open-high-low-close chart (also OHLC) is a type of chart typically used to illustrate movements in the price of a financial instrument over time. Each vertical line on the chart shows the price range (the highest and lowest prices) over one unit of time, e.g., one day or one hour. Tick marks project from each side of the line indicating the opening price (e.g., for a daily bar chart this would be the starting price for that day) on the left, and the closing price for that time period on the right. The bars may be shown in different hues depending on whether prices rose or fell in that period. (data requires array of array of four-numbers, such as [[open, high, low and close]], supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.ValueSize = 18; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Date"; var_CategoryAxis.Format = "value mid 9 left 2"; axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/msft.csv"; axGraph1.Series.Add("Open,High,Low,Close","msft").Type = "ohlc"; axGraph1.EndUpdate(); |
309 |
"bubble", a bubble chart or bubble plot is a type of chart that displays three dimensions of data (a bubble chart is an extension of the scatter plot used to look at relationships between three numeric variables.). Each entity with its triplet (v1, v2, v3) of associated data is plotted as a disk that expresses two of the vi values through the disk's xy location and the third through its size. Bubble charts can facilitate the understanding of social, economical, medical, and other scientific relationships. (data requires array of array of three-numbers, such as [[x, y, size]], supports vertical field, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add("1 25 1,2 49 2,3 70 3,4 86 4,5 96 5,6 100 4,7 96 3,8 86 2,9 70 1,10 49 1,11 25 1","Bell<b>1"); var_Serie.Type = "bubble"; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exScatterPlotSize,32); EXGRAPHLib.Serie var_Serie1 = axGraph1.Series.Add("1 -25 1,2 -49 2,3 -70 3,4 -86 4,5 -96 5,6 -100 6,7 -96 5,8 -86 4,9 -70 3,10 -49 2,11 -25 1","Bell<b>2"); var_Serie1.Type = "bubble"; var_Serie1.set_Misc(EXGRAPHLib.SerieMiscEnum.exScatterPlotSize,32); axGraph1.EndUpdate(); |
308 |
"scatter", a scatter plot (also called a scatterplot, scatter graph, scatter chart, scattergram, or scatter diagram) is a type of plot or mathematical diagram using Cartesian coordinates to display values for typically two variables for a set of data. (data requires array of array of two-numbers, such as [[x, y]], supports vertical field, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.Series.Add("1 25,2 49,3 70,4 86,5 96,6 100,7 96,8 86,9 70,10 49,11 25","Bell<b>1").Type = "scatter"; axGraph1.Series.Add("1 -25,2 -49,3 -70,4 -86,5 -96,6 -100,7 -96,8 -86,9 -70,10 -49,11 -25","Bell<b>2").Type = "scatter"; axGraph1.EndUpdate(); |
307 |
"scatterline", curved
|
306 |
"scatterline", a scatter line chart is similar with "scatter" type, excepts that lines are shown between scatter plots. (data requires array of array of two-numbers, such as [[x, y]], supports vertical field, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.Series.Add("1 25,2 49,3 70,4 86,5 96,6 100,7 96,8 86,9 70,10 49,11 25","Bell<b>1").Type = "scatterline"; axGraph1.Series.Add("1 -25,2 -49,3 -70,4 -86,5 -96,6 -100,7 -96,8 -86,9 -70,10 -49,11 -25","Bell<b>2").Type = "scatterline"; axGraph1.EndUpdate(); |
305 |
"scatterarea", curved
|
304 |
"scatterarea", a scatter area chart is similar with "scatterLine" type, excepts that scatter plots zone is filled. (data requires array of array of two-numbers, such as [[x, y]], supports vertical field, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.Series.Add("1 25,2 49,3 70,4 86,5 96,6 100,7 96,8 86,9 70,10 49,11 25","Bell<b>1").Type = "scatterarea"; axGraph1.Series.Add("1 -25,2 -49,3 -70,4 -86,5 -96,6 -100,7 -96,8 -86,9 -70,10 -49,11 -25","Bell<b>2").Type = "scatterarea"; axGraph1.EndUpdate(); |
303 |
"polarscatter", shows the serie as non-connected data points (data requires array of array of two-numbers, such as [[angle, value]], non-scrollable)
|
302 |
"polarline", represents data points connected with straight line segments (data requires array of array of two-numbers, such as [[angle, value]], non-scrollable)
|
301 |
"polararea", represents data points connected with straight line segments that enclose a filled area together with the chart pole (data requires array of array of two-numbers, such as [[angle, value]], non-scrollable)
|
300 |
"rangearea", a range chart displays sets of data points, each of which is defined by multiple values for the same category, and emphasizes the distance between the two values. The category labels are displayed on the category axis. The plain Range chart fills in the area between the top and the bottom value for each data point. (data requires array of array of two-numbers, such as [[from, to]], supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.ValueAxis.Format = "value + `°`"; axGraph1.Series.Add("Jan(5 15), Feb(6 16), Mar(8 18), Apr(10 20), May(13 23), Jun(17 28), Jul(20 32), Aug(20 32), Sep(18 28), Oct(14 23), Nov(9 17)," + " Dec(6 15)","Spain").Type = "rangearea"; axGraph1.Series.Add("Jan(3 13), Feb(4 15), Mar(8 17), Apr(11 20), May(15 25), Jun(19 29), Jul(21 31), Aug(21 31), Sep(17 27), Oct(12 22), Nov(7 16)," + " Dec(4 14)","Spain").Type = "rangearea"; axGraph1.EndUpdate(); |
299 |
"rangecolumn", single
|
298 |
"rangecolumn", a range column chart displays information as a range of data by plotting two Y-values (low and high) per data point. The vertical axis shows the values, and the horizontal axis shows the categories they belong to; in multiple-series range column charts, values are grouped by categories. (data requires array of array of two-numbers, such as [[from, to]], supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.ValueAxis.Format = "value + `°`"; axGraph1.Series.Add("Jan(5 15), Feb(6 16), Mar(8 18), Apr(10 20), May(13 23), Jun(17 28), Jul(20 32), Aug(20 32), Sep(18 28), Oct(14 23), Nov(9 17)," + " Dec(6 15)","Spain").Type = "RangeColumn"; axGraph1.Series.Add("Jan(3 13), Feb(4 15), Mar(8 17), Apr(11 20), May(15 25), Jun(19 29), Jul(21 31), Aug(21 31), Sep(17 27), Oct(12 22), Nov(7 16)," + " Dec(4 14)","Spain").Type = "RangeColumn"; axGraph1.EndUpdate(); |
297 |
"pie", a pie chart (or a circle chart) is a circular statistical graphic which is divided into slices to illustrate numerical proportion. In a pie chart, the arc length of each slice (and consequently its central angle and area) is proportional to the quantity it represents. While it is named for its resemblance to a pie which has been sliced, there are variations on the way it can be presented. (data requires array of numbers, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.set_Misc(EXGRAPHLib.MiscEnum.exPaddingInsidePie,2); EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "pie"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "pie"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
296 |
"waterfall", a waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air. Often in finance, it will be referred to as a bridge. (data requires array of numbers, supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "waterfall"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "waterfall"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
295 |
"radarcolumn", stacked
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide"); var_Serie.Type = "radarcolumn"; var_Serie.Stack = "group"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native"); var_Serie1.Type = "radarcolumn"; var_Serie1.Stack = "group"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
294 |
"radarcolumn", displays data in radial columns starting from one center point. The circle is divided into equal portions depending on the number of columns and each column group occupies one portion (similar with "radarArea" type, data requires array of numbers, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "radarcolumn"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "radarcolumn"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
293 |
"radarline", stacked
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide"); var_Serie.Type = "radarline"; var_Serie.Stack = "group"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native"); var_Serie1.Type = "radarline"; var_Serie1.Stack = "group"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
292 |
"radarline" (data requires array of numbers, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "radarline"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "radarline"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
291 |
"radararea", stacked
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide"); var_Serie.Type = "radararea"; var_Serie.Stack = "group"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native"); var_Serie1.Type = "radararea"; var_Serie1.Stack = "group"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
290 |
"radararea", a radar chart is a graphical method of displaying multivariate data in the form of a two-dimensional chart of three or more quantitative variables represented on axes starting from the same point. The relative position and angle of the axes is typically uninformative, but various heuristics, such as algorithms that plot data as the maximal total area, can be applied to sort the variables (axes) into relative positions that reveal distinct correlations, trade-offs, and a multitude of other comparative measures. (data requires array of numbers, non-scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "radararea"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "radararea"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
289 |
"column", single
|
288 |
"column", stacked
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide"); var_Serie.Type = "column"; var_Serie.Stack = "group"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native"); var_Serie1.Type = "column"; var_Serie1.Stack = "group"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
287 |
"column", a column chart or column graph is a chart or graph that presents categorical data with rectangular columns with heights proportional to the values that they represent. A horizontal column chart is called a bar chart. (data requires array of numbers, supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "column"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "column"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
286 |
"line", stacked
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide"); var_Serie.Type = "line"; var_Serie.Stack = "group"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native"); var_Serie1.Type = "line"; var_Serie1.Stack = "group"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
285 |
"line", a line chart or line graph, also known as curve chart is a type of chart which displays information as a series of data points called 'markers' connected by straight line segments. It is a basic type of chart common in many fields. It is similar to a scatter plot except that the measurement points are ordered (typically by their x-axis value) and joined with straight line segments. A line chart is often used to visualize a trend in data over intervals of time - a time series - thus the line is often drawn chronologically. In these cases they are known as run charts. (data requires array of numbers, supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "line"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "line"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
284 |
"area", stacked
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide"); var_Serie.Type = "area"; var_Serie.Stack = "group"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native"); var_Serie1.Type = "area"; var_Serie1.Stack = "group"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
283 |
"area", an area chart or area graph displays graphically quantitative data. It is based on the line chart. The area between axis and line are commonly emphasized with colors, textures and hatchings. Commonly one compares two or more quantities with an area chart. (data requires array of numbers, supports vertical field, scrollable)
axGraph1.BeginUpdate(); axGraph1.Pad = 18; axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Chinese(14.1),Spanish(6.7),English(4.9),Hindi(4.2),Arabic(4.1),Bengali(3.3),Portuguese(2.9),Russian(2.8),Japanese(1.7),Lahnda(1" + ".6)","Worldwide").Type = "area"; var_Series.Add("Chinese(13.2),Spanish(6.6),English(4.8),Hindi(4.1),Arabic(4.0),Bengali(3.2),Portuguese(2.8),Russian(2.7),Japanese(1.6),Lahnda(1" + ".5)","Native").Type = "area"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
282 |
Defines the color to show the frame around the pies
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add("1920(1.8),1945(2.3),1970(13.7),1995(5.7),2020(7.8)","Population"); var_Serie.Type = "Pie"; var_Serie.ShowValue = EXGRAPHLib.ShowValueEnum.exValue | EXGRAPHLib.ShowValueEnum.exLine | EXGRAPHLib.ShowValueEnum.exPoint; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exPieFrameColor,255); var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exLineSize,4); axGraph1.EndUpdate(); |
281 |
Defines the width of the line to show the serie
|
280 |
Changes the spline's tension and alpha curves
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add("1920(1.8),1945(2.3),1970(13.7),1995(5.7),2020(7.8)","Population"); var_Serie.Type = "Line"; var_Serie.Style = EXGRAPHLib.SerieStyleEnum.exSpline; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exSplineTension,0); var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exSplineAlpha,1); axGraph1.EndUpdate(); |
279 |
Enables or disables the presentation of hollow representations. This indicates instances where the closing price exceeds the opening price, resulting in candlesticks characterized by unfilled bodies
|
278 |
Defines the size to display the candle stick
|
277 |
Defines the radius to show the plot on scatter-type charts
axGraph1.BeginUpdate(); EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add("11 22 33,44 55 66,77 88 99,12 34 56,78 90 23",null); var_Serie.Type = "bubble"; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exScatterPlotSize,64); EXGRAPHLib.Serie var_Serie1 = axGraph1.Series.Add("21 32 43,54 65 76,87 98 09,45 67 89,90 23 45",null); var_Serie1.Type = "bubble"; var_Serie1.set_Misc(EXGRAPHLib.SerieMiscEnum.exScatterPlotSize,64); EXGRAPHLib.Cursor var_Cursor = axGraph1.Cursor; var_Cursor.Visible = true; var_Cursor.ShowCursorXLine = false; axGraph1.EndUpdate(); |
276 |
Customizes the captions to be shown within the legend
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.ValueAxis.AsPercent = true; axGraph1.Series.Add("Pacific Ocean(16525), Atlantic Ocean(10646), Indian Ocean(7056), Southern Ocean(2033), Arctic Ocean(1406)",null).LegendFormat = "trim(label replace `Ocean` with ``)"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
275 |
Stacked (data points within a series are stacked on top of each other rather than plotted side by side)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Electronics(350),Clothing(200),Books(150)",2001).Stack = "A"; var_Series.Add("Electronics(500),Clothing(150),Books(180)",2002).Stack = "A"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
274 |
Draws a curved line
|
273 |
Customizes the values to display on the chart (showValue property includes the exValue)
|
272 |
Shows or hides the serie's value-points, value-lines and values
|
271 |
Shows or hides the serie
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("Facebook(125),Google(94),Twitter(38),LinkedIn(172),Instagram(53),Pinterest(187),Snapchat(104),WhatsApp(19)",null); var_Serie.Visible = false; var_Serie.Vertical = true; var_Serie.Name = 2001.ToString(); var_Series.Add("Facebook(176),Google(81),Twitter(47),LinkedIn(159),Instagram(62),Pinterest(193),Snapchat(118),WhatsApp(25)",null).Name = 2002.ToString(); axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
270 |
Show bars graph (the serie is showing the data vertically or horizontally)
|
269 |
Defines the name of the chart serie which is visible in the legend
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.ValueAxis var_ValueAxis = axGraph1.ValueAxis; var_ValueAxis.AsPercent = true; var_ValueAxis.Format = "(value * 100 format `0`) + `%`"; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Asian(10),Black(13),Hispanic(15),White(60),Other(7)","<fgcolor blue>Population"); var_Series.Add("Asian(65),Black(69),Hispanic(67),White(70),Other(68)",null).Name = "<fgcolor teal>Height"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
268 |
Defines the visual appearance of the serie using EBN colors (method 3,mixt)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABVoDg6AADACAxRDAMgBQKAAzAJBIYhiGgcYCgMZBSDeCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADIOAzyPAsVwSGobRpkEaIMiONoYR5Ac4yF" + "AcQxHE6TZRGeQRRiGModT5HFIxXIsBgRECEQChFzQcCQAJUVZFdAyVQlDRCGSpJrkEC4cBCCZPTzUNR1LS9WS1DoaRJoG4ZHDUMJyS7dcjyHINGwxMinJrwKA6bi6BAw" + "YYAEwUPAYcT9QaRZznOQaLhiQIdVxDNbURgWKgVBK/AiqCA7Bq2VpYZZmFB5VJ9P5LPiEcE+fAdTQHUS0dItPR7OiacJ4TpdF48BhVdY7UCEdoADYtYxCP6qSxiFDUDA" + "/CsF5KloAAXm4VBfEuKJUFuZxSi6DouAY34NDWdItg2HgTjaWZHDuVpPAae4DkQGRwjyXBvlcE47iMdoelQDYyHcHJkGGFIAEAARAGkGJHEGVByBkVBUCSFhEgQIQ2BM" + "RpDGQJAoHuEIXDUCAGBGAYBHsc4NhMNJOCqCJCDoKIKiKGIuC6CxjAiMgyguYw4iSXg2g2MZoEcEJJjGLA4CiBwwnSJQdEOcogHcEBKjGZBDCuB4xBSMQfEQcpUgAEoL" + "gICBMC6SBBDiPghkUEwEgkFJMEILBVCyR4RDiGQckcIY8DYCwJnGQA6hAJApBIRoSCSKQyE6FAlCkUhWhYJYpHIXoYCYIwcg0FZHiCeA0hqJpJjocIQmQWQeEmEpklkP" + "hRhSZRZF4WYWmWWR+GEFRoCoEoGBmQpQiiAwTgMIh0G4DpokmToPh2KQpmaFYfCmCZ8jcH4EnITBYA+RpQkQLg3A0Iw8iMIAHgGQA3AsSZxjwPApkcYS5h4BAijQegRA" + "sCRAjQH5EhKXIBBKS4pGSPQhgUAo4HUEtHhAPQxgqUoMmNjRQhAHA7G6I42CUM4HmEKA7jILIrDKTo0C0KxSlaNglhKXB/BMSBxFwUw6k4c4im2QZujwIJtCySYSGyFQ" + "YEOKwuk2M5tBEHpTjUbR7GQTgjgUUJym+QoyAwJwiDsSAxDQNJEi8fBXBePpxiGXA8AyMgbjMI5MHIXIenaRQvhwYp8BOMpskMM5PnMLQHAyQ4xAyIw4kWL4sGZDoxmi" + "GwxkKLpxlQPQLi8TQaniUgziwap+BMbwRBsBJBjIO48hcHIHEGMAyAqbBbB6SZVjKLQnDuNptlsfBvA2Qx4iyKwM4GR6BBBMDAQwxQIDkA8BQQYoA+iqGSEUNgmxKhKD" + "KLwVojQ3AGACBAFIFxCAgFIE8RgogUgcBiAsUY8BJAYCaLMPw/xgDwD2F8BYwxtBcCeBcNoWxOBwFIGEZgRgagGCcA0cYJwajOCiFwf4BRhAID4DARYxAEhcCgJkYwdQ" + "eB/CwCoeowhcgqBoAwAYWAxAVEiOIdAagkCLGCLmAoBwMB4DoEsRgYRwgyBkIcUg4BmAfZKEgQQUBGhCeGDYBAhQUDaBGBUAYeBHBVAcCIJ4KARCSCGGgbwcQjgaA4Gk" + "foxgfjkDUV8GAswLCDE8AIBwtAjAAAQAggIA="); EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Facebook(125),Google(94),Twitter(38),LinkedIn(172),Instagram(53),Pinterest(187),Snapchat(104),WhatsApp(19)",null).Color = 16777216; var_Series.Add("Facebook(176),Google(81),Twitter(47),LinkedIn(159),Instagram(62),Pinterest(193),Snapchat(118),WhatsApp(25)",null).Color = 16777216; axGraph1.SeriesColors = "red,RGB(255,128,0)"; axGraph1.EndUpdate(); |
267 |
Defines the color to show the serie (method 2)
|
266 |
Defines the color to show the serie (method 1)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Facebook(125),Google(94),Twitter(38),LinkedIn(172),Instagram(53),Pinterest(187),Snapchat(104),WhatsApp(19)",null).Color = "red"; var_Series.Add("Facebook(176),Google(81),Twitter(47),LinkedIn(159),Instagram(62),Pinterest(193),Snapchat(118),WhatsApp(25)",null).Color = 33023; axGraph1.EndUpdate(); |
265 |
Changes the position of the serie
|
264 |
Referencing a series by its key
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("Facebook(125),Google(94),Twitter(38),LinkedIn(172),Instagram(53),Pinterest(187),Snapchat(104),WhatsApp(19)",null).Key = "1st"; var_Series.Add("Facebook(176),Google(81),Twitter(47),LinkedIn(159),Instagram(62),Pinterest(193),Snapchat(118),WhatsApp(25)",null).Key = "2nd"; axGraph1.Series["2nd"].Visible = false; axGraph1.EndUpdate(); |
263 |
Removes the serie (click to remove the serie)
|
262 |
Clears the series (click to remove all series)
|
261 |
Add multiple series (mixt)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.set_Misc(EXGRAPHLib.MiscEnum.exBaseMajorUnits,"1,5"); axGraph1.CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.ValueAxes var_ValueAxes = axGraph1.ValueAxes; EXGRAPHLib.ValueAxis var_ValueAxis = var_ValueAxes.Add("g+a"); var_ValueAxis.End = 0.66; var_ValueAxis.MajorGridLines.Step = 1000; EXGRAPHLib.ValueAxis var_ValueAxis1 = var_ValueAxes.Add("p"); var_ValueAxis1.Start = 0.66; var_ValueAxis1.MajorGridLines.Step = 1000; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("UnitedStates(22.7),China(17.6),Japan(5.0),Germany(4.4),India(3.2),UnitedKingdom(3.1),France(3.0),Brazil(2.5)","GDP"); var_Serie.Axis = "g+a"; var_Serie.Stack = "g+a"; var_Series.Add("UnitedStates(331),China(1400),Japan(126),Germany(83),India(1400),UnitedKingdom(68),France(67),Brazil(213)","Population").Axis = "p"; EXGRAPHLib.Serie var_Serie1 = var_Series.Add("UnitedStates(9.8),China(9.6),Japan(0.377),Germany(0.357),India(3.3),UnitedKingdom(0.610),France(0.695),Brazil(8.5)","Area"); var_Serie1.Axis = "g+a"; var_Serie1.Stack = "g+a"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
260 |
Add multiple series (same value-axis, stacked)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("UnitedStates(22.7),China(17.6),Japan(5.0),Germany(4.4),India(3.2),UnitedKingdom(3.1),France(3.0),Brazil(2.5)","GDP").Stack = "g+a"; var_Series.Add("UnitedStates(331),China(1400),Japan(126),Germany(83),India(1400),UnitedKingdom(68),France(67),Brazil(213)","Population"); var_Series.Add("UnitedStates(9.8),China(9.6),Japan(0.377),Germany(0.357),India(3.3),UnitedKingdom(0.610),France(0.695),Brazil(8.5)","Area").Stack = "g+a"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
259 |
Add multiple series (same value-axis, all stacked)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("UnitedStates(22.7),China(17.6),Japan(5.0),Germany(4.4),India(3.2),UnitedKingdom(3.1),France(3.0),Brazil(2.5)","GDP").Stack = "all"; var_Series.Add("UnitedStates(331),China(1400),Japan(126),Germany(83),India(1400),UnitedKingdom(68),France(67),Brazil(213)","Population").Stack = "all"; var_Series.Add("UnitedStates(9.8),China(9.6),Japan(0.377),Germany(0.357),India(3.3),UnitedKingdom(0.610),France(0.695),Brazil(8.5)","Area").Stack = "all"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
258 |
Add multiple series (same value-axis)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("UnitedStates(22.7),China(17.6),Japan(5.0),Germany(4.4),India(3.2),UnitedKingdom(3.1),France(3.0),Brazil(2.5)","GDP"); var_Series.Add("UnitedStates(331),China(1400),Japan(126),Germany(83),India(1400),UnitedKingdom(68),France(67),Brazil(213)","Population"); var_Series.Add("UnitedStates(9.8),China(9.6),Japan(0.377),Germany(0.357),India(3.3),UnitedKingdom(0.610),France(0.695),Brazil(8.5)","Area"); axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
257 |
Add multiple series (different value axes)
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.ValueAxes var_ValueAxes = axGraph1.ValueAxes; EXGRAPHLib.ValueAxis var_ValueAxis = var_ValueAxes.Add("g"); var_ValueAxis.End = 0.33; var_ValueAxis.Visible = false; var_ValueAxis.MajorGridLines.Step = 1000; EXGRAPHLib.ValueAxis var_ValueAxis1 = var_ValueAxes.Add("p"); var_ValueAxis1.Start = 0.33; var_ValueAxis1.End = 0.66; var_ValueAxis1.Visible = false; var_ValueAxis1.MajorGridLines.Step = 1000; EXGRAPHLib.ValueAxis var_ValueAxis2 = var_ValueAxes.Add("a"); var_ValueAxis2.Start = 0.66; var_ValueAxis2.Visible = false; var_ValueAxis2.MajorGridLines.Step = 1000; EXGRAPHLib.Series var_Series = axGraph1.Series; var_Series.Add("UnitedStates(22.7),China(17.6),Japan(5.0),Germany(4.4),India(3.2),UnitedKingdom(3.1),France(3.0),Brazil(2.5)","GDP").Axis = "g"; var_Series.Add("UnitedStates(331),China(1400),Japan(126),Germany(83),India(1400),UnitedKingdom(68),France(67),Brazil(213)","Population").Axis = "p"; var_Series.Add("UnitedStates(9.8),China(9.6),Japan(0.377),Germany(0.357),India(3.3),UnitedKingdom(0.610),France(0.695),Brazil(8.5)","Area").Axis = "a"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
256 |
Display the values over the columns
|
255 |
Defines the pad, distance between value-label and its frame (the number indicated by the ValuePoint property in the 11-th position)
|
254 |
Defines the size of the frame around the value-label (the number indicated by the ValuePoint property in the 10-th position)
|
253 |
Defines the color of the frame around the value-label (the color indicated by the ValuePoint property in the 9-th position)
|
252 |
Defines the background color of the value-label (the color indicated by the ValuePoint property in the 8-th position)
|
251 |
Defines the length of the line (the number indicated by the ValuePoint property in the 7-th position)
|
250 |
Defines the size of the line from the value point to its label (the number indicated by the ValuePoint property in the 6-th position)
|
249 |
Defines the color of the line from the value point to its label (the color indicated by the ValuePoint property in the 5-th position)
|
248 |
Defines the size of the frame around the value point (the number indicated by the ValuePoint property in the 4-th position)
|
247 |
Defines the color of the frame around the value point (the color indicated by the ValuePoint property in the 3-rd position)
|
246 |
Defines the color of the value point (the color indicated by the ValuePoint property in the 2-nd position)
|
245 |
Defines the size of the value point (the number indicated by the ValuePoint property in the first position)
|
244 |
Disables resizing the chart by drag and drop (resize the chart's value by clicking and dragging with the middle mouse button)
|
243 |
Scrolls programatically the chart
|
242 |
Disables scrolling the chart by clicking and dragging the chart
|
241 |
Disables the scroll bars
axGraph1.BeginUpdate(); axGraph1.ValueSize = 8; axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/msft.csv"; axGraph1.ValueAxis.Format = "value format ``"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Name = "msft"; var_Serie.Data = "Open,High,Low,Close"; var_Serie.Type = "candle"; axGraph1.ScrollBars = EXGRAPHLib.ScrollBarsEnum.exNoScroll; axGraph1.AllowScroll = false; axGraph1.EndUpdate(); |
240 |
Hides the scroll bars
|
239 |
The maximum value of the axis does not fit the view. Is there anything I can do to ensure that it fits the view
|
238 |
Customizes the "no or invalid data" message
axGraph1.Invalid = "<fgcolor red>no or invalid data"; axGraph1.FormatText = EXGRAPHLib.DrawTextFormatEnum.exTextAlignBottom | EXGRAPHLib.DrawTextFormatEnum.exTextAlignCenter; |
237 |
Sorts descending the serie
|
236 |
Sorts ascending the serie
|
235 |
I changed the ValueSize property but it appears that it has no effect
axGraph1.BeginUpdate(); axGraph1.ValueSize = 32; axGraph1.AutoFit = false; axGraph1.CategoryAxis.Format = "value replace `Ocean` with ``"; axGraph1.Series.Add("Pacific Ocean(16525), Atlantic Ocean(10646), Indian Ocean(7056), Southern Ocean(2033), Arctic Ocean(1406)",null).Type = "Column"; axGraph1.EndUpdate(); |
234 |
Defines the size to show a column or a bar within the chart
|
233 |
Customizes the tooltip (shown while the cursor hovers value-points of the chart)
|
232 |
Resizes the elements of the series to fit the control's content
|
231 |
Defines the preset color scheme for the chart's series, encompassing both regular and reduced values
axGraph1.BeginUpdate(); axGraph1.ValueSize = 8; axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/msft.csv"; axGraph1.ValueAxis.Format = "value format ``"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Name = "msft"; var_Serie.Data = "Open,High,Low,Close"; var_Serie.Type = "candle"; axGraph1.SeriesColors = "gray"; axGraph1.SeriesColorsDecrease = "black"; axGraph1.EndUpdate(); |
230 |
Defines the default colors for the chart's series
|
229 |
Updates the x-axis, y-axis
EXGRAPHLib.LineOptions var_LineOptions = axGraph1.XAxis.AxisLine; var_LineOptions.Width = 2; var_LineOptions.Color = "red"; EXGRAPHLib.LineOptions var_LineOptions1 = axGraph1.YAxis.AxisLine; var_LineOptions1.Width = 2; var_LineOptions1.Color = "red"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Data = "1 99 1,2 96 2,3 92 3,4 86 4,5 79 5,6 70 6,7 60 7,8 50 8,9 38 9,10 25 10,11 13 11"; var_Serie.Type = "bubble"; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exScatterPlotSize,96); |
228 |
Updates the default/first value-axis
EXGRAPHLib.ValueAxis var_ValueAxis = axGraph1.ValueAxis; var_ValueAxis.Tfi = "<fgcolor red>"; axGraph1.Series.Add("Friendster(121111111),Facebook(979750000),Flickr(79664888),Google Buzz(170000000),Google+(107319100),Hi5(900202990),Instagram(8" + "0202990),MySpace(80202990),Orkut(45067022),Pinterest(197319100),Reddit(360250000),Snapchat(280250000),TikTok(860250000),Tumblr(1" + "46890156),Twitter(160250000),WeChat(118123370),Weibo(79195730),Whatsapp(1160250000),YouTube(844638200)",null); |
227 |
Updates the default/first category-axis
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Asia,Africa,Europe,North America,Antarctica,South America,Australia/Oceania"; var_CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("4600,1300,747,579,0,422,42",null); var_Serie.Name = "Population"; var_Serie.Type = "Line"; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exLineSize,3); EXGRAPHLib.Serie var_Serie1 = var_Series.Add("4458,3037,1018,2470,1784,1018,856",null); var_Serie1.Name = "Area"; var_Serie1.Type = "Column"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
226 |
Add multiple series into the same view
axGraph1.BeginUpdate(); axGraph1.AutoFit = true; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Asia,Africa,Europe,North America,Antarctica,South America,Australia/Oceania"; var_CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Series var_Series = axGraph1.Series; EXGRAPHLib.Serie var_Serie = var_Series.Add("4600,1300,747,579,0,422,42",null); var_Serie.Name = "Population"; var_Serie.Type = "Line"; var_Serie.set_Misc(EXGRAPHLib.SerieMiscEnum.exLineSize,3); EXGRAPHLib.Serie var_Serie1 = var_Series.Add("4458,3037,1018,2470,1784,1018,856",null); var_Serie1.Name = "Area"; var_Serie1.Type = "Column"; axGraph1.Legend.Visible = true; axGraph1.EndUpdate(); |
225 |
Do do I get the DAO version I have installed
// Add 'Microsoft DAO 2.5/3.51 Compatibility Library(dao2535.tlb)' reference to your project. System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version ); // Add 'Microsoft DAO 3.6 Object Library(dao360.dll)' reference to your project. System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version ); // Add 'Microsoft Office 15.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project. System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version ); |
224 |
How do I get a list of interfaces the object implemenets
|
223 |
Do do I get the ADO version I have installed
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. System.Diagnostics.Debug.Print( "ADO Version:" ); System.Diagnostics.Debug.Print( new ADODB.Connection().Version ); |
222 |
DAO, ACCDB, 120
|
221 |
DAO, MDB, 120
|
220 |
DAO, MDB
|
219 |
ADODB, ACCDB, x64
|
218 |
ADOR, ACCDB
|
217 |
ADODB, MDB
|
216 |
ADOR, MDB
|
215 |
The value-axis gets updated as soon as the control is scrolled. It is possible to prevent that
axGraph1.BeginUpdate(); axGraph1.ValueSize = 2; axGraph1.set_Misc(EXGRAPHLib.MiscEnum.exUpdateRangeOnScroll,0); axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/aapl.txt"; System.Diagnostics.Debug.Print( axGraph1.DataSample.ToString() ); axGraph1.Series.Add("AAPL (open),AAPL (high),AAPL (low),AAPL (close)",null).Type = "candle"; axGraph1.EndUpdate(); |
214 |
Debug the data I loaded, or gatter a data sample
axGraph1.BeginUpdate(); axGraph1.ValueSize = 6; axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/aapl.txt"; System.Diagnostics.Debug.Print( axGraph1.DataSample.ToString() ); axGraph1.EndUpdate(); |
213 |
Imports the control's data from a safe array (array, method 3)
axGraph1.BeginUpdate(); axGraph1.ValueSize = 6; // Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. ADODB.Recordset rs = new ADODB.Recordset(); rs.Open("MSFT","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Access\\sample.accdb",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0); axGraph1.Data = rs.GetRows(0,null,null); System.Diagnostics.Debug.Print( axGraph1.DataSample.ToString() ); EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Data = "Column 2,Column 3,Column 4,Column 5"; var_Serie.Type = "candle"; axGraph1.EndUpdate(); |
212 |
Imports the control's data from a CSV format (file, method 2)
axGraph1.BeginUpdate(); axGraph1.ValueSize = 6; axGraph1.Data = "C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/aapl.txt"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Name = "aapl"; var_Serie.Data = "AAPL (open),AAPL (high),AAPL (low),AAPL (close)"; var_Serie.Type = "candle"; axGraph1.EndUpdate(); |
211 |
Imports the control's data from a CSV format (content, string, method 2)
axGraph1.BeginUpdate(); axGraph1.set_Misc(EXGRAPHLib.MiscEnum.extVisibleBeforeAxis,1); axGraph1.AutoFit = true; axGraph1.DataOptions = "hdr=1 eor=';' eof=' '"; axGraph1.Data = "Month Min Max;Jan -2 10;Feb 0 12;Mar 3 15;Apr 7 18;May 12 22;Jun 16 25;Jul 18 28;Aug 17 27;Sep 14 24;Oct 9 19;Nov 4 15;Dec 0 10" + ""; EXGRAPHLib.ValueAxis var_ValueAxis = axGraph1.ValueAxis; var_ValueAxis.Format = "value + `°`"; var_ValueAxis.MajorGridLines.Color = "transparent"; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Month"; var_CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Data = "Min,Max"; var_Serie.Type = "RangeColumn"; var_Serie.Vertical = true; axGraph1.SeriesColors = "RGB(9,80,239),RGB(9,120,239),RGB(249,186,7),RGB(249,173,7),RGB(255,148,51),RGB(255,125,51),RGB(255,114,51),RGB(255,120,51),RGB(" + "255,139,51),RGB(249,171,7),RGB(249,200,7),RGB(9,110,239)"; axGraph1.EndUpdate(); |
210 |
Imports the control's data from a CSV format (file, method 1)
axGraph1.BeginUpdate(); axGraph1.ValueSize = 6; axGraph1.Import("C:\\Program Files\\Exontrol\\ExGraph\\Sample\\Data/aapl.txt",null); EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Name = "aapl"; var_Serie.Data = "AAPL (open),AAPL (high),AAPL (low),AAPL (close)"; var_Serie.Type = "candle"; axGraph1.EndUpdate(); |
209 |
Imports the control's data from a CSV format (content, string, method 1)
axGraph1.BeginUpdate(); axGraph1.set_Misc(EXGRAPHLib.MiscEnum.extVisibleBeforeAxis,1); axGraph1.AutoFit = true; axGraph1.Import("Month Min Max;Jan -2 10;Feb 0 12;Mar 3 15;Apr 7 18;May 12 22;Jun 16 25;Jul 18 28;Aug 17 27;Sep 14 24;Oct 9 19;Nov 4 15;Dec 0 10" + "","hdr=1 eor=';' eof=' '"); EXGRAPHLib.ValueAxis var_ValueAxis = axGraph1.ValueAxis; var_ValueAxis.Format = "value + `°`"; var_ValueAxis.MajorGridLines.Color = "transparent"; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Month"; var_CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Data = "Min,Max"; var_Serie.Type = "RangeColumn"; var_Serie.Vertical = true; axGraph1.SeriesColors = "RGB(9,80,239),RGB(9,120,239),RGB(249,186,7),RGB(249,173,7),RGB(255,148,51),RGB(255,125,51),RGB(255,114,51),RGB(255,120,51),RGB(" + "255,139,51),RGB(249,171,7),RGB(249,200,7),RGB(9,110,239)"; axGraph1.EndUpdate(); |
208 |
Defines the field delimitators, such as eor(end of record), eof(end of field) and hdr(header)
axGraph1.BeginUpdate(); axGraph1.set_Misc(EXGRAPHLib.MiscEnum.extVisibleBeforeAxis,1); axGraph1.AutoFit = true; axGraph1.DataOptions = "hdr=1 eor=';' eof=' '"; axGraph1.Data = "Month Min Max;Jan -5 2;Feb -4 7;Mar 1 12;Apr 5 17;May 10 23;Jun 14 26;Jul 15 28;Aug 14 28;Sep 11 25;Oct 5 18;Nov 1 9;Dec -3 4"; EXGRAPHLib.ValueAxis var_ValueAxis = axGraph1.ValueAxis; var_ValueAxis.Format = "value + `°`"; var_ValueAxis.MajorGridLines.Color = "transparent"; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "Month"; var_CategoryAxis.MajorGridLines.Color = "lightgray"; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add(null,null); var_Serie.Data = "Min,Max"; var_Serie.Type = "RangeColumn"; axGraph1.SeriesColors = "RGB(9,80,239),RGB(9,120,239),RGB(249,186,7),RGB(249,173,7),RGB(255,148,51),RGB(255,125,51),RGB(255,114,51),RGB(255,120,51),RGB(" + "255,139,51),RGB(249,171,7),RGB(249,200,7),RGB(9,110,239)"; axGraph1.EndUpdate(); |
207 |
Defines the size of the control's tooltip margins
|
206 |
Sets the size of icons the control displays
|
205 |
Prevents the control to fire any event
axGraph1.FreezeEvents(true); axGraph1.BeginUpdate(); axGraph1.AutoFit = true; axGraph1.Series.Add("Pacific Ocean(16525), Atlantic Ocean(10646), Indian Ocean(7056), Southern Ocean(2033), Arctic Ocean(1406)",null).Vertical = true; axGraph1.EndUpdate(); axGraph1.FreezeEvents(false); |
204 |
Display columns using EBN colors (BASE64)
axGraph1.BeginUpdate(); axGraph1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABUQDg6AADACAxRDAMgBQKAAzAJBIYhiGgcYCgMZBSDeCYXABCEYRXBIZQ7BKNIxjSJwFiCCQwSDKEjyCKsGRHF6MI6gOYpCgOIYjRJNIASV" + "AceAAHCUZrjSgobAiCYlTZCIBQS5oOBIACmabiegZLgmQInUrMEggVDgJSPuTWNQUdYdJQTHIZBpEWyLKjkNQwWrCNr3DTUEyNDauIDpCKLCpGZYYVRPOAgAKldxhGCa" + "JokGkgc4HHyrcCwfDAMraCQQWAAF62Jb1JyrSSBchnOwpDpuCaVQLXUB5RRNQyZTiyIrtS5AAqnNJzW5cE46Li0B5QAC8QA1S7NPo/HaZT5kGB7ZDddzuADfcLlfD5Bx" + "EDCUhQmEPAbl6K4hlKQ5snwNwtleDxpBeMRIHmd4+A8R4/BuRZvEABQDEmDJoHUOQZEYMgVjQSIEE0fwRjCWQJAoEIXHWQxCAGBBggAbpemOCJaDaRowkQKwfgSEJCBQ" + "DAGnCWAsDYTJTLSBwOlgfghggIgohYIA3A0Iw8GcCxCigZAsguB4hBwQ4HAyZAMjMJhJjIPBdA0SZxkAOoPEOIhMGEDYJHGSB0gmIg5CYSAokgAZggME4DCkAhACbIhg" + "ioIwImQDhXCOCQRHgNwogcIJyGCGImBGMAyAqYxJCISINAcAJcC0JxGmCbIiByQ5Zk4dYdCWORqFgJJGACYIkB0A5pn6AYgAmcY8DwHRDlCOg3CaZIKCwfgSgOOgUDwK" + "RHFCfoUiWKRaF4eQACWMhUGEDoKHGWBAigag6gqJIpCmYJogMExDEqLA0ioah6giKAdkQGpOjWLQrGobjfEYMJwioHhEDqfpBjACohmAQoxGwewakiMpsisNBCCqbALE" + "AQ40i0KtjCYRhQnSLQekQWxul2NwKlGaBEjgbg7gqZI5m4a4kEQK4tkuMBFjuLprFiDgnAYYJ8jAHxEHuXp5j4L4rnafI/m+PAGnoLBvgwEBH5Aa5Ih8GhEBKUIABKMJ" + "sEMDwtAecQnBSRYxFwXwakYcZBCSNZDnGcQrCGlIigQagQkscgIEyShyjyKI3CARI8j8MZMDMLJXDSTZEjKYwqk6BJMnMPI8goMYwEQLoIEEOxElGNBdB8SpSHSTQjE6" + "UZLj0FxRBONQ9E6cgpEaUQYj0IYFA0bxdlcNZilwfwTEiYRUDwHZDkCSxoAyNhQnMYgTHWYp4gcFB3C2Uxzl0N4IoQBvAjEwAQIApRfDvH2PELgOhEhUDwI0GgxBIgED" + "QEMRQ4hPgGBKBgEgSBTjIHkHwS4KQ8siEQJIMIkQxCvBwCoS4hAQCkBuIYcIuRrBzE6BMK4Eg7D0HOEAewIgDilFwPwE4mBODvDUCoew9BsiMCyJYQg+BlAiEwMQNArx" + "wCKH6PARYLR6hSCuFYMYFRSgZBMCwA45gfiFHSAocomB5AnCmGcH4tAkgNFGHkFQNAGAEHAN4GQERhgQF0GsDIxg/iTHIJwMw4RVA2EMCEOA9APgGE+JgNATBHE4F6Ac" + "UAZwuAYAAAgBBAQ=="); axGraph1.AutoFit = true; EXGRAPHLib.Serie var_Serie = axGraph1.Series.Add("Pacific Ocean(16525), Atlantic Ocean(10646), Indian Ocean(7056), Southern Ocean(2033), Arctic Ocean(1406)",null); var_Serie.Color = 16777216; var_Serie.Vertical = true; axGraph1.EndUpdate(); |
203 |
Display columns using EBN colors
axGraph1.BeginUpdate(); axGraph1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); axGraph1.AutoFit = true; axGraph1.Series.Add("Pacific Ocean(16525), Atlantic Ocean(10646), Indian Ocean(7056), Southern Ocean(2033), Arctic Ocean(1406)",null).Color = 16777216; axGraph1.EndUpdate(); |
202 |
Show images
axGraph1.BeginUpdate(); axGraph1.set_HTMLPicture("china","c:\\exontrol\\images\\zipdisk.gif"); axGraph1.set_HTMLPicture("india","c:\\exontrol\\images\\auction.gif"); axGraph1.set_HTMLPicture("usa","c:\\exontrol\\images\\colorize.gif"); axGraph1.set_Misc(EXGRAPHLib.MiscEnum.exShowValueIf,0); axGraph1.set_Misc(EXGRAPHLib.MiscEnum.exShowLabelsIf,0); axGraph1.ValueSize = 32; EXGRAPHLib.CategoryAxis var_CategoryAxis = axGraph1.CategoryAxis; var_CategoryAxis.Categories = "<img>china</img>,<img>india</img>,<img>usa</img>"; var_CategoryAxis.MajorGridLines.Color = "lightgray"; axGraph1.Series.Add("1410,1390,331",null); axGraph1.EndUpdate(); |
201 |
Shows a custom tooltip
|