How to Create Interactive Excel Charts With the INDEX Formula

This simple process will help you turn static Excel charts into something much more dynamic. Excel makes it easy to create clear, concise charts from your raw data. However, the results can sometimes feel static and uninteresting. One way to address this problem is to add some design flourishes, but you can also introduce an interactive component. A simple drop-down menu can transform a simple Excel chart into an illustrative visual that’s capable of presenting several different sets of information. It’s a great addition to any Excel dashboard, and it’s very easy and quick to set up. Here’s how to use...

Read the full article: How to Create Interactive Excel Charts With the INDEX Formula

from MakeUseOf http://ift.tt/2tKe6Iz
via IFTTT