Send to a Friend

XOIIO's avatar

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

Asked by XOIIO (16848 points ) 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.

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.