How can I make this sort of a ...script, in excel?

Asked by XOIIO (18328

) April 19th, 2014

Hey all, something I want to do, but I have no clue how to, maybe you guys can point me in the right direction, I found a program that can log the number of keystrokes on all keys for a keyboard, and export it to a CSV file.

Anyways, in excel I’d like to be able to have a document where I place a bar graph for each key (positioned with transprency so it is above/on the key, I can do that), so that I could just import the CSV file, and it would automatically fill the bar graphs. I am assuming I would need to tell each bar graph which line/column to get it’s information from, but what else?

I’m using excel 2007 by the way

Oh yeah, I’d also perhaps like to have the bar color change if it reached x amount, so that if the number was 10 it would be one color, 20 for another, etc, more importantly would just to be able to have the number of that value displayed on top, instead of it displaying the letter for it’s key as it currently does, I’m guessing there is an option to do that I have not seen.

Observing members: 0

Composing members: 0

2 Answers

You could simply graph them on the same chart. Once the sheet is set up that’s about all that would need to be done. You would not have any fancy transparency though. I would probably just write a small program in Java to do it.

ARE_you_kidding_me (20021

)“Great Answer” (0

) Flag as…

All the functions of Excel 2k7 or any msoffice program from that era can be scripted using Visual Basic for Applications. MS calls these scripts “macros”, just to be different I guess.

VBA is a terrible, hard-to-read, slow language to work with, but that’s what you get for using MS office. If you were using Libreoffice you could use its Java or Python APIs.

rexacoracofalipitorius (2990

)“Great Answer” (0

) Flag as…