This is Robert's Typepad Profile.
Join Typepad and start following Robert's activity
Join Now!
Already a member? Sign In
Robert
Munich, Germany
Interests: new media, optimization, strategy, forecasting, business intelligence, project management, financial planning, business plans, telecommunications, revenue management, business performance management, simulation, pricing, intelligent data analysis, business cases, revenue assurance, cable operator, operations research
Recent Activity
Geethu, you also have to copy the code from the Microsoft Project Object "ThisProject". Those subs create the menus when opening the project file and delete them before closing. After copying the code to "ThisProject" you have to save and exit the file and reopen it again and you should see the menu.
1 reply
Eirik, no sweat. Have a look here: Download Gapminder Excel Replica with Trails (843.9K) You can select any of the highlighted countries to show the trails over time. Same techniques as used in the original workbook, just 3 more data series in the chart and 3 more checkboxes.
1 reply
Petr, don't open the .EMF file with Excel. Insert it as a picture (Insert | Pictures).
1 reply
Xavier, you are right, shapefiles for ZIP-codes are harder to find than administrative areas. Some sites are selling ZIP-code shapefiles, but I do not know of a site where you could download ZIP-code maps for free. Wikimedia Commons is usually a good resource, but no guarantee. I am sorry.
1 reply
Andrew, if you sort filtered data, only the visible rows will be sorted, not all the rows. The check of the sort order in the code, however, refers to the entire range, i.e. the visible and invisible rows. If you sorted by one column (descending) and double click again to reverse the sort order, the check will most likely return that the data is not sorted (since only the visible rows have been sorted). I.e. it will sort the data again descending by default and you never get to an ascending sort order. How could you solve this? There is more than one way, I guess, but you could write additional code to check if a filter is applied, remove the filter before sorting, sort the data and then set the filter again. I never tried, but I think this should work.
1 reply
Liam, adjusting the workbook to another timeline (more or less years or months instead of years) isn't too complicated for most features. Basically you have to change the ID (combining the country and the year) and change the values of myMin and myMax to fit to your new timeline. Having said that, changing the rectangle timeline above the bubble chart takes more time. You would need more or less rectangles with a certain naming convention (e.g. "Rectangle_Jan" instead of "Rectangle_1950"), change the labels of the "axis" beneath the rectangles and adjust the VBA code which extracts the year or month from the freeform name. Not really complicated, but some changes necessary.
1 reply
Erin, sure, this would be possible, but it requires some extra VBA coding and I do not have the time to do this. Having said that, it is not that much effort to add extra sections manually.
1 reply
G, I am sorry, but I do not have the time to debug your code. I did a quick search and I think the easiest way would be to create the appointment in your default calendar and move it to your "Milestone" calendar afterwards. Have a look here to get started: http://www.slipstick.com/developer/copy-new-appointments-to-another-calendar-using-vba/
1 reply
Paul, you are right. The code in my workbook uses the Windows function Sleep for the delay in milliseconds and this function isn’t available on Mac. You could either delete the declaration of Sleep and all calls of the function, but then the speed of the animation cannot be controlled anymore (e.g. forward and fast forward would be the same). The other option is to use Application.Wait instead of Sleep.
1 reply
Image
A Gapminder-lookalike animated chart in Microsoft Excel, based on the generic Motion Chart Excel Template Continue reading
Posted Sep 6, 2014 at Clearly and Simply
Peter, you do not need the faster version for a World Map with only 200 countries. Tushar's original approach is fast enough to color those very quickly. Having said that, if you still want to transfer the World Map to the workbook posted above, deleting the existing shapes and data, inserting the World Map Shapes, deleting the not required rows on the data sheet and running the Recreate Shape Index sub is pretty much all you have to do.
1 reply
G, have a look here, for instance: http://www.slipstick.com/developer/working-vba-nondefault-outlook-folders/
1 reply
Bertram, I just tried your YML file and it works fine for me, so all I can provide are 2 hints: 1. Make sure your Tableau version and your TabGeoHack version fit. If you are using Tableau 8.2, you need TabGeoHack 2.0, if you are using Tableau 8.1 or an earlier version, you need TabGeohack 1. Richard provides the different links on his VizTalk thread. 2. I assume you tried several times, so it may be a good idea to start from scratch, i.e. remove the existing Custom Geocoding in Tableau, delete all folders in C:\TabGeoHack\Taiwan (Custom Geocoding Files, Feature Files, Local Data Copy, etc.) and try again I am sorry, but since I can't reproduce the problem, this is all I can offer.
1 reply
Image
Invitation to register for ModelOff’s Financial Modeling World Championships 2014 Continue reading
Posted Aug 31, 2014 at Clearly and Simply
Image
La Gazzetta dello Sport, the famous Italian sports newspaper uses Tableau Software to visualize 20 years of Italy’s Serie A Continue reading
Posted Aug 29, 2014 at Clearly and Simply
Henry, yes, please send it by email and I will have a look.
1 reply
Marc, you cannot add a text to the freeform shapes used in the maps. Texts in shapes are only possible in standard Excel shapes like rectangles, circles etc. The only way to add text to the map would be to insert additional textboxes, assign the name of the region and the data value to the text of the textbox and position the textbox in the middle of the shape. The code to add a textbox would be something like this: Dim shpText as Shape Set shpText = ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 10, 10, 10, 10) The code to change the text would be: shpText.TextFrame.Characters.Text = "Alabama" The position of the box could be changed with the properties .Left and .Top Having said that, I would strongly recommend against your idea. Adding textboxes to all shapes will definitely clutter the display and cause more confusion than insight. I would rather work with a data table or a bar chart next to the map or provide tooltips.
1 reply
Mitchel, as I wrote above, I assume there is a way, but I do not know it off the top of my head. I am sorry, I have to refer you to Google and the Excel/PowerPoint/VBA forums.
1 reply
Roberto, thank you so much for your comments. Very nice. I especially like the one with the Google logo. Thanks again for this fabulous idea!
Toggle Commented Aug 25, 2014 on Motion Chart Excel Template at Clearly and Simply
1 reply
Image
A generic template to create Motion Charts in Microsoft Excel and 2 examples to animate La Linea episodes in Excel Continue reading
Posted Aug 23, 2014 at Clearly and Simply
Mitchel, the PowerPoint constant for slide layout with an object is 16. However, the Placeholder property in PowerPoint has no Paste or PasteSpecial method. If you want to insert a picture into a placeholder, you have to specify a link to a picture. I.e. you can't directly insert the content of the clipboard. You could save the picture temporarily somewhere, insert the file into the placeholder and then delete the picture afterwards. With regards to the HTML export: the PasteSpecial parameter would be 8. I tried, but this does not work: I get an error message saying "Invalid request: The specified data type is unavailable". I assume there is a way to export from Excel to HTML in PowerPoint, but apparently not with the PasteSpecial method.
1 reply
Henry, no need to compile anything in VBA. Just go to the cell with the Completion Rate, press F2 to edit the cell and press Enter to force Excel to recalculate the function. This should solve the issue.
1 reply
Henry, this is an Excel issue. Have a look at my answer to Suzanne's comment above (September 11, 2013). The comment describes how to change the Conditional Formatting. If you just want to get rid of it, you can simply delete the CF and it should work right away.
1 reply
Henry, Question 1: Open the Name Manager (Formula Tab | Name Manager), select myChecklist, change the cell range in the "Refers To" input box, click Close and confirm with Yes. Question 2: This is possible, but it would require some considerable changes in the code, since we would have to distinguish between 3 hierarchy levels instead of only 2. Not impossible, of course, but some VBA coding work necessary. I will put this on my list of ideas and maybe I will publish an update some later day including the various suggestions posted in the comment section already. No promise, though.
1 reply
Aiswarya, you are absolutely right: the technique does not work anymore with Office 2013. The root cause: Microsoft disabled scriptable ActiveX controls like the Webbrowser in Office 2013. This has nothing to do with Tableau. It is a Microsoft issue. None of the workbooks I published here with scriptable ActiveX controls (like the Webbrowser or the Slider) work anymore in Office 2013. I can't tell for sure regarding LiveWeb, but I guess LiveWeb is using the Webbrowser, too. As far as I know, the only option of using scriptable ActiveX elements in Office 2013 is to embed them in a VBA userform. I am sorry, I do not see another solution.
1 reply