Extensive library to control and manipulate Microsoft Excel charts.
Written by GreenCan and water.
Theads: General Help & Support - Example Scripts
BTW: If you like this UDF please click the "I like this" button. This tells me where to next put my development effort
KNOWN BUGS (last changed: 2017-07-21)
None. The COM error handling related bugs have been fixed.
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.
This UDF can be used to Display bar charts in a window. I hope you can need it.
If you like it, please leave me a comment, also if you have any suggestions to make it better or if you found bugs.
Hi, I tried to use GraphGDIPlus UDF, it works perfectly for newbee like me, but I want to send mails with graphics to my customers and when I look at the JPG output file (creating with _GraphGDIPlus_SaveImage function) there is no axis values. The reason is because these values are not written to graph area. Had someone tried to solve this problem earlier? I tried to modify _GraphGDIPlus_Set_RangeX function but it's over my possibilites. I've found GraphGDIPlus convenient because of its saveImage function, maybe there is another UDF with same functionality? BR.
In this thread you will find some useful scripts based on the ExcelChart UDF (for download please see my signature).