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
Anna, you can simplify the formula if you do not need the filter, but why should you? Simply select All in the combo box once and for good and then delete the combo box. The cross tab will then always show all the items without applying any filter.
1 reply
Nina, Have a look at this article: Highlight Actions in Microsoft Excel I assume this is the technique you are looking for.
1 reply
Pradeep, of course this works with later versions of Excel, too (which you can easily test by simply downloading the workbook). With regards to defining different color scales: have a look at the optimized version provided in this article: Faster Choropleth Maps with Microsoft Excel
Toggle Commented Aug 1, 2018 on Choropleth Maps with Excel at Clearly and Simply
1 reply
Hans, "On Error Resume Next" was there on purpose. If .SpecialCells doesn’t find anything (in your example formula cells returning a text), the code will throw the error. On Error Resume Next simply skips the line and the code will finish without the error. Simply put back in "On Error Resume Next" and you should be ok.
1 reply
Linda, this is not Tableau, it is an Excel workbook with VBA code (Visual Basic for Applications). The code colours the shapes of the map. To change the code, press ALT-F11 to open the Visual Basic editor, select the module modChoroplethMap in the Explorer pane on the left, search for the line of code I mentioned in my previous comment and make the changes I described. Finally run the code by e.g. selecting another state on the dashboard. This should do the job.
1 reply
Linda, in the module modChoroplethMap, simply replace .Line.ForeColor.RGB = 9868950 ' grey line color by .Line.ForeColor.RGB = C_COLOR and the borders of the states will be black instead of grey after you selected another state on the dashboard. I am sorry, but I do not understand the other part of your question. There is no such thing as a dual axis (this is not a chart, just a collection of freeform shapes) and there are no tooltips.
1 reply
Noel, regarding tooltips: please refer to the follow-up article to this post. If you want to use integer or float numbers instead of percentages, you have to adjust the bins (thresholds) defined in cell range B19:B28 on the [Control] worksheet. You would also have to change the formulas in the corresponding column D to display the legend correctly.
1 reply
Ismail, I am not sure what you mean by "only offline", but "non-commercial" does not mean that you are not allowed to use the code and template in a corporate environment. You can use the template and code in the models you are creating for work, but you are not allowed to sell the template as it is.
1 reply
Ismail, I am publishing my content under a Creative Commons License. Please refer to the link in the section "License" on the left sidebar of the blog.
1 reply
Ismail, I do not have a template of a USA MSA Choropleth Map in Excel, but you could try to find the ESRI Shape Files online and create your own Excel map. Have a look at this article: Create Excel Choropleth Maps from Shape Files
1 reply
Tim, I just double checked. The link is still working and the file is not corrupt. It is a huge workbook (45 MB, more than 400,000 data rows), so it takes a while to open it, but it is not corrupt.
1 reply
Aaron, you would call the status bar before or after each call of one of your subs. You would need to enhance the sub a little bit and not only pass the total number of iterations, but also the current iteration as a parameter and delete the For Next loop inside the code of the progress bar sub. As you mentioned, some subs will probably take longer than others, so displaying a percentage value wouldn't make much sense. Instead, you could display something like "step 1", "step 2", etc. Another idea would be to have two progress indicators: the first showing the step (i.e. which subroutine is running at the moment) and the second one displaying the percentage of completion inside this subroutine (starting by 0 again when calling the next routine).
1 reply
Alyssa, please have a look at my reply to John’s question on January 13, 2016 at 5:41 PM.
1 reply
Way, here are the main steps: 1. Adjust the data to have only data from 2011 to 2017 2. Make sure the combinations in column ID (Country/Year) on the data sheet are adjusted, too 3. Adjust the values of myMin (=2011) and myMax (=2017) on the control work-sheet 4. Set the value of myCurrentValue to 2011 (as a starting point) 5. Rename the rectangles on the dashboard: Rectangle_2013 becomes Rectangle_2017, Rectangle_2012 becomes Rectangle_2016 and so forth 6. Delete all not necessary rectangles on the dashboard (Rectangle_2006 and earlier) 7. Adjust the axis labels of the rectangles 8. Resize / reposition the rectangles as you like This should do the job.
1 reply
Prolay, in the data tab right click on the dimension, select Default Properties and Sort, activate Manual and use the Up and Down buttons to define your prefered sort order.
Toggle Commented May 17, 2018 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
Praveen, I think your problem is less the task of building a dynamic hierarchy as described above, but rather the question how to detect the level of hierarchy for each employee in your data source. I found this thread on the Tableau forums where Tableau Zen Master Jonathan Drummey apparently provides an SQL based solution for the problem: https://community.tableau.com/thread/146224
1 reply
SAhuja, simply drag the measure which represents the weight between the connections to the Color Shelf or (maybe even better) to the Size Shelf of the Line Chart.
1 reply
Helen, I can't reproduce your issue. I just tried (Tableau 10.5 and 2 Excel files) and it works like a charm. What version of Tableau are you using and what are your data sources?
1 reply
Ryan, have a look at this workbook and its code: Download Customizable Tooltips on Excel Charts 2 Sheets (81.9K)
1 reply
Chris, if you only need a world map in Excel, have a look at this post: Choropleth Maps with Excel If you need the map created from polygons, have a look at this link: Download create_shapes_from_polygons_world (45 MB) This is the map I created from polygons using the tool described above.
1 reply
Ashish, I am sorry, but I do not know of a way to set up action filters with an OR condition. This doesn't mean it impossible, but it is above my head. Maybe you want to post your question in the Tableau forums? If you don't get an answer there, it probably isn't possible...
Toggle Commented Mar 26, 2018 on The Power of Tableau Actions at Clearly and Simply
1 reply
Jennifer, I know. there are some countries missing on the map. I do not have the time to update the map, but you could do this on your own with the help of one of the following posts: Build your own Choropleth Maps with Ex-cel or Create Excel Choropleth Maps from Shape Files Regarding the ISO codes: the abbreviation column on the data worksheet does not play a role in the technique of coloring the countries on the map. If you need to change the values in this column, you can do this right away and the code will still work. Having said that, do not change the values on the control worksheet, because this is the mapping of the named ranges on the data worksheet to the shapes of the map.
Toggle Commented Mar 23, 2018 on Choropleth Maps with Excel at Clearly and Simply
1 reply
Jeff, line charts have minimum and maximum scales on the category axis, too, but only if the data on the X-axis is numerical or a date/time and this seems to be not the case in your set-up. It won't work if you have a categorical dimension on the X-axis. If you are trying to visualize the development of blood pressure, date/time should be on the x-axis and blood pressure on the y-axis. The chart would then show the development of blood pressure over time and the information about the arm should be shown in the tooltip. This would work with the technique I have shown above.
1 reply
tomek, I do not have an Excel 2007 installation available anymore and therefore cannot reproduce your issues. I am sorry, but I can’t help you here.
1 reply
Mike, I would assume you have a sub, a function, variable or a constant defined somewhere in your own code with the name "Format". This declaration is in conflict with the name of the VBA function "Format" I am using in the Message Box. Simply rename the sub or variable you named "Format" and it should work.
1 reply