Interactive Periodic Table of Elements in Excel

I’ve been on a real rollover kick lately. I’m really trying to figure out if it can be useful. Earlier today I started making a Periodic Table of Elements using Excel. I employed the rollover technique to allow the user to gain information about an element simply by rolling over a cell. Well, for some reason, I couldn’t stop there. So what was meant to be a small project ballooned into something larger. Unfortunately, my sticking to good coding practice didn’t keep up with craving to do more. So what I present to you below isn’t really a polished product. If you poke through the named ranges and the rollover indexes, you’ll probably see that I add and subtract one to them somewhat randomly (a cheap trick – this is  due to my trying to reconcile the table copied from Wikipedia with my indices).

As you can see below (sorry for the graininess of the recorder–be sure to download it to get the full effect), you can not only gain information about an element but you can also toggle on and off different element groupings.

periodic2

If you want to “crack” the file, the first thing you’ll need to do is reset the ScrollArea (Click on a cell. Go to the Developer tab, click Properties. Delete the reference in the ScrollArea box.). Then just unhide everything.

Good luck.
Periodic Table.xlsm

Update –
Reader Dario found an error in the spreadsheet (see the comments) – this is the result of some carelessness and cheap tricks on my part. An updated version will be released tonight. In the meantime however, you can still poke around the file :).

Another Update –
I’ve since fixed the bug described in the reader comments. If you find anything else, let me know!

Advertisements

15 thoughts on “Interactive Periodic Table of Elements in Excel

  1. Dario

    Is there a bug or is it just a functionality or lack thereof that if you hover over the cells from left to right that it skips one. From right to left it doesn't skip any.

    Reply
  2. Jordan

    Thanks for pointing that out to me. That is indeed an error – the result of my using cheap tricks instead of good programming practices. I've since fixed the problem – however, I am not able to upload the new file while at work. Tonight the new file will be uploaded in its place.

    Reply
  3. Al Delgado

    Really, really nice. Is there an explanation anywhere on what you did. How would I go about modifying the overall structure, if I wanted to highlight different portions of a worksheet, nothing in particular in mind at this point.ThanksAl

    Reply
  4. Jordan Goldmeier

    Sorry, I never really completed the tutorial for this. However, you might find these tutorials helpful:http://optionexplicitvba.blogspot.com/2012/06/how-to-highlighting-cells-using.htmlhttp://optionexplicitvba.blogspot.com/2012/09/handling-rollover-clicks-without-using.htmlhttp://www.clearlyandsimply.com/clearly_and_simply/2012/11/roll-over-tooltips-and-web-actions-on-a-microsoft-excel-dashboard.htmlAs well, you can go snooping through the file – I'm available by email to answer specific questions 🙂

    Reply
  5. J.Jana

    A very nice functionality…. Would it be easy to have a version where the extra info is displayed when you click on an element, instead of hovering over it?

    Reply
  6. J.

    Hi Jordan

    I really like it. Would be possible to have the extra information display when you click on a cell with the element, not on hover?

    Reply
  7. habbibs

    +1 for repost the file. I want to do something with exact same idea, but I don`t have Excel knowledge for this (yet). Playing with your file would be awesome.

    Reply
    1. Jordan G Post author

      Something weird has been going on with my host and the file hasn’t been coming up. email me jpo645 (at) gmail if you’d like to get a copy.

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s