Do you ever have to give the presentation to the executive where you’ve only got 5 minutes so you boil your presentation down to the core message, but you know you’ll get asked a (seemingly random) question about a slide? So you debate, do you put the supporting slides (details, data, sources, etc) in the main flow? Do you add them at the end? Do you keep them in a separate presentation? Do you hide them? If you do, how do you get to them quickly, easily, and in a way that makes it look like you anticipated their needs?
Ever have an audience member ask a question that is somewhat tangential, but still a good question that you have material prepared for, but didn’t want to put in the main flow?
This 5:30 video walks you through the steps of creating buttons, links and hidden buttons that let you navigate to any part of your presentation, quickly, easily, and professionally:
Be sure to let me know what you think and if there are other videos you would like to see!
In a recent post by Nathan from FlowingData, he does a great job of explaining how to interactive area charts. For the average person, though, his approach requires a lot of existing knowledge…Flash, Flex, coding, etc. So, I wanted to create a version that most people could create and use with NO coding required. For all the grief (often deserved) that Microsoft gets, there’s actually a lot of power in the Office suite, and Excel is no exception.
In the following 3 videos, I cover how to create an interactive area chart in Excel without coding. While I use Excel 2007, most of the features are available in at least the last two versions. As with everything, this approach has limitations…two big ones, in fact. First, it only works on PC. It takes advantage of the Active X controls and those are, sadly, PC only. Second, deals with a feature of charts in Excel that displays the label of lines/area with values of all zeros. There is a work around for the second issue, but since it requires code, I decided that I could live with the limitation. Generally, you won’t be displaying graph items with all zeros anyway, because why would you graph them? But that’s another post.
In the first video (6:29), I discuss how to set up the basic spreadsheet to make the interactive chart:
In the second video (8:12), I show you how to create the first set of controls:
In the final video (5:48), we finish off all the controls and talk about the limitations:
I hope you find this useful! Please let me know what you think and if you’d like to see other topics.
