Giulio, if you need to add another shape to the map, you have to perform the following steps: 1. Add the new shape next to the map 2. Give the shape a name, e.g. S_Rest_of_World 3. Go to the Selection Pane (ALT-F10) and make sure, the 2 DropDowns are at the top of the list shown in the pane. Most likely, the newly inserted shape will be the first, followed by the 2 dropdowns. I.E. you have to move the new shape 2 positions down 4. Go to the sheet [data], insert one row somewhere in the existing table (i.e. between row 6 and row 25) 5. Insert the values for the rest of the world in the source data table in the measure columns of the inserted row 6. Insert the name of the shape (S_Rest_of_World) in the newly inserted row in column K (Shape Names) 7. Go to the end of sheet [control] and click on the command button Recreate Shape Index 8. Go back to the [map] sheet and select another measure or color scale and the Rest of the World shape should be colored correctly

Carlos, in principle, the dummy scaling series for the values and the targets are necessary in the bullet chart implementations because the value is plotted on the primary horizontal axis, whereas the target is plotted on the secondary horizontal axis. Thus, scaling dummies are required to make sure that both horizontal axes always have the exact same scaling (maximum values). In the Multiple Rows implementations, however, the series [Target Gap] and [Target Exceed] are also plotted on the secondary axis and by that, they already ensure the correct scaling of the secondary horizontal axis. So, you are absolutely right: the Scale Target dummies could be removed from the tables in the Multiple Rows Bullet Graphs. Thanks for pointing this out.

Carlos, many thanks for your kind words. I am happy that you like the approach. Sure, you can use the workbooks and repost them in your YouTube channels. I haven’t thought of combining the approach with dynamic arrays, but this is a great idea. Dynamic arrays may allow for some interesting uses cases. Let me know if I can be of any assistance.

Ni, you are not doing anything wrong. Aligning the map in the background to match the geospatial data with the coordinates of the XY scatter chart is the tedious and time-consuming part of this technique. There is no silver bullet how to get there. What I have done is to use a map with defined locations (e.g. cities) in the background, and then to adjust the scaling of the axes of the XY scatter chart until all scatter points were sitting exactly on top of the cities on the background map. That can become a very annoying procedure, to say the least. Have a look at this article from 2010, where a world map is used in the background and the XY scatter chart on top is already aligned with the geospatial data: Bluffing Tableau Actions with Microsoft Excel Maybe this can get you started.

Maia, you are right, I used a very complex array formula. I am sorry, but I can’t provide a detailed description how this works. The formula goes across 25 lines combining IFERROR, INDEX, MATCH, LARGE, WEEKDAY, MOD and combines various Boolean arrays either by multiplication (= AND condition) or addition (= OR condition). Explaining how this works in detail would require a very lengthy description and I doubt I would be able to really explain this in a way everyone can understand. I recommend dissecting the formula step by step, take parts of it out to see the outcome of the different parts and thereby try to understand how the solution works. If you are new to the concept of array formulas, you better start with reading a general introduction into arrays and simpler examples of array formulas. The formula in the workbook above is an advanced example and not really suitable for learning how to use arrays in Excel.

Arturo, you are right, most of the links are not working anymore. Apparently, Richard deleted the files from his Dropbox and the Tableau Forum links are not valid anymore either. The post is more than 9 years old, and it was about a workaround for Tableau shapes. The workaround reached end of life. It is as simple as that. I am sorry.

Latif, you do not have to change the criteria or the calculations in the model. You could use e.g. the pre-defined color scale "Red to Blue Contrast". If you don’t like the blue and want a "Red to Green" scale, adjust one of the pre-defined color scales on worksheet [control] as you like (starting with red and ending with green) and select this color scale on US Map worksheet.

SK, template 08 posted above has more than one column with a checkbox (5 in total). If you need more than 5, simply insert an entire column somewhere in between the first and the fifth check box column, copy one of the existing columns and paste it into the newly inserted column. Finally adjust the second parameter of the completion rate formulas in row 3.

Gareth, no, this is not possible with the current template posted for download above. If you really need the option to display 2 events in the same cell, you would have to adjust the existing formula in order to concatenate the text of a possible second item to the first one. This could get tricky, though, because the formula is pretty complex already. The second option would be to split every day into 2 columns and to display the text of the first item in the first column of the day and the (potential) second item in the second column of the day. This would probably be easier to implement, but it comes with a few disadvantages, too, e.g. less space to display the text descriptions. I am sorry, but I do not see an easy way to realize what you are looking for. That being said, in my humble opinion there shouldn’t be items (meetings and deadlines) on the same day and at the same time in a Project Calendar. If you are having a meeting, you shouldn’t have a deadline at the same time, because you can’t work on the delivery anymore. In other words, the deadline should be set to the hour right before the meeting starts.

