Graph and charts in autoit

[rony2006]

Hello,

How can I show in a gui some charts and graphs?

I know that is possible to export the data to excel cells and make there a chart, but is possible to do this without opening the excel?

[UEZ]

Ever tried to use the search function?

[rony2006]

@UEZ Yes, but most of them refer to Excel. And I want to see the graph in the gui not on the excel.

Also I found something with flash/xml but looks like to complicated and is not free

[water]

You could create the chart in Excel, export it as jpeg/png etc. and then include it in a GUI. The Excel part can be run hidden if needed.

[rony2006]

@water Doesn't sound to bad if the excel part can be hidden. But you can see it in the taskbar?

 

Do you have a starting point?

 

[water]

You wouldn't see it in the taskbar. Use the Excel UDF and set parameter $bVisible = False in function _Excel_Open.

[UEZ]

https://autoit.de/index.php/Thread/83088-Balkendiagramme-Charts-in-Gui-darstellen-UDF

 

 

 

[rony2006]

@UEZ Vielen Dank!

[mikell]

Don't know if this is what you are looking for but there is a very nice example by taietel here :

 

[UEZ]

2 minutes ago, rony2006 said:

@UEZ Vielen Dank!

Bitte.

Or this one: 

 

[mikell]

Nice find UEZ  

[InunoTaishou]

Does this work?

expandcollapse popup

#include <GUIConstants.au3>
#include <String.au3>

Global $hMain = GUICreate("Graph", 500, 300)
Global $lblY = GUICtrlCreateLabel("", 75, 20, 2, 240)
Global $lblX = GUICtrlCreateLabel("", 75, 260, 375, 2)
Global $lblTitle = GUICtrlCreateLabel("Some random graph", 225, 10, 0, 20)
Global $lblGood = GUICtrlCreateLabel("Good Side", 85, 265)
Global $lblBarGood = GUICtrlCreateLabel("", 110, 242, 20, 260 - 242)
Global $lblBad = GUICtrlCreateLabel("Bade Side", 225, 265)
Global $lblBarBad = GUICtrlCreateLabel("", 250, 53, 20, 260 - 53)
Global $iStart = 0

For $i = 260 to 10 Step -20
    Local $sMark = $iStart
    $iStart += 10
    ConsoleWrite(_StringRepeat(" ", 3 - StringLen($sMark)) & $sMark & @CRLF)
    GUICtrlCreateLabel(_StringRepeat(" ", 3 - StringLen($sMark)) & $sMark, 45, $i - 5, 25)
    GUICtrlSetFont(-1, 9, 400, 0, "Consolas")
    GUICtrlCreateLabel("", 70, $i, 5, 2)
    GUICtrlSetBkColor(-1, 0x000000)
Next

GUICtrlSetFont($lblTitle, 10, 400, 0, "Arial")
GUICtrlSetBkColor($lblBarGood, 0x00FF00)
GUICtrlSetBkColor($lblBarBad, 0xFF0000)
GUICtrlSetBkColor($lblY, 0x000000)
GUICtrlSetBkColor($lblX, 0x000000)

GUISetState(@SW_SHOW, $hMain)

While (True)
    Switch (GUIGetMsg())
        Case $GUI_EVENT_CLOSe
            Exit 0
    EndSwitch
WEnd

 

[mLipok]

2 hours ago, InunoTaishou said:

Does this work?

For me very good.

btw.
Here
https://www.autoitscript.com/wiki/User_Defined_Functions

You can find 6 different "Chart" UDF's

 

[rony2006]

21 hours ago, water said:

You could create the chart in Excel, export it as jpeg/png etc. and then include it in a GUI. The Excel part can be run hidden if needed.

@water I tried your UDF for Excel Chart but if I run any script I get the error like this: 

Why is this happening? I copied ExcelChart and ExcelChartConstants to the include directory.

If I run from help file a exemple from _Excel_RangeWrite , is working ok.

[water]

Which version of AutoIt do you run?

[rony2006]

3.3.14.2

[water]

Then you ned a COM error handler. The UDF has been written for older versions of AutoIt. 3.3.14.x changed the way COM errors are handled. 
Simply add a COM error handler that sets @error.
Check the Excel UDF. The error handler is set in every function but for your script it should should be fine to do it before calling the first ExcelChart function.