Maybe they’re ordered by the total? Nope. At first I thought they were sized by the US percentages, but that’s not it. There doesn’t seem to be any logic to the order of the categories.You can’t tell me that the orange Italy bubble for Downloaded Music is 1/3 the size of the US bubble. The bubbles are not sized according to their percentage, making comparing bubble sizes meaningless and inaccurate.It kind of makes me feel like I’m in a tennis match. For example, your eyes are constantly pinging left to right to left trying to compare the UK values. The data is not aligned vertically, making comparisons across categories for the same country difficult.I find this chart hard to read and interpret because: With some simple fixes, this data can communicate much more effectively. The chart below comes from a recently released study by Nielsen. Although it has been tested to work on 32-bit and 64-bit versions of Excel you should back up your data before using it. Important: This tool is a free, unsupported, undocumented add-in from Tableau. We hope that this new version of the tool will speed up your analytics using Tableau and Excel files. The final change is the addition of 2 keyboard shortcuts to help speed up your process. Visually we have updated the UI so that it now has an Excel ribbon style interface making it easier to get to the buttons and generally making things a little easier on the eye. Press this and, hey presto, Tableau opens a new workbook connected to your current workbook. The biggest change is the addition of the “Open in Tableau” button. For those who are not familiar with this tool, it’s a free add-in that helps you prepare your Excel files for analysis. Today we are releasing a new version of our data reshaper add-in for Excel 2007-2010 (32- and 64-bit). Andy Cotgreave did an excellent job upgrading the tool.įor more information on preparing Excel files for analysis, please click here. If you have been using the 4.1 version, there’s really not much difference. It’s recreated with the permission of Ross Perez. This blog post is mostly a duplication of the Reshaping Data Made Easy” blog post from Tableau Software.

Curtis hairston (1986 download blogspot