How can I make this sort of a ...script, in excel?
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.
This question is in the General Section. Responses must be helpful and on-topic.