New vscsiStats Excel Macro
I wrote an Excel Macro to process vscsiStats data and turn it into pretty charts & graphs. I shared that macro with my friend Matt Kelliher and after showing him how to use it, he suggested and made a modification to it. The latest version will still process the data and create charts but then it will also export the charts as PNG, create an HTML file and put thumbnails of the charts in. You can then click on any of the charts for a full-screen view. Handy method of presenting the data in a concise format.
Let me know what you think of the file, you may download a copy here. You are welcome to download and use this macro but please leave the comments at the top (feel free to buy us a beer or two too)
This macro has been tested in Excel 2007 and 2010 beta. I must say though, it runs much more slowly in these than in 2003.
Note: SAVE your spreadsheet first before running this version of the macro, it uses the current save location as the starting point for creating the HTML and saving the images.
Hi Paul,
after the first chart is created, “Run-time Error ’1004′ – Application-Defined or Object-Defined Error” pops up, Debug points at the line: ActiveChart.SeriesCollection(1).XValues = “=” & sheet1 & “!R” & st & “C2:R” & en & “C2″
http://imgur.com/VVdif.png
http://i.imgur.com/iBYZm.png
Excel-Macros are not something I ever looked into, do you have an idea why this could be happening? Much appreciated, and thanks for the macro, will definitely beat creating every one by hand
Cheers
Valentin
P.S.
I have the same issue with all datasets I collected (vscsiStats -p all -w * -c > /*.csv).
I have a couple ideas.. can you email me the csv output file so I can test them on yours?
Paul
For anyone else reading this, Paul ran my file and it worked as it should, must be something on my box. I guess I will just install a bunch of different Excel Versions on minimal VMs and try which on works for me
.
Had same issue, rename the file as data.csv. it works, looks like excel can’t translate this format name vscsiStats-export.csv
Hi Vishy,
wow, it really is the dash, I even remember renaming it before sending it to Paul … thx for solving the mystery
Cheers
Valentin
Hi,
when using two disks and all counters I always get “Run-time error ’1004′: Method ‘Location’ of object ‘_Chart’ failed” when processing chart 17. The following line is marked when I click debug: ActiveChart.Location Where:=xlLocationAsNewSheet, Name:=chartname.
When using only one disk with all counters, all charts are generated, but I can’t see the horizontal axis labels.
Regards
sry. forget my post. I had to separate the text to columns before running the macro.
Kein Problem. Freue mich das es funktioniert hat