June 21

Interactive Periodic Table of Elements in Excel

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!

Loved this? Spread the word


About the Author

Jordan Goldmeier

Related posts

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

Read More

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

Read More

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More

Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks

Read More
  • 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.

  • 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.

  • 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

  • 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 🙂

  • 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?

  • 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?

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Subscribe to our newsletter now!

    >