|
351
|
Is it possible to reorder just the series by drag and drop
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComAllowMoveValue to (|CI$100 + OLEexLeftClick)
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Electronics(350),Clothing(200),Books(150)" 2001 to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "A"
Set ComShowValue of hoSerie to OLEexPoint
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "Electronics(500),Clothing(150),Books(180)" 2002 to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "A"
Set ComShowValue of hoSerie1 to OLEexPoint
Send Destroy to hoSerie1
Send Destroy to hoSeries
Set ComValuePoint to "16,white,black"
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
350
|
Is it possible to reorder just the values by drag and drop (method 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComAllowMoveValue to (|CI$200 + OLEexLeftClick)
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Electronics(350),Clothing(200),Books(150)" 2001 to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "A"
Set ComShowValue of hoSerie to OLEexPoint
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "Electronics(500),Clothing(150),Books(180)" 2002 to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "A"
Set ComShowValue of hoSerie1 to OLEexPoint
Send Destroy to hoSerie1
Send Destroy to hoSeries
Set ComValuePoint to "16,white,black"
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
349
|
Is it possible to reorder just the values by drag and drop (method 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComAllowMoveValue to OLEexLeftClick
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Electronics(350),Clothing(200),Books(150)" 2001 to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "A"
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "Electronics(500),Clothing(150),Books(180)" 2002 to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "A"
Set ComShowValue of hoSerie1 to OLEexPoint
Send Destroy to hoSerie1
Send Destroy to hoSeries
Set ComValuePoint to "16,white,black"
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
348
|
Is it possible to reorder the series and values by drag and drop
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComAllowMoveValue to OLEexLeftClick
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Electronics(350),Clothing(200),Books(150)" 2001 to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "A"
Set ComShowValue of hoSerie to OLEexPoint
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "Electronics(500),Clothing(150),Books(180)" 2002 to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "A"
Set ComShowValue of hoSerie1 to OLEexPoint
Send Destroy to hoSerie1
Send Destroy to hoSeries
Set ComValuePoint to "16,white,black"
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
347
|
Is it possible to reorder the values by drag and drop
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComFormat of hoValueAxis to "value/100000"
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Tokyo(37833000), Delhi(30290000), Shanghai(27058000), São Paulo(22043000), Mumbai(20668000), Beijing(20384000), Karachi(20000000), Dhaka(17072000), Istanbul(15029000), Los Angeles(13131000)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComShowValue of hoSerie to OLEexPoint
Send Destroy to hoSerie
Send Destroy to hoSeries
Set ComValuePoint to "12,white,black"
Set ComAllowMoveValue to OLEexLeftClick
Send ComEndUpdate
End_Procedure
|
|
346
|
Reorder multiple values
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)" "GDP" to Nothing
Send Destroy to hoSeries
Set ComOrder to ",4,,3"
Send ComEndUpdate
End_Procedure
|
|
345
|
Move a value to an earlier or later position
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)" "GDP" to Nothing
Send Destroy to hoSeries
Set ComOrder to ",,3"
Send ComEndUpdate
End_Procedure
|
|
344
|
Place one value at a specified position
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)" "GDP" to Nothing
Send Destroy to hoSeries
Set ComOrder to "3"
Send ComEndUpdate
End_Procedure
|
|
343
|
Configure the Y-axis so that it always displays exactly 5 labels (fixed-ticks), regardless of the data range
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComAsPercent of hoValueAxis to True
Set ComMajorUnit of hoValueAxis to 0.2
Set ComFormat of hoValueAxis to "value*5 array (``,`A`,`B`,`C`,`D`,`E`)"
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "1960(1.4),1980(11.2),2000(33.5),2010(65.8),2020(84.7)" "GDP" to Nothing
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
342
|
Define the style(solid, dash, dot, dash-dot, dash-dot-dot) of the line to show the serie
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "1920(1.8),1945(2.3),1970(13.7),1995(5.7),2020(7.8)" "Population" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "Line"
Set ComMisc of hoSerie OLEexLineStyle to 2
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant sFormat
Move "(value and value < 1) ? (value format `%.1E` replace `-00` with ``) : (value format `0`)" to sFormat
Set ComAutoFit to True
Set ComMisc OLEexEpsilon to 0.000000001
Set ComMultiColorSerie to False
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "`<bgcolor white>` + value"
Send Destroy to hoCategoryAxis
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComType of hoValueAxis to OLEexLogarithmic
Set ComFormat of hoValueAxis to sFormat
Set ComCursorFormat of hoValueAxis to sFormat
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "12:54:28(3.14E-09),12:54:44(2.59E-09),13:03:53(4.25E-09),13:03:58(4.20E-09),13:05:00(5.10E-09),13:06:12(6.25E-09)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "line"
Set ComCursorFormat of hoSerie to sFormat
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCursor
Get ComCursor to voCursor
Handle hoCursor
Get Create (RefClass(cComCursor)) to hoCursor
Set pvComObject of hoCursor to voCursor
Set ComVisible of hoCursor to True
Send Destroy to hoCursor
Send ComEndUpdate
End_Procedure
|
|
340
|
My data contains no values below 1. How can I prevent the logarithmic value axis from displaying the range between 0 and 1
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Set ComValuePoint to ",,,,,,,black,transparent"
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "`<bgcolor white>` + value"
Send Destroy to hoCategoryAxis
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComType of hoValueAxis to OLEexLogarithmic
Set ComMin of hoValueAxis to 1
Set ComFormat of hoValueAxis to "value format `0`"
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Small village(8),Hamlet(14),Small town(22),Medium town(39),Growing town(2118),Small city(6523),Large city(31245),Capital city(431245),Mega city(65431245)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComShowValue of hoSerie to OLEexValue
Set ComValueFormat of hoSerie to "`<fgcolor white> ` + (value format `0`) + ` `"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
339
|
Display logarithmic scale
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "`<bgcolor white>` + value"
Send Destroy to hoCategoryAxis
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComType of hoValueAxis to OLEexLogarithmic
Set ComFormat of hoValueAxis to "value format `0`"
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Sterile Water(0.0001),Treated Tap Water(0.001),Bottled Water(0.01),Clean Pond(0.1),River(1),Swamp(100),Sewage(10000),Wastewater Treatment Inlet(1000000)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComCursorFormat of hoSerie to "value < 1 ? value : (value format `0`) "
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCursor
Get ComCursor to voCursor
Handle hoCursor
Get Create (RefClass(cComCursor)) to hoCursor
Set pvComObject of hoCursor to voCursor
Set ComVisible of hoCursor to True
Send Destroy to hoCursor
Send ComEndUpdate
End_Procedure
|
|
338
|
Can the values be shown in scientific notation (e.g., 1E+4, 5E-10) rather than full decimal form
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComFormat of hoValueAxis to "value/100000"
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Tokyo(37833000), Delhi(30290000), Shanghai(27058000), São Paulo(22043000), Mumbai(20668000), Beijing(20384000), Karachi(20000000), Dhaka(17072000), Istanbul(15029000), Los Angeles(13131000)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComShowValue of hoSerie to (|CI$ffffff78 + OLEexHideIfEmpty + OLEexValue + OLEexLine + OLEexPoint)
Set ComValueFormat of hoSerie to "value format `%.1E` replace `+00` with `+`"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
337
|
Highlight the value on both the chart and the axis
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComMark of hoValueAxis to "red[axis,chart](74.25-75.75),black[axis,chart](76.5)"
Send Destroy to hoValueAxis
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
336
|
Highlight the categories on both the chart and the axis
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Set ComValueSize to 6
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "value left 7"
Set ComSplit of hoCategoryAxis to True
Set ComMark of hoCategoryAxis to "#F8F8F8[axis,chart](label = `2014-02`)"
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
335
|
Highlight values on axis only
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComMark of hoValueAxis to "red[axis](74.25-75.75),black[axis](76.5)"
Send Destroy to hoValueAxis
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
334
|
Highlight the categories on axis only
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Set ComValueSize to 6
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "value left 7"
Set ComSplit of hoCategoryAxis to True
Set ComMark of hoCategoryAxis to "#F8F8F8[axis](label = `2014-02`)"
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
333
|
Highlight values
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComMark of hoValueAxis to "red(74.25-75.75),black[chart,axis](76.5)"
Send Destroy to hoValueAxis
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
332
|
Highlight the categories using an expression
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "`Wno<off-4>` + week(date(value left 10))"
Set ComSplit of hoCategoryAxis to True
Set ComMark of hoCategoryAxis to "#F8F8F8(index in (1,3))"
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
331
|
Highlight the categories using an expression
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Set ComValueSize to 6
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "value left 7"
Set ComSplit of hoCategoryAxis to True
Set ComMark of hoCategoryAxis to "#F8F8F8(label = `2014-02`)"
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
330
|
Highlight the categories based on the index
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "`Wno<off-4>` + week(date(value left 10))"
Set ComSplit of hoCategoryAxis to True
Set ComMark of hoCategoryAxis to "#F8F8F8(2)"
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Send ComRefresh
Send ComEndUpdate
End_Procedure
|
|
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
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Set ComType of hoSerie to "line"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voValueAxes
Get ComValueAxes to voValueAxes
Handle hoValueAxes
Get Create (RefClass(cComValueAxes)) to hoValueAxes
Set pvComObject of hoValueAxes to voValueAxes
Get ComAdd of hoValueAxes "1st" to Nothing
Variant voValueAxis
Get ComAdd of hoValueAxes "2nd" to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComAlign of hoValueAxis to OLEexAlignRight
Set ComIdemmM of hoValueAxis to "1st"
Send Destroy to hoValueAxis
Variant voValueAxis1
Get ComAdd of hoValueAxes "3rd" to voValueAxis1
Handle hoValueAxis1
Get Create (RefClass(cComValueAxis)) to hoValueAxis1
Set pvComObject of hoValueAxis1 to voValueAxis1
Set ComFormat of hoValueAxis1 to "120 + value * 2.5"
Variant voGridLinesOptions
Get ComMajorGridLines of hoValueAxis1 to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "transparent"
Send Destroy to hoGridLinesOptions
Send Destroy to hoValueAxis1
Send Destroy to hoValueAxes
Send ComEndUpdate
End_Procedure
|
|
328
|
Adds multiple value-axes
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (close)"
Set ComType of hoSerie to "line"
Set ComStyle of hoSerie to OLEexSpline
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voValueAxes
Get ComValueAxes to voValueAxes
Handle hoValueAxes
Get Create (RefClass(cComValueAxes)) to hoValueAxes
Set pvComObject of hoValueAxes to voValueAxes
Get ComAdd of hoValueAxes "1st" to Nothing
Variant voValueAxis
Get ComAdd of hoValueAxes "2nd" to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComAlign of hoValueAxis to OLEexAlignRight
Send Destroy to hoValueAxis
Send Destroy to hoValueAxes
Send ComEndUpdate
End_Procedure
|
|
327
|
Split the chart in weeks
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 18
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "open" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComData of hoSerie to "AAPL (open)"
Set ComType of hoSerie to "line"
Set ComStyle of hoSerie to OLEexSpline
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "value mid 9 left 2"
Variant voFormatGridLinesOptions
Get ComChartGridLines of hoCategoryAxis to voFormatGridLinesOptions
Handle hoFormatGridLinesOptions
Get Create (RefClass(cComFormatGridLinesOptions)) to hoFormatGridLinesOptions
Set pvComObject of hoFormatGridLinesOptions to voFormatGridLinesOptions
Set ComFormat of hoFormatGridLinesOptions to "`<fgcolor gray>Wno <off 4>` + week(date(value left 10))"
Set ComColor of hoFormatGridLinesOptions to "gray"
Set ComAlign of hoFormatGridLinesOptions to OLEexTextAlignLeft
Send Destroy to hoFormatGridLinesOptions
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Send ComEndUpdate
End_Procedure
|
|
326
|
Resets the series, category axes and value axes without affecting the control's data
// Occurs when the user presses and then releases the left mouse button over the control.
Procedure OnComClick
Forward Send OnComClick
Send ComReset Nothing
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 18
Get ComImport "C:\Program Files\Exontrol\ExGraph\Sample\Data/aapl.txt" Nothing to Nothing
Set ComSerieType to "line"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries Nothing Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComName of hoSerie to "aapl"
Set ComData of hoSerie to "AAPL (open),AAPL (high),AAPL (low),AAPL (close)"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "0" Nothing to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComFormat of hoCategoryAxis to "value mid 9 left 2"
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Variant voCategoryAxes1
Get ComCategoryAxes to voCategoryAxes1
Handle hoCategoryAxes1
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes1
Set pvComObject of hoCategoryAxes1 to voCategoryAxes1
Variant voCategoryAxis1
Get ComAdd of hoCategoryAxes1 "0" Nothing to voCategoryAxis1
Handle hoCategoryAxis1
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis1
Set pvComObject of hoCategoryAxis1 to voCategoryAxis1
Set ComFormat of hoCategoryAxis1 to "value left 7"
Set ComSplit of hoCategoryAxis1 to True
Send Destroy to hoCategoryAxis1
Send Destroy to hoCategoryAxes1
Send ComEndUpdate
End_Procedure
|
|
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
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Set ComAutoFit to True
Set ComSerieType to "rangeArea"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "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" to Nothing
Get ComAdd of hoSeries "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" to Nothing
Send Destroy to hoSeries
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
324
|
How can I prevent the labels from rotating around the chart when using the radarColumn type
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Set ComAutoFit to True
Set ComSerieType to "radarCol"
Set ComMisc OLEexRadialRotateLabels to False
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "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" to Nothing
Get ComAdd of hoSeries "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" to Nothing
Send Destroy to hoSeries
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
323
|
Disable stacking for all series at once
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Set ComAutoFit to True
Set ComAllowStack to False
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "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" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "group"
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "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" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "group"
Send Destroy to hoSerie1
Send Destroy to hoSeries
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
322
|
How can I stack more than three data series across multiple columns
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Set ComAutoFit to True
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Chinese(9.165),Spanish(4.355),English(3.185),Hindi(2.73),Arabic(2.665),Bengali(2.145),Portuguese(1.885),Russian(1.82),Japanese(1.105),Lahnda(1.04)" "Male" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "G1"
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "Chinese(4.935),Spanish(2.345),English(1.715),Hindi(1.47),Arabic(1.435),Bengali(1.155),Portuguese(1.015),Russian(0.98),Japanese(0.595),Lahnda(0.56)" "Female" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "G1"
Send Destroy to hoSerie1
Variant voSerie2
Get ComAdd of hoSeries "Chinese(3.5),Spanish(2.0),English(1.8),Hindi(0.5),Arabic(0.4),Bengali(0.3),Portuguese(0.7),Russian(1.2),Japanese(0.4),Lahnda(0.2)" "Europe" to voSerie2
Handle hoSerie2
Get Create (RefClass(cComSerie)) to hoSerie2
Set pvComObject of hoSerie2 to voSerie2
Set ComStack of hoSerie2 to "G2"
Send Destroy to hoSerie2
Variant voSerie3
Get ComAdd of hoSeries "Chinese(8.0),Spanish(0.5),English(1.0),Hindi(3.0),Arabic(2.5),Bengali(2.0),Portuguese(0.2),Russian(1.0),Japanese(1.0),Lahnda(0.5)" "Asia" to voSerie3
Handle hoSerie3
Get Create (RefClass(cComSerie)) to hoSerie3
Set pvComObject of hoSerie3 to voSerie3
Set ComStack of hoSerie3 to "G2"
Send Destroy to hoSerie3
Variant voSerie4
Get ComAdd of hoSeries "Chinese(1.0),Spanish(3.5),English(1.5),Hindi(0.2),Arabic(0.5),Bengali(0.1),Portuguese(1.5),Russian(0.1),Japanese(0.1),Lahnda(0.1)" "America" to voSerie4
Handle hoSerie4
Get Create (RefClass(cComSerie)) to hoSerie4
Set pvComObject of hoSerie4 to voSerie4
Set ComStack of hoSerie4 to "G2"
Send Destroy to hoSerie4
Variant voSerie5
Get ComAdd of hoSeries "Chinese(0.1),Spanish(0.1),English(0.3),Hindi(0.1),Arabic(0.1),Bengali(0.1),Portuguese(0.1),Russian(0.1),Japanese(0.1),Lahnda(0.1)" "Australia" to voSerie5
Handle hoSerie5
Get Create (RefClass(cComSerie)) to hoSerie5
Set pvComObject of hoSerie5 to voSerie5
Set ComStack of hoSerie5 to "G2"
Send Destroy to hoSerie5
Variant voSerie6
Get ComAdd of hoSeries "Chinese(1.5),Spanish(0.6),English(0.3),Hindi(0.4),Arabic(0.6),Bengali(0.8),Portuguese(0.4),Russian(0.4),Japanese(0.1),Lahnda(0.5)" "Others" to voSerie6
Handle hoSerie6
Get Create (RefClass(cComSerie)) to hoSerie6
Set pvComObject of hoSerie6 to voSerie6
Set ComStack of hoSerie6 to "G2"
Send Destroy to hoSerie6
Send Destroy to hoSeries
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
321
|
How can I stack data more than three series
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Set ComAutoFit to True
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "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" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComStack of hoSerie to "group"
Send Destroy to hoSerie
Variant voSerie1
Get ComAdd of hoSeries "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" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComStack of hoSerie1 to "group"
Send Destroy to hoSerie1
Variant voSerie2
Get ComAdd of hoSeries "Chinese(1.5),Spanish(10.2),English(2.1),Hindi(0.5),Arabic(0.8),Bengali(0.3),Portuguese(3.5),Russian(0.4),Japanese(0.2),Lahnda(0.1)" "Regional" to voSerie2
Handle hoSerie2
Get Create (RefClass(cComSerie)) to hoSerie2
Set pvComObject of hoSerie2 to voSerie2
Set ComStack of hoSerie2 to "group"
Send Destroy to hoSerie2
Send Destroy to hoSeries
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
320
|
I use the legend, but clicking a series mostly rearranges them instead of hiding it
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMisc OLEexNewLayoutOnVisibleChange to False
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "50,150,150,300" "A1" to Nothing
Send Destroy to hoSeries
Variant voSeries1
Get ComSeries to voSeries1
Handle hoSeries1
Get Create (RefClass(cComSeries)) to hoSeries1
Set pvComObject of hoSeries1 to voSeries1
Get ComAdd of hoSeries1 "180,40,60,160" "A2" to Nothing
Send Destroy to hoSeries1
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
319
|
Adjusts the column/bar size so that the entire chart fits within the client rectangle
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "Asia,Africa,Europe,North America,Antarctica,South America,Australia/Oceania"
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "4600,1300,747,579,0,422,42" Nothing to Nothing
Send Destroy to hoSeries
Send ComValueAutoFit
Send ComEndUpdate
End_Procedure
|
|
318
|
The categories overlap, making the text unreadable
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 32
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "Asia,Africa,Europe,North America,Antarctica,South America,Australia/Oceania"
Set ComFormat of hoCategoryAxis to "`<bgcolor white>` + value"
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "4600,1300,747,579,0,422,42" Nothing to Nothing
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
317
|
Represents a single serie with single color (prevent multiple colors for single-serie)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComAutoFit to True
Set ComMultiColorSerie to False
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "Electronics(350),Clothing(200),Books(150)" 2001 to Nothing
Send Destroy to hoSeries
Variant voLegend
Get ComLegend to voLegend
Handle hoLegend
Get Create (RefClass(cComLegend)) to hoLegend
Set pvComObject of hoLegend to voLegend
Set ComVisible of hoLegend to True
Send Destroy to hoLegend
Send ComEndUpdate
End_Procedure
|
|
316
|
How can I replace or add an icon at runtime
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Get ComReplaceIcon "gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+OkYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==" Nothing to Nothing
Get ComReplaceIcon "C:\images\favicon.ico" 0 to Nothing
Set ComAutoFit to True
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "<img>1</img>Asia(4600),<img>2</img>Africa(1300),<img>3</img>Europe(747),<img>4</img>North America(579),<img>5</img>South America(433),<img>6</img>Australia/Oceania(42)" Nothing to Nothing
Send Destroy to hoSeries
Set ComSeriesColors to "blue"
Send ComEndUpdate
End_Procedure
|
|
315
|
No grid lines are shown even I set the Color and Format properties of ChartGridLines/OverviewGridLines
Procedure OnCreate
Forward Send OnCreate
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Get ComAdd of hoSeries "100,200,200,400" "S1" to Nothing
Send Destroy to hoSeries
Variant voSeries1
Get ComSeries to voSeries1
Handle hoSeries1
Get Create (RefClass(cComSeries)) to hoSeries1
Set pvComObject of hoSeries1 to voSeries1
Get ComAdd of hoSeries1 "210,20,20,120" "S2" to Nothing
Send Destroy to hoSeries1
Variant voCategoryAxes
Get ComCategoryAxes to voCategoryAxes
Handle hoCategoryAxes
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes
Set pvComObject of hoCategoryAxes to voCategoryAxes
Variant voCategoryAxis
Get ComAdd of hoCategoryAxes "A,B,C,D" "1st" to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Variant voFormatGridLinesOptions
Get ComChartGridLines of hoCategoryAxis to voFormatGridLinesOptions
Handle hoFormatGridLinesOptions
Get Create (RefClass(cComFormatGridLinesOptions)) to hoFormatGridLinesOptions
Set pvComObject of hoFormatGridLinesOptions to voFormatGridLinesOptions
Set ComColor of hoFormatGridLinesOptions to "red"
Set ComFormat of hoFormatGridLinesOptions to "value"
Send Destroy to hoFormatGridLinesOptions
Send Destroy to hoCategoryAxis
Send Destroy to hoCategoryAxes
Variant voCategoryAxes1
Get ComCategoryAxes to voCategoryAxes1
Handle hoCategoryAxes1
Get Create (RefClass(cComCategoryAxes)) to hoCategoryAxes1
Set pvComObject of hoCategoryAxes1 to voCategoryAxes1
Get ComAdd of hoCategoryAxes1 "E,F" "2nd" to Nothing
Send Destroy to hoCategoryAxes1
Send ComRefresh
End_Procedure
|
|
314
|
Occasionally, the margins of the axes may not align perfectly with the view
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 18
Set ComPad to 24
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Set ComFormat of hoValueAxis to "value format `0`"
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Hulunbuir{China}(263068),Abu Dhabi{United Arab Emirates}(97200),Jiuquan{China}(167996),Altamira{Brazil}(159891),Brasília{Brazil}(5784),Mumbai{India}(603.4),Delhi{India}(1484),Chongqing{China}(82400),Hulunbuir{China}(263068),Sao Paulo{Brazil}(1522),Linfen{China}(20527),Santiago{Chile}(641),Mexico City{Mexico}(1485),Belo Horizonte{Brazil}(313),Hangzhou{China}(16817),Nairobi{Kenya}(696),Berlin{Germany}(891.68),Montreal{Canada}(431.5),Cordoba{Argentina}(576),Manaus{Brazil}(11401),Astana{Kazakhstan}(810),Goiânia{Brazil}(741),Cali{Colombia}(564),Sao Paulo{Brazil}(1522),Goiania{Brazil}(781)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "Col"
Set ComVertical of hoSerie to True
Send Destroy to hoSerie
Send Destroy to hoSeries
Set ComSort to "0:D"
Send ComEndUpdate
End_Procedure
|
|
313
|
"candlestick" explained, an [open,high,low,close] chart
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 32
Set ComValuePoint to "0,,,,lightgray,1"
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoValueAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComStep of hoGridLinesOptions to 4
Send Destroy to hoGridLinesOptions
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "One(79.38 79.57 78.86 79.01)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "candlestick"
Set ComShowValue of hoSerie to (OLEexValue + OLEexLine + OLEexPoint)
Set ComValueFormat of hoSerie to "(inner array (`<b>open`,`<fgcolor gray>high`,`<fgcolor gray>low`,`<b>close`)) + ` ` + value"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 18
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "Date"
Set ComFormat of hoCategoryAxis to "value mid 9 left 2"
Send Destroy to hoCategoryAxis
Set ComData to "C:\Program Files\Exontrol\ExGraph\Sample\Data/msft.csv"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Open,High,Low,Close" "msft" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "candlestick"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
311
|
"ohlc" explained, an [open,high,low,close] chart
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 32
Set ComValuePoint to "0,,,,lightgray,1"
Variant voValueAxis
Get ComValueAxis to voValueAxis
Handle hoValueAxis
Get Create (RefClass(cComValueAxis)) to hoValueAxis
Set pvComObject of hoValueAxis to voValueAxis
Variant voGridLinesOptions
Get ComMajorGridLines of hoValueAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComStep of hoGridLinesOptions to 4
Send Destroy to hoGridLinesOptions
Send Destroy to hoValueAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "One(79.38 79.57 78.86 79.01)" Nothing to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "ohlc"
Set ComShowValue of hoSerie to (OLEexValue + OLEexLine + OLEexPoint)
Set ComValueFormat of hoSerie to "(inner array (`<b>open`,`<fgcolor gray>high`,`<fgcolor gray>low`,`<b>close`)) + ` ` + value"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComValueSize to 18
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "Date"
Set ComFormat of hoCategoryAxis to "value mid 9 left 2"
Send Destroy to hoCategoryAxis
Set ComData to "C:\Program Files\Exontrol\ExGraph\Sample\Data/msft.csv"
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "Open,High,Low,Close" "msft" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "ohlc"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "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" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "bubble"
Set ComMisc of hoSerie OLEexScatterPlotSize to 32
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voSeries1
Get ComSeries to voSeries1
Handle hoSeries1
Get Create (RefClass(cComSeries)) to hoSeries1
Set pvComObject of hoSeries1 to voSeries1
Variant voSerie1
Get ComAdd of hoSeries1 "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" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComType of hoSerie1 to "bubble"
Set ComMisc of hoSerie1 OLEexScatterPlotSize to 32
Send Destroy to hoSerie1
Send Destroy to hoSeries1
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "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" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "scatter"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voSeries1
Get ComSeries to voSeries1
Handle hoSeries1
Get Create (RefClass(cComSeries)) to hoSeries1
Set pvComObject of hoSeries1 to voSeries1
Variant voSerie1
Get ComAdd of hoSeries1 "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" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComType of hoSerie1 to "scatter"
Send Destroy to hoSerie1
Send Destroy to hoSeries1
Send ComEndUpdate
End_Procedure
|
|
307
|
"scatterline", curved
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "1 25,2 49,3 70,4 86,5 96,6 100,7 96,8 86,9 70,10 49,11 25" "Bell" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "scatterline"
Set ComStyle of hoSerie to OLEexSpline
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "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" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "scatterline"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voSeries1
Get ComSeries to voSeries1
Handle hoSeries1
Get Create (RefClass(cComSeries)) to hoSeries1
Set pvComObject of hoSeries1 to voSeries1
Variant voSerie1
Get ComAdd of hoSeries1 "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" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComType of hoSerie1 to "scatterline"
Send Destroy to hoSerie1
Send Destroy to hoSeries1
Send ComEndUpdate
End_Procedure
|
|
305
|
"scatterarea", curved
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "1 25,2 49,3 70,4 86,5 96,6 100,7 96,8 86,9 70,10 49,11 25" "Bell" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "scatterarea"
Set ComStyle of hoSerie to OLEexSpline
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComPad to 18
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "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" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "scatterarea"
Send Destroy to hoSerie
Send Destroy to hoSeries
Variant voSeries1
Get ComSeries to voSeries1
Handle hoSeries1
Get Create (RefClass(cComSeries)) to hoSeries1
Set pvComObject of hoSeries1 to voSeries1
Variant voSerie1
Get ComAdd of hoSeries1 "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" to voSerie1
Handle hoSerie1
Get Create (RefClass(cComSerie)) to hoSerie1
Set pvComObject of hoSerie1 to voSerie1
Set ComType of hoSerie1 to "scatterarea"
Send Destroy to hoSerie1
Send Destroy to hoSeries1
Send ComEndUpdate
End_Procedure
|
|
303
|
"polarscatter", shows the serie as non-connected data points (data requires array of array of two-numbers, such as [[angle, value]], non-scrollable)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComMisc OLEexRadialRotateLabels to False
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "45,90,135,180,225,270,315,360"
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "0 0,15 2,30 4,45 6,60 8,75 10,90 12,105 14,120 16,135 18,150 20,165 22,180 24,195 26,210 28,225 30,240 32,255 34,270 36,285 38,300 40,315 42,330 44,345 46,360 48,15 50,30 52,45 54,60 56,75 58,90 60" "Spiral" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "polarscatter"
Set ComColor of hoSerie to "red"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
302
|
"polarline", represents data points connected with straight line segments (data requires array of array of two-numbers, such as [[angle, value]], non-scrollable)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComMisc OLEexRadialRotateLabels to False
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "45,90,135,180,225,270,315,360"
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "0 0,15 2,30 4,45 6,60 8,75 10,90 12,105 14,120 16,135 18,150 20,165 22,180 24,195 26,210 28,225 30,240 32,255 34,270 36,285 38,300 40,315 42,330 44,345 46,360 48,15 50,30 52,45 54,60 56,75 58,90 60" "Spiral" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "polarLine"
Set ComColor of hoSerie to "red"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|
|
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)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComMisc OLEexRadialRotateLabels to False
Variant voCategoryAxis
Get ComCategoryAxis to voCategoryAxis
Handle hoCategoryAxis
Get Create (RefClass(cComCategoryAxis)) to hoCategoryAxis
Set pvComObject of hoCategoryAxis to voCategoryAxis
Set ComCategories of hoCategoryAxis to "45,90,135,180,225,270,315,360"
Variant voGridLinesOptions
Get ComMajorGridLines of hoCategoryAxis to voGridLinesOptions
Handle hoGridLinesOptions
Get Create (RefClass(cComGridLinesOptions)) to hoGridLinesOptions
Set pvComObject of hoGridLinesOptions to voGridLinesOptions
Set ComColor of hoGridLinesOptions to "lightgray"
Send Destroy to hoGridLinesOptions
Send Destroy to hoCategoryAxis
Variant voSeries
Get ComSeries to voSeries
Handle hoSeries
Get Create (RefClass(cComSeries)) to hoSeries
Set pvComObject of hoSeries to voSeries
Variant voSerie
Get ComAdd of hoSeries "0 0,15 2,30 4,45 6,60 8,75 10,90 12,105 14,120 16,135 18,150 20,165 22,180 24,195 26,210 28,225 30,240 32,255 34,270 36,285 38,300 40,315 42,330 44,345 46,360 48,15 50,30 52,45 54,60 56,75 58,90 60" "Spiral" to voSerie
Handle hoSerie
Get Create (RefClass(cComSerie)) to hoSerie
Set pvComObject of hoSerie to voSerie
Set ComType of hoSerie to "polarArea"
Set ComColor of hoSerie to "lime"
Send Destroy to hoSerie
Send Destroy to hoSeries
Send ComEndUpdate
End_Procedure
|