This is Robert's Typepad Profile.
Join Typepad and start following Robert's activity
Join Now!
Already a member? Sign In
Robert
Greater Munich Metropolitan Area, Germany
I am helping people to turn data into smart decisions
Interests: Data Analysis, Data Visualization, Strategic Analysis, Financial Analysis, Strategic Planning, Financial Planning, Simulation Models, Operations Research, Optimization Algorithms
Recent Activity
Image
How to adjust the Default Table Style and the Autofit Column Width Property manually and automatically for all Query Tables in a Workbook Continue reading
Posted 5 days ago at Clearly and Simply
Image
How to create Power BI lookalike Tooltips in Microsoft Excel Charts Continue reading
Posted 6 days ago at Clearly and Simply
Image
How to create an animated Choropleth Map (aka Heat Map, Filled Map, Thematic Map or Statistical Map) in Microsoft Excel Continue reading
Posted May 21, 2020 at Clearly and Simply
Image
How to create a Summary Table in Power Query with aggregated values of the original data source without importing the entire data into Excel Continue reading
Posted May 18, 2020 at Clearly and Simply
murugesan, as stated in the update at the end of the post, the Office Web Components are not available anymore in newer versions of Excel. However, you can still provide a tooltip with additional information on a cell range using the technique described in the following post: Tooltips on Microsoft Excel Tables
1 reply
Image
Bluffing some of Tableau’s amazing interactive features in Microsoft Excel: an Excel Replica of All Peaks of the Alps visualized with Tableau Continue reading
Posted May 8, 2020 at Clearly and Simply
Sergio, ad 1: See my answer to Aileen on Friday, July 02, 2010 at 04:27 PM ad 2: See my answer to Kevin Hoang on Wednesday, January 17, 2018 at 03:09 PM
1 reply
Image
A Tableau visualization of all peaks of the alps including the option to find and highlight one peak or to select one by clicking on the map Continue reading
Posted Apr 29, 2020 at Clearly and Simply
Carlos, unfortunately, no, they won't. You need an SVG or an EMF file to ungroup them in Excel to shapes. This does not work for png or jpg. No worries, I will prepare maps of Peru over the weekend and send them to you per e-mail.
1 reply
Image
How to create optimized Choropleth Maps in Excel with a higher resolution and without distortions using Excel 365 Continue reading
Posted Apr 22, 2020 at Clearly and Simply
Image
How to use Table Slicers and Timelines as interactive Filter Controls on a Microsoft Excel Dashboard Continue reading
Posted Apr 20, 2020 at Clearly and Simply
Jon, many thanks for your comment. I am glad you liked the post and I am happy to hear that this may help you in one of your projects. Regarding your statement "no lack of ideas, but a lack of motivation": I hear you. I lost my motivation back in 2017 and I didn't post anything for more than 2.5 years. When the lock down started, I needed something to keep me busy, though. Hence, I decided to revive the blog…
1 reply
Image
Spice up your interactive Excel Dashboards with dynamically changing Icons, Pictures or Charts Continue reading
Posted Apr 16, 2020 at Clearly and Simply
Mynda, many thanks for your comment. It is an honour to have you as a reader and commenter here. I fully agree with you. I have never been a big fan of the trending black background dashboards. I find them hard to read, too. And not only because of the red font color, but in general. I may be old school, but I still think the good old "Black on White" (or grey on white) is best in terms of readability.
1 reply
Image
For what it’s worth: a few remarks on the currently extremely popular COVID-19 Dashboard provided by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (JHU) Continue reading
Posted Apr 13, 2020 at Clearly and Simply
Image
A ready-to-use Microsoft Excel Template for a dynamic Project Calendar, displaying regular Project Meetings and Deadlines for one selected week Continue reading
Posted Apr 8, 2020 at Clearly and Simply
Marcelo, I am sorry, I do not know. I have never used the range sliders in Access and do not know if they are even available in Access.
1 reply
Image
A Collection of Choropleth or Filled Maps of Italy in Microsoft Excel Continue reading
Posted Apr 6, 2020 at Clearly and Simply
Josh, thanks for your comment. I am glad you like it. If the sub is called with the parameter blnHideNumbers = True, it sets the custom number format of the cells to ";;;" to hide the numbers. This is the best and easiest way to avoid displaying numbers, better than setting the font color equal to the fill color. If you then run the code again with blnHideNumbers = False, the custom number format will not be changed (i.e. stay at ";;;"), because the code does not know which number format you want (whole numbers, percentages, etc.). It would be possible to enhance the code in a way that you can also pass the desired number format to the sub. However, I waived this in order to keep things as simple as possible. In a nutshell: once you ran the code with blnHideNumbers = True, you have to change the number format of the cells manually to see the numbers again.
1 reply
Image
How to create Heat Maps in Microsoft Excel using individual Color Scales to support the analytical insights into the distribution of the data Continue reading
Posted Apr 3, 2020 at Clearly and Simply
Image
More sophisticated Color Scales to increase the analytical insights provided by Heat Maps or Choropleth Maps – a Guest Post by Ron Whale Continue reading
Posted Apr 2, 2020 at Clearly and Simply
Image
A more practical Showcase for using Table Slicers as interactive Filters on an Excel Dashboard including additional features Continue reading
Posted Mar 31, 2020 at Clearly and Simply
Image
How to visualize round trips on a Route Map in Excel, including an indication of the quantities transported between the cities Continue reading
Posted Mar 30, 2020 at Clearly and Simply
Image
Final part of a 3 parts series on how to create a Geographical Flow Map in Microsoft Excel Continue reading
Posted Mar 27, 2020 at Clearly and Simply
Image
Part 2 of a 3 parts series on how to create a Geographical Flow Map in Microsoft Excel Continue reading
Posted Mar 26, 2020 at Clearly and Simply