How to draw nice graph / charts

[pinkfoyd]

Hi all,

 

For my work, i need to produce automatically chart that i will include in my morning email.

 

First I tried the graph function of powershell with Microsoft Chart Controls , very nice looking, with help of this script : https://gallery.technet.microsoft.com/Drawing-charts-with-6ab5de4e#content

BUT is useless as i can't sort data in graph ( object array is ***** in powershell, order is random )

 

So trying back with autoit.

After lot of forum research :

 

• RMChart : not working
• Another script not working, or working but only in autoit GUI ( or can't find the good topic )
• Chart.udf : nice but not in GDI so can't produce image
• ImageMagick : possible but very hard to code the entire line

can't use excel, because can't install it on the production server.

 

 

In a perfect world i would produce this :

 

But simplest will be fine too :

 

 

Do you know an another solution, any help would be greatly appreciated.

Edited December 5, 2016 by pinkfoyd

[RTFC]

graphs with GDIplus

[water]

N.B. The Wiki is a great source for such functions. Please check the UDF page.

[pinkfoyd]

Hi, thanks for the reply, i found finally the solution myself, autoit and powershell...

 

create_chart.au3Fetching info...

Example_conf_chart.iniFetching info...

Edited December 6, 2016 by pinkfoyd

[notsure]

Double

Edited June 13, 2019 by notsure
double

[notsure]

  On 12/6/2016 at 5:28 PM, pinkfoyd said:

Hi, thanks for the reply, i found finally the solution myself, autoit and powershell...

 

create_chart.au3 11.83 kB · 670 downloads

Example_conf_chart.ini 416 B · 345 downloads

Expand  

Can you post the _create_graph function? It isnt in, also not within the GDI module linked. You changed it? coz graphUDF says graph_create, instead of create_graph.

[mikell]

Notsure about an answer (pinkfoyd, Last visited : December 9, 2016)

[notsure]

  On 6/13/2019 at 4:42 PM, mikell said:

Notsure about an answer (pinkfoyd, Last visited : December 9, 2016)

Expand  

Do you know how to get those bars easily? I have multiple "examples" of a line graph, or dot-graph. But i'd also like the bars and don't know how to approach

[Nine]

  On 6/13/2019 at 12:44 PM, notsure said:

Can you post the _create_graph function?

Expand  

I looked into it and the function is within the create_chart.au3 file.  It is based on PowerShell 1.0.  In order to use it you must install the right assembly (System.Windows.Forms.DataVisualization.Charting.Chart) and enable powershell script.

[notsure]

  On 6/14/2019 at 11:40 AM, Nine said:

I looked into it and the function is within the create_chart.au3 file.  It is based on PowerShell 1.0.  In order to use it you must install the right assembly (System.Windows.Forms.DataVisualization.Charting.Chart) and enable powershell script.

Expand  

I have seen that yes, but i get no error whatsoever, only "example.png not found", so for some reason it won't create it, eventho if i start it with admin rights.

[water]

If you have Excel installed I suggest to have a look at the ExcelChart UDF (please check my signature).

[Nine]

  On 6/14/2019 at 3:41 PM, notsure said:

I have seen that yes, but i get no error whatsoever, only "example.png not found", so for some reason it won't create it, eventho if i start it with admin rights.

Expand  

It means that you don't have the assembly installed.  I suggest you take a look at @water wise advice...

[notsure]

  On 6/14/2019 at 3:52 PM, water said:

If you have Excel installed I suggest to have a look at the ExcelChart UDF (please check my signature).

Expand  

Thanks, sorry for the late reply