xroot Posted March 17, 2009 Posted March 17, 2009 I needed a way to produce quick charts with simple data input.(for boss) I created this wrapper dll around Microsoft Chart Control 6.0, so if you have the (mschrt20.ocx) then this might work for you. Very simple to use, the objects are: ".Title,.Legend,.SetData,.Row,.RowLabel,.Show" that's it. The sample script will show how it's used, click the buttons to get either 2D Bar,2D Area, 2D Line, 2D Pie, 2D Stack, and 3d Bar.chartcom.zip
gseller Posted March 17, 2009 Posted March 17, 2009 I am having a problem with $Chart.Title... My system says variable must be of type"Object"
GtaSpider Posted March 17, 2009 Posted March 17, 2009 HiWell done @gseller: U have to register the dll.Put it in the System32 dir and then run "regsvr32 chartcom.dll"Here is a quick screenshot:Mfg Spider www.AutoIt.de - Moderator of the German AutoIt Forum
Dampe Posted March 18, 2009 Posted March 18, 2009 Put it in the System32 dir and then run "regsvr32 chartcom.dll"did that, still getting the title error
dmob Posted March 18, 2009 Posted March 18, 2009 Excellent work. Now I can drop Excel (which I used for graphing data from an SQL table) and use your wrapper instead. Thank you!
UEZ Posted March 18, 2009 Posted March 18, 2009 (edited) It is not working in my vm machine where Office is not installed although I've registered the DLL.I assume Office API is needed.On my real machine where Office is installed it is working properly.You just need the mschrt20.ocx file in system32 and of course the DLL registered then it will work! Unfortunately mschrt20.ocx is a part of the office package UEZ Edited March 18, 2009 by UEZ Please don't send me any personal message and ask for support! I will not reply! Selection of finest graphical examples at Codepen.io The own fart smells best! ✌Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!¯\_(ツ)_/¯ ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ
Sunaj Posted March 18, 2009 Posted March 18, 2009 [...] Unfortunately mschrt20.ocx is a part of the office package UEZ Fortunately there's backups online in case your ocx file should get corrupted: http://search.yahoo.com/search?p=mschrt20.ocx [list=1][*]Generic way to detect full path to default browser, List/ListView Events Using GuiRegisterMsg (detect doubleclick and much more)[*]Using dllcall for full control over fileopendialog, Make DirMove act somewhat normally (by circumventing it...)[*]Avoid problems with "&" (chr(38)) in code, Change desktop maximized area/workspace (fx to make deskbar type app)[*]Change focus behavior when buttons are clicked to work closer to 'standard windows' app[*](Context) Menus With Timed Tooltips, Fast Loops & Operators in AU3[*]Clipboard UDF, A clipboard change notification udf[/list]
WideBoyDixon Posted March 18, 2009 Posted March 18, 2009 There *is* another way. Take a look here:http://www.rmchart.com/rmc/downloads.htmAs far as I'm aware, RMChart is freeware and does some nice graphs! See here for an example. If anyone has the time then it would be nice to see an example using this ActiveX control. The main web site doesn't appear to generate a page (http://www.rmchart.com) but if you google for "site:www.rmchart.com" then you'll get plenty of hits.WBD [center]Wide by name, Wide by nature and Wide by girth[u]Scripts[/u]{Hot Folders} {Screen Calipers} {Screen Crosshairs} {Cross-Process Subclassing} {GDI+ Clock} {ASCII Art Signatures}{Another GDI+ Clock} {Desktop Goldfish} {Game of Life} {3D Pie Chart} {Stock Tracker}[u]UDFs[/u]{_FileReplaceText} {_ArrayCompare} {_ToBase}~ My Scripts On Google Code ~[/center]
ProgAndy Posted March 19, 2009 Posted March 19, 2009 (edited) This is really a great DLL. There's even a non-COM one Btw: The homepage can be found at http://www.rmchart.com/rmc///Edit: The mschrt20.ocx is not included in Office. It is included in VB 6. For me, this downlosd worked: DL Also, i had to change the regsvr to allow spaces in path:Func OnAutoItStart() RunWait(@SystemDir&'\regsvr32 /s "'&@ScriptDir&'\ChartCom.dll"') ;Register DLL silent ; RunWait(@SystemDir&'\regsvr32 "'&@ScriptDir&'\ChartCom.dll"') ;Register DLL EndFunc Func OnAutoItExit() RunWait(@SystemDir&'\regsvr32 /s /u "'&@ScriptDir&'\ChartCom.dll"') ;unRegister DLL silent ; RunWait(@SystemDir&'\regsvr32 /u "'&@ScriptDir&'\ChartCom.dll"') ;unRegister DLL EndFunc Edited March 19, 2009 by ProgAndy *GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes
UEZ Posted March 19, 2009 Posted March 19, 2009 (edited) Fortunately there's backups online in case your ocx file should get corrupted:http://search.yahoo.com/search?p=mschrt20.ocxThe internet is full of software downloads but do you know the licenses agreement of mschrt20.ocx? Is it allowed to use standalone? etc....I don't know!Further I don't know from which software package mschrt20.ocx is! I assume from office but I'm not sure!UEZ Edited March 19, 2009 by UEZ Please don't send me any personal message and ask for support! I will not reply! Selection of finest graphical examples at Codepen.io The own fart smells best! ✌Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!¯\_(ツ)_/¯ ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ
UEZ Posted March 19, 2009 Posted March 19, 2009 There *is* another way. Take a look here:http://www.rmchart.com/rmc/downloads.htmAs far as I'm aware, RMChart is freeware and does some nice graphs! See here for an example. If anyone has the time then it would be nice to see an example using this ActiveX control. The main web site doesn't appear to generate a page (http://www.rmchart.com) but if you google for "site:www.rmchart.com" then you'll get plenty of hits.WBDMaybe somebody has enough time to write an UDF for rmchart DLL UEZ Please don't send me any personal message and ask for support! I will not reply! Selection of finest graphical examples at Codepen.io The own fart smells best! ✌Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!¯\_(ツ)_/¯ ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ
Jfish Posted July 23, 2009 Posted July 23, 2009 This MsCharts DLL works very well. Thanks for posting it. I am a COM/DLL newbie (well all around newbie for that matter). I did manage to look at the com methods for this object and thought that it would be great if EditCopy were available (it does not seem to be part of the DLL which is why I think I cannot access it ... is that right?). I am trying to paste the image created with the DLL call back into excel since it is easier than creating excel charts. Is there a way to do that short of adding EditCopy to the DLL? Build your own poker game with AutoIt: pokerlogic.au3 | Learn To Program Using FREE Tools with AutoIt
Andreik Posted August 17, 2009 Posted August 17, 2009 Is any documentation online about mschrt20.ocx?
idbirch Posted August 26, 2009 Posted August 26, 2009 Is there any way to force one particular chart type and not show the buttons to switch between them?
xroot Posted August 26, 2009 Author Posted August 26, 2009 Is there any way to force one particular chart type and not show the buttons to switch between them? Yes, let me take a look and see what I can do.Thanks
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now