359 |
Can I drag and drop the entire column to move the data instead of dragging the individual value point (for a single series)
' MoveValue event - Notifies the application when a user performs a drag-and-drop operation to move a category, series, or data value. Private Sub Exgraph1_MoveValue(ByVal sender As System.Object) Handles Exgraph1.MoveValue With Exgraph1 Debug.Print( .Series.Item(0).Data ) End With End Sub With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = &H700 Or exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .ValuePoint = "1,transparent,transparent" .CategoryAxis.Categories = "Stanzen,Biegen,Beschichten,Vormontage" With .Series With .Add("1,2,3,4") .Color = "blue" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exHitTestRect Or exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With End With .EndUpdate() End With |
358 |
Hide the value-points (method 2, no tooltip)
With Exgraph1 .BeginUpdate() .AutoFit = True With .CategoryAxis .Categories = "Germany,France,Japan,Canada,Australia,Mexico," .MajorGridLines.Color = "lightgray" End With With .Series.Add("1600,1450,1250,900,800,750") .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exHitTestRect Or exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With .ValuePoint = "0" .EndUpdate() End With |
357 |
Hide the value-points (method 1)
With Exgraph1 .BeginUpdate() .AutoFit = True With .CategoryAxis .Categories = "Germany,France,Japan,Canada,Australia,Mexico," .MajorGridLines.Color = "lightgray" End With With .Series.Add("1600,1450,1250,900,800,750") .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exHitTestRect Or exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With .ValuePoint = "1,transparent,transparent" .EndUpdate() End With |
356 |
Can the tooltip be displayed when the pointer hovers over the entire column, rather than only over the individual value-point
With Exgraph1 .BeginUpdate() .AutoFit = True With .CategoryAxis .Categories = "China,India,United States,Indonesia,Pakistan,Brazil," .MajorGridLines.Color = "lightgray" End With With .Series.Add("1410,1390,331,276,225,213") .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exHitTestRect Or exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With .EndUpdate() End With |
355 |
Add markers to the graph by selecting specific points and attaching custom text annotations to them. These annotations are applied only to chosen points in the series, not to all points
With Exgraph1 .BeginUpdate() .AutoFit = True With .CategoryAxis .Categories = "China,India,United States,Indonesia,Pakistan,Brazil," .MajorGridLines.Color = "lightgray" End With With .Series.Add("1410,1390,331,276,225,213") .ShowValue = &Hfffffe78 Or exontrol.EXGRAPHLib.ShowValueEnum.exHitTestRect Or exontrol.EXGRAPHLib.ShowValueEnum.exHideIfEmpty Or exontrol.EXGRAPHLib.ShowValueEnum.exValue Or exontrol.EXGRAPHLib.ShowValueEnum.exLine Or exontrol.EXGRAPHLib.ShowValueEnum.exPoint .ValueFormat = "index = 0 ? (category + `:` + value) : ``" End With .EndUpdate() End With |
354 |
Can I move the data by drag and drop (single serie)
' MoveValue event - Notifies the application when a user performs a drag-and-drop operation to move a category, series, or data value. Private Sub Exgraph1_MoveValue(ByVal sender As System.Object) Handles Exgraph1.MoveValue With Exgraph1 Debug.Print( .Series.Item(0).Data ) End With End Sub With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = &H700 Or exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .ValuePoint = "12,white,black" .CategoryAxis.Categories = "Stanzen,Biegen,Beschichten,Vormontage" With .Series .set_Def(exontrol.EXGRAPHLib.DefSerieEnum.exSerieShowValue,1) .Add("1,2,3,4").Color = "blue" End With .EndUpdate() End With |
353 |
Can I move the data by drag and drop (multiple stacked-series)
' MoveValue event - Notifies the application when a user performs a drag-and-drop operation to move a category, series, or data value. Private Sub Exgraph1_MoveValue(ByVal sender As System.Object) Handles Exgraph1.MoveValue With Exgraph1 Debug.Print( .Series.get_ItemByPos(0).Data ) Debug.Print( .Series.get_ItemByPos(1).Data ) End With End Sub With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = &H700 Or exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .ValuePoint = "12,white,black" .CategoryAxis.Categories = "Stanzen,Biegen,Beschichten,Vormontage" With .Series .set_Def(exontrol.EXGRAPHLib.DefSerieEnum.exSerieStack,"A") .set_Def(exontrol.EXGRAPHLib.DefSerieEnum.exSerieShowValue,1) .Add("3").Color = 13210715 .Add("5").Color = 3178478 .Add("2").Color = 10987431 .Add(",3").Color = 902143 .Add(",2").Color = 13661253 .Add(",,8").Color = 4631920 .Add(",,3").Color = 9396258 .Add(",,,4").Color = 870558 .Add(",,,4").Color = 6513507 .Add(",,,2").Color = 29592 End With .EndUpdate() End With |
352 |
Defines the default value assigned to a particular property when a new series is created
With Exgraph1 .BeginUpdate() .AutoFit = True .Legend.Visible = True .CategoryAxis.Categories = "Stanzen,Biegen,Beschichten,Vormontage" With .Series .set_Def(exontrol.EXGRAPHLib.DefSerieEnum.exSerieStack,"A") .Add("3").Color = "RGB(91,148,201)" .Add("5").Color = "RGB(238,127,48)" .Add("2").Color = "RGB(167,167,167)" .Add(",3").Color = "RGB(255,195,13)" .Add(",2").Color = "RGB(69,116,208)" .Add(",,8").Color = "RGB(112,173,70)" .Add(",,3").Color = "RGB(34,96,143)" .Add(",,,4").Color = "RGB(158,72,13)" .Add(",,,4").Color = "RGB(99,99,99)" .Add(",,,2").Color = "RGB(152,115,0)" End With .EndUpdate() End With |
351 |
Is it possible to reorder just the series by drag and drop
With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = &H300 Or exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .CategoryAxis.MajorGridLines.Color = "lightgray" With .Series With .Add("Electronics(350),Clothing(200),Books(150)",2001) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With With .Add("Electronics(500),Clothing(150),Books(180)",2002) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With End With .ValuePoint = "16,white,black" .Legend.Visible = True .EndUpdate() End With |
350 |
Is it possible to reorder just the values/categories by drag and drop (method 2)
With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .CategoryAxis.MajorGridLines.Color = "lightgray" With .Series With .Add("Electronics(350),Clothing(200),Books(150)",2001) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With With .Add("Electronics(500),Clothing(150),Books(180)",2002) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With End With .ValuePoint = "16,white,black" .Legend.Visible = True .EndUpdate() End With |
349 |
Is it possible to reorder just the values/categories by drag and drop (method 1)
With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .CategoryAxis.MajorGridLines.Color = "lightgray" With .Series With .Add("Electronics(350),Clothing(200),Books(150)",2001) .Stack = "A" End With With .Add("Electronics(500),Clothing(150),Books(180)",2002) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With End With .ValuePoint = "16,white,black" .Legend.Visible = True .EndUpdate() End With |
348 |
Is it possible to reorder the series and values/categories by drag and drop
With Exgraph1 .BeginUpdate() .AutoFit = True .AllowMoveValue = &H200 Or exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .CategoryAxis.MajorGridLines.Color = "lightgray" With .Series With .Add("Electronics(350),Clothing(200),Books(150)",2001) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With With .Add("Electronics(500),Clothing(150),Books(180)",2002) .Stack = "A" .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With End With .ValuePoint = "16,white,black" .Legend.Visible = True .EndUpdate() End With |
347 |
Is it possible to reorder the values by drag and drop
With Exgraph1 .BeginUpdate() .AutoFit = True .ValueAxis.Format = "value/100000" With .Series.Add("Tokyo(37833000), Delhi(30290000), Shanghai(27058000), São Paulo(22043000), Mumbai(20668000), Beijing(20384000), Karachi(2000000" & _ "0), Dhaka(17072000), Istanbul(15029000), Los Angeles(13131000)") .ShowValue = exontrol.EXGRAPHLib.ShowValueEnum.exPoint End With .ValuePoint = "12,white,black" .AllowMoveValue = exontrol.EXGRAPHLib.AllowKeysEnum.exLeftClick .EndUpdate() End With |
346 |
Reorder multiple values
With Exgraph1 .BeginUpdate() .AutoFit = True .MultiColorSerie = False .Series.Add("1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)","GDP") .Order = ",4,,3" .EndUpdate() End With |
345 |
Move a value to an earlier or later position
With Exgraph1 .BeginUpdate() .AutoFit = True .MultiColorSerie = False .Series.Add("1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)","GDP") .Order = ",,3" .EndUpdate() End With |
344 |
Place one value at a specified position
With Exgraph1 .BeginUpdate() .AutoFit = True .MultiColorSerie = False .Series.Add("1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)","GDP") .Order = "3" .EndUpdate() End With |
343 |
Configure the Y-axis so that it always displays exactly 5 labels (fixed-ticks), regardless of the data range
|
342 |
Define the style(solid, dash, dot, dash-dot, dash-dot-dot) of the line to show the serie
|
341 |
I'm using the logarithmic scale, but it's not displaying any values. How can I adjust the settings to show very small values
|
340 |
My data contains no values below 1. How can I prevent the logarithmic value axis from displaying the range between 0 and 1
|
339 |
Display logarithmic scale
|
338 |
Can the values be shown in scientific notation (e.g., 1E+4, 5E-10) rather than full decimal form
|
337 |
Highlight the value on both the chart and the axis
|
336 |
Highlight the categories on both the chart and the axis
|
335 |
Highlight values on axis only
|
334 |
Highlight the categories on axis only
|
333 |
Highlight values
|
332 |
Highlight the categories using an expression
|
331 |
Highlight the categories using an expression
|
330 |
Highlight the categories based on the index
|
329 |
IdemmM {string}, specifies the name of another value-axis to synchronize min, max, and major-unit values from when scrolling. If omitted or the value-axis with the given name is not found, these values are synchronized with the default value-axis
|
328 |
Adds multiple value-axes
|
327 |
Split the chart in weeks
|
326 |
Resets the series, category axes and value axes without affecting the control's data
' Click event - Occurs when the user presses and then releases the left mouse button over the control. Private Sub Exgraph1_Click(ByVal sender As System.Object) Handles Exgraph1.Click With Exgraph1 .Reset() End With End Sub With Exgraph1 .BeginUpdate() .ValueSize = 18 .Import("C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt") .SerieType = "line" With .Series.Add() .Name = "aapl" .Data = "AAPL (open),AAPL (high),AAPL (low),AAPL (close)" End With With .CategoryAxes.Add("0") .Format = "value mid 9 left 2" End With With .CategoryAxes.Add("0") .Format = "value left 7" .Split = True End With .EndUpdate() End With |
325 |
Define the representation method for the data in all series where the type property is not specified, determining how these series are visually displayed
|
324 |
How can I prevent the labels from rotating around the chart when using the radarColumn type
|
323 |
Disable stacking for all series at once
|
322 |
How can I stack more than three data series across multiple columns
|
321 |
How can I stack data more than three series
|
320 |
I use the legend, but clicking a series mostly rearranges them instead of hiding it
With Exgraph1 .BeginUpdate() .AutoFit = True .set_Misc(exontrol.EXGRAPHLib.MiscEnum.exNewLayoutOnVisibleChange,False) .Series.Add("50,150,150,300","A1") .Series.Add("180,40,60,160","A2") .Legend.Visible = True .EndUpdate() End With |
319 |
Adjusts the column/bar size so that the entire chart fits within the client rectangle
|
318 |
The categories overlap, making the text unreadable
|
317 |
Represents a single serie with single color (prevent multiple colors for single-serie)
|
316 |
How can I replace or add an icon at runtime
|
315 |
No grid lines are shown even I set the Color and Format properties of ChartGridLines/OverviewGridLines
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|