Gerardo, correct. Simply adjust the range on worksheet [Calculations] as needed and copy the formulas. Make sure the data sources of the chart cover the entire data range if you added more rows.

Gerardo, just change the value in cell C13 on worksheet [Calculations].

Matt, if you transfer the map, the sheets and the code to another workbook, there are quite a few things to consider, like making sure you copied the entire VBA code to your workbook or making sure the named ranges are available and correct in your workbook. My wild guess would be that you do not have defined the named ranges in your workbook (like myShapeNames, my Values, etc.). The code is referring to those named ranges and if you haven’t defined them properly in your workbook, the map will not update. So, please check the named ranges first. If this doesn’t solve the issue, you can send me your workbook by email (email link see the top of the site) and I will have a look.

Hana, I just imported a Danish text with special characters like "æ" and "å". The split text tool worked like a charm for me. I do not know which issue you are referring to. Sorry.

Albert, as far as I know, Excel does not provide an option to allow data entries on worksheets for selected users only. The only option I see is to write VBA code which unprotects the worksheet (either when the workbook is opened, or the sheet is activated) only if the username equals to one of the users allowed to see and edit the sheet. You would then write another VBA routine (e.g. Workbook_BeforeClose) to protect the sheet again.

Mauk, thanks for letting me know. I fixed the link, please try again.

Latif, I took the video of La Linea, separated it into 56 images using a video editing software, extracted the pixels from those images and calculated the X and Y coordinates of the relevant pixels (the line). But La Linea was just an example to show a somehow funny illustration of the approach. You can bring in your own data and the storyboard technique will still work.

Latif, the data source of the line chart are the columns X Offset and Y Offset in the table on worksheet [data]. The values are calculated by formulas based on the preparing calculations on worksheet [calculations]. The formulas are not too complicated. Please download the workbook and have a look for yourself.

Peter, I do not understand why you need sliders sitting on top of each other, but anyway: I just tried 2 stacked sliders based on the code in the workbook posted above and it is working fine for me. You have to make the other sliders invisible and keep only the slider on top of the stack visible (either manually or by VBA code), but I do not face any errors with stacked sliders. Since I cannot reproduce the error, it is hard for me to give any advice. If you want to, you can send me your workbook by email and I will have a look.

Luca, sure, this is possible. If it is a one-time effort, you can transfer any data from Excel to Project by simply copying and pasting the data into the tables of Project. If you need to do this on a regular basis, you would have to write some VBA code in Project, which asks the user for an Excel workbook to be imported and then automatically imports the data. I do not have a ready-to-use code snippet for this, but it shouldn’t be too complicated to write.

Tom, thanks for your comment. First, you are commenting on a 11-years old blog post here. In the meantime, I have done a lot of improvements and variations and published my results here. You should check out and browse through the category Choropleth Maps of this blog and you will find a lot of additional information how to create filled maps in Excel. As for your specific question: the code is only colouring shapes on a worksheet. The mapping of values to the shapes is done in a cell range named MapNameToShape. If you want to have a different Choropleth Map (like Canada in your case), you need to insert the map as freeform shapes, name the shapes and adjust the mapping of values to shapes. To get you started, have a look here: Build your own Choropleth Maps with Excel and/or here: Create Excel Choropleth Maps from Shape Files and, if you have Excel 365, especially here: Optimized Choropleth Maps in Microsoft Excel I hope this helps.

Ibrahim, here you go: map_yemen_by_governorates

Dustin, the following blog post provides Choropleth Maps of Germany by ZIP-codes (PLZ2 and PLZ5) in Excel for free download: Create Excel Choropleth Maps from Shape Files If you need the greater Munich area only, you have to take out all shapes you do not need, adjust the input data range and recreate the shape index. This shouldn’t take too long. I hope this helps.

Andy, please have a look at my reply to Jason’s comment on December 18, 2017 above. I also posted an example workbook to download in my comment.

Maria, I do not know of a way to display numbers as fractions in Tableau. The only way I see would be to create a Calculated Field dividing the decimal number into the integer, the nominator and the denominator and concatenating those parts separated by the fraction slash.

Julie, the command button is the grey box in cells C1:E2 of the worksheet [Words]. The label of the command button says "Split text from a text file into words".