4 posts in this topic
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.
i have a question about Excel, i have to create several charts one below the other dynamically.
I have thought to use:
$oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell) $iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count
And then to use it in this way:
$Graph_position = "=Test1!A"&$iRowCount+2&":K"&$iRowCount+24 But it doesn't work with charts.
Does anyone have a suggestion?
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.
Would you Listen Last 100 Uk Top Charts singles like a JukeBox or Radio in random order and without advertising ?
It's possible by getting charts List on charts website http://creativedisc.com/category/top-charts/uk-top-100-singles/ updated weekly
and searching songs list on youtube.
Script completly rewrited.
All externals fils are includes.
New youtube search engine improved for listen the good song !
Blacklist Management improved.
Video can be visible.
Now flashplayer sound is muted while Ads.
User clicks on flashplayer progress bar are now detected for the detection of the end of the song.
Adapted to new AutoIt Version and Youtube changes.
Hope you like it !
Previous downloads : 500
source : TinyChartsJukebox v220.127.116.11.au3.html
executable : TinyChartsJukebox.exe.html
(Once the html file is downloaded, double click on it for start the download)
In this thread you will find some useful scripts based on the ExcelChart UDF (for download please see my signature).