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
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
Juan, have a look at this post: Create Excel Choropleth Maps from Shape Files The article describes how to create Excel Choropleth Maps from ESRI Shape Files and comes with download links for Choropleth Maps of Germany by zipcode.
1 reply
ana, looks as if there are some references to libraries missing. Go to the VBE (ALT-F11), click on Tools and References and make sure Microsoft Excel 16.0 Object Library and Microsoft Office 16.0 Library are checked. If you are running Office 2013, activate the corresponding 2013 libraries.
1 reply
Yanna, try this: Sub RunTest() Dim datStartTime As Date Dim lngCount As Long datStartTime = Now() For lngCount = 1 To 10000 Application.StatusBar = _ "Iteration: " & lngCount & _ " Elapsed time: " & _ Format(Now() - datStartTime, "hh:mm:ss") DoEvents Next lngCount Application.StatusBar = Empty End Sub
1 reply
Bjoern, I am not sure what you mean by "sub agenda", but if you want to export to a different calendar than the default one, please refer to my reply to Aileen's comment on July, 5 2010.
1 reply
Leo, no worries, you have been as clear as possible. I do not know of a built-in Tableau feature which would accomplish what you are trying to do. Doesn’t mean there is no such feature, I just do not know it. All I can think of is the following work-around: Define a URL action for all other views of your dashboard (except the one that should show the image in the Web Page object), select "Run action on Hover" and about:blank as the URL. This way, the Web Page object on your dashboard will at least be cleared, if the user hovers over a data point of one of the other views on your dashboard. This will not be the case, if she/he hovers over a filter, a legend, an image, the title, etc., but at least if the mouse is moved to another view. Agreed, not really elegant, but it does the job. I hope this helps.
1 reply
Brenda, I just sent it again. Please check your inbox and maybe also your spam folder.
1 reply
Xavier, have a look at this workbook: Download Tooltips on Excel Charts – Hidden Rows (64K)
1 reply
Kevin, try this piece of code: Sub Export_Selection_To_OL_Appointments() Dim myTask As Task Dim myDelegate As Object Dim myItem As Object Dim intResources As Integer On Error Resume Next Set myOlApp = CreateObject("Outlook.Application") For Each myTask In ActiveSelection.Tasks Set myItem = myOlApp.CreateItem(1) myItem.Assign With myItem For intResources = 1 To myTask.Resources.Count Set myDelegate = myItem.Recipients.Add(myTask.Resources(intResources).EMailAddress) myDelegate.Resolve Next intResources .Start = myTask.Start .End = myTask.Finish .Subject = myTask.Name & " (Project Task)" .Location = "tbd" .Categories = myTask.Project .Body = myTask.Notes .Display .Send End With Next myTask End Sub
1 reply
Brenda, I already sent you the solution by email yesterday.
1 reply
Kevin, here is the code which sends an outlook invitation to all resources assigned to the task (provided the email-addresses of the resources are defined in Microsoft Project). Make sure to set the reference to the Microsoft Project library in the VBE. Sub Export_Selection_To_OL_Appointments() Dim myTask As Task Dim myDelegate As Object Dim myItem As Outlook.AppointmentItem On Error Resume Next Set myOlApp = CreateObject("Outlook.Application") For Each myTask In ActiveSelection.Tasks Set myItem = myOlApp.CreateItem(olAppointmentItem) myItem.Assign With myItem Set myDelegate = myItem.Recipients.Add(myTask.Resources(1).EMailAddress) myDelegate.Resolve .Start = myTask.Start .End = myTask.Finish .Subject = myTask.Name & " (Project Task)" .Location = "tbd" .Categories = myTask.Project .Body = myTask.Notes .Display .Send End With Next myTask End Sub
1 reply
Maritza, it’s because of how the algorithm is designed. If you group the shapes, the groups form a shape at top level of the shape collection and the algorithm does not look for and thereby can’t find the shapes inside this group. If grouping the shapes is important to you, you can add some code to ungroup the shapes before coloring and then regroup them again after the coloring is done.
1 reply
Brenda, I am sorry, I do not understand your question. What exactly do you mean by "I do not paint the shapes as it has to be according to the established ranges"? Can you send your workbook by email or post it somewhere for download?
1 reply
Christian, per definition, an ISO 8601 weeks starts on Monday. If the calculation produces the wrong results in your workbook, the start of the week is probably set to Sunday in your workbook. You have to change the starting date of the week to Monday (go to: Data|Data (…)|Date Properties) and it should work.
Toggle Commented Jan 14, 2018 on Week in, week out, Tableau at Clearly and Simply
1 reply
Maritza, I am sorry, I do not think I can help you based on the error descriptions you are able to provide in comments here. Can you send me your workbook by email or post it somewhere for download?
1 reply
Maritza, if you inserted new shapes (as you did), is crucial to run the sub RecreateShapeIndex. Otherwise the algorithm will not work correctly. i.e. the values and according colors will most likely not be applied to the correct regions.
1 reply
JC, if you have more than one chart on a worksheet, but want to display the tooltips only on the first chart, the Set_All_Charts sub would look like this: Sub Set_All_Charts() If ActiveSheet.ChartObjects.Count > 0 Then ReDim myCharts(ActiveSheet.ChartObjects.Count) Set myCharts(1).myEmbeddedChart = ActiveSheet.ChartObjects(1).Chart End If End Sub Change the "1" to the index of the chart in your sheet which shall disply the tooltips.
1 reply