Butterfly Chart – Excel Chart with Dual Converging Scales A Butterfly chart is a chart where two entities are compared side by side using scales meeting at the center. Due to its shape, the chart resembles a butterfly and hence the name. These charts are sometimes also known as Funnel or Tornado Charts though I find “butterfly” to be a better description as it allows for a greater variation in shape than a funnel or a tornado does ! So let’s jump straight into creating a beautiful looking butterfly chart. Getting the Data for the chart Although a simple looking butterfly chart is as easy to create as a bar chart, there is some value in adding labels, converging scales and the other embellishments. The first three columns essentially contain all the data related to the business. Making the basic Chart Let’s create a basic chart with five series. Adding the XY series for the dummy scales Once we’ve inserted the XY-Series the chart looks like this: Aligning the XY points to the X axis If you noticed, the points are not aligned to the X-Axis.
Knowledge Maps of Researchers and Methods in the Visualization F Visual Cards for Collaboration and Team Creativity Making the Complex Clear Visual Literacy for Managers - How Sketching enables Visual Problem Solving and Communication (get the hardcopy edition at sketchingatwork.com) By clicking on a map or diagram thumbnail below, you can access an interactive graphic overview on tools, books, researchers in different visualization fields, as well as on key success factors of visualization. There is also an interactive organizing table that shows (incl. examples) one hundred visualization-based methods. Clicking on a particular tool, book, person, document, principle or method within a map opens the respective website or homepage in a new browser window or reveals an example (most maps were created with lets-focus). Stairs to visual excellence "Towards A Periodic Table of Visualization Methods for Management"Lengler R., Eppler M. (2007). Version 1.5 of the periodic table as PDF Imperfect Storm (Click on image to enlarge)
A Completely Unscientific (Yet Accurate) Look at Social Sites Interested in joining a community based site but not sure which one is right for you? There are many different options out there that will cater to your specific interests and demographic. You can start by asking yourself a few questions. Is your interest in technology more Linux-based, or more camera-phone-to-take-picture-of-self-based? Would you like to make connections for business relationships or communicate to your legions of followers that you will be 'AFK' for the next 45 seconds while using the restroom? Yes, there is a little something for everyone here in cyberspace, and these demographic breakdowns of each social site will help you to choose the right community for you.
The Daily Graph "The Daily Graph" re-creates charts from The Economist's Graphic Detail blog using standard run-of-the-mill Excel techniques without macros. We do try to milk Excel for all it's worth and apply techniques that may not have been intended in the way we use them. In the end, it's the result that counts. "The Daily Graph" is published whenever we spot an interesting chart on The Economists's blog that looks like it cannot be done in Excel. Typically once or twice a week if we can find the time.The Daily Graph blog comes with a dowloadable version of an Excel workbook so that you can follow what we did... or you can "borrow" our work and use it for something entirely different. "The Economist" is a trademark of The Economist Newspaper Limited.
Brian.Shaler.name | 3rd Party Digg Development Digg Oracle The Digg Oracle is a Google Gears tool that indexes your Digg history and allows you to sort, search, and filter stories you have voted on in the past. It uses a local SQLite database to store and parse the data, so after a one-time sync with Digg's servers, the tool does not have to connect to the internet to perform the searching. Venn Friends Type in your Digg user name, and you will see a Venn Diagram of your friends and fans. Wheel of Upcoming Stories The Wheel of Upcoming Stories is a Flash visualization of recently submitted Digg stories. Digg Heat Map The Digg Heat Map was based on the same data as my previous maps of the Digg community. Digg RADAR Expanding from the Map of the Digg Community, I set up a real-time feed from Digg, showing little thumbs-up icons whenever a user "Diggs" (votes on) a Digg story. DiggStatus DiggStatus is a small utility that calculates the average usage statistics of Digg users and compares them to the statistics of a selected user. DiggTaggr
How to Create a Panel Chart in Excel To show a concise, clear summary of data for several departments or cities, you can create a panel chart in Excel. It shows all the data in a single chart, with vertical lines separating the groups. My chart shows sales for bars and cookies, in four cities, over the first 7 months of the current year. I learned this technique from Jon Peltier's website, where he also sells a Panel Chart Utility, that creates dot plot and bar panel charts. Panel Chart Steps The instructions for making a panel chart look long and complicated, and I've avoided learning this technique, because it was a daunting process. Last week, I finally took the plunge, and it's not so bad, once you get the big picture in your head. Add a separator field to the source data Summarize the data in a pivot table Copy the pivot table data as values Create a line chart from the copied data Add another series to create vertical dividing lines Add final formatting to clean up the chart Add a separator field Summarize the data
Data Visualization: Modern Approaches | Graphics Cosmograph in Excel - World migration with bilateral flow chart - E90E50fx Igor: What is this?Freddy: Schwarzwalder KirschtorteMonster (OS): MmmFreddy: Oh, do you like it? I'm not partial to desserts myself, but this is excellentIgor: Who are you talking to?Freddy: To you. You just made a yummy sound, so I thought you liked the dessertIgor: I didn't make a yummy sound. Monster (OS): Mmm. by The FrankensTeam Initially I was inspired byPeoplemovinCarlo Zapponi's chart. It is a very nice job that I wanted to reproduce in Excel ...and I created a file but did not get a satisfactory result (if you want I can send the file) ... sometimes we have to know how to lose ... or maybe we just need to change strategy. I had to fix the formulas in values (where it was possible) to lighten the file ... and probably could do much lighter and without all of that data ... but it came out so and maybe will improve it later :-) Click here to download the Excel file. See also here:Life Expectancy by Nathan Yau's chart with ExcelEdward Tufte's Slopegraphs in Excel
code_swarm An experiment in organic software visualization. A moment from the Eclipse project. [video] I've been studying software projects for a while now. Not the programming, but the people -- the way they interact with each other through collaboration and communication. This visualization, called code_swarm, shows the history of commits in a software project. Please have a look at the videos below. The code is open source and available at Created by Michael Ogawa with Processing. VIDI group, UC Davis
Build a Dynamic Chart There are many instances when one wants to create a chart that reflects a growing data set or a chart that shows only part of a data set. These are easily accomplished in Excel by creating named formulas and using these named formulas in charts. Download the zipped workbook containing the examples below Once the basic concepts illustrated below are well understood, Advanced Examples contains solutions to more complex requirements. An extension to the above ideas so that the user can specify the data to be shown using business terminology. Keywords: Named formula, dynamic formula, dynamic chart, name in chart, grow, self adjusting, auto adjust, graph partial range, select column or row, name, form control drop-down dropdown list box combo The Best Tools for Visualization Visualization is a technique to graphically represent sets of data. When data is large or abstract, visualization can help make the data easier to read or understand. There are visualization tools for search, music, networks, online communities, and almost anything else you can think of. Whether you want a desktop application or a web-based tool, there are many specific tools are available on the web that let you visualize all kinds of data. Here are some of the best: Visualize Social Networks Last.Forward: Thanks to Last.fm's new widget gallery, you can now explore a wide selection of extras to extend your Last.fm experience. Last Forward Friends Sociomap: Friends Sociomap is another Last.fm tools that generates a map of the music compatibility between you and your Last.fm friends. Fidg't: Fidg't is a desktop application that gives you a way to view your networks tagging habits. Fidg't The Digg Tools: One more: Digg Radar. YouTube: Visualize Music Musicovery Last.fm music visual tools: Amazon