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
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
Maritza, first of all I would recommend to check out the following post, which provides a much faster algorithm to color maps with many regions: Faster Choropleth Maps with Microsoft Excel Secondly, you can create your own filled map. Have a look at these posts: Build your own Choropleth Map with Excel and / or here Create Excel Choropleth Maps from Shape Files
1 reply
Erika, the link at the top still works fine for me, but if it doesn't work for you, please send your mail to clearlyandsimply [at] online [dot] de
1 reply
Erika, I am sorry, I don’t speak Spanish. I used Google Translator, but I am not sure I fully understand your question. What I think I understood is that you want to use only four colors based on formulas. This shouldn’t be a problem. Maybe you can send me your workbook by email (E-Mail link at the top of the blog) with a description in English what issue you are facing and I will have a look as soon as possible.
1 reply
Minnaar, it depends on the purpose of the dashboard and which story you want to tell. In the example shown above, the focus of the dashboard is on the current status of the testing. In this case, showing the cumulative development of testing actuals vs plan and the success rates is more effective than displaying the individual results per week. Having said that, I agree with you in general. If you want to focus on the testing performance per period, you would rather display the values per week or month instead of cumulative numbers.
1 reply
Alexander, you are right, you can simply copy an entire sheet and paste it into your own workbook. However, the copy-paste-action will not only transfer the custom shapes but everything else, like the data connections, the calculated fields, the sets, the parameters, etc. Whatever is relevant for the copied worksheet will be included in the copy-paste-action. If you only need the custom shapes from the other workbook, you have to get rid of all these components afterwards. I am sorry, but I disagree with you. I think my method described above (including the provided Excel tool) is much easier to get access to custom shapes in other workbooks than simply copying and pasting a worksheet.
1 reply
Anwer, I just double-checked and the link is still working for me. I guess this may indeed be an issue with the security or firewall settings in your environment.
Toggle Commented Dec 26, 2017 on Bring your tasks in a row at Clearly and Simply
1 reply
Anwer, there is an E-Mail-link at the top of the blog.
Toggle Commented Dec 26, 2017 on Bring your tasks in a row at Clearly and Simply
1 reply
Sheila, duplicate the original sheet by CTRL-clicking on the tab and dragging it to the right or left. Simply copying the cell range to a new worksheet will not work, because copying the range will not transfer the code and the named range to the new sheet. So, either drag the tab of the worksheet to the right or left while keeping the CTRL-key pressed or right click on the tab and use the command [Move or Copy].
1 reply
Anwer, make sure you have set the reference to the Microsoft Office Project Library in the Visual Basic Editor (Tools|References).
Toggle Commented Dec 23, 2017 on Bring your tasks in a row at Clearly and Simply
1 reply
Anwer, XLA files are Excel Add-Ins and have nothing to do with my code. You or your system administrator defined in Excel’s Add-In options to start these Add-Ins when Excel is opened. My code does not start or require any Add-Ins. Having said that, I doubt that your problems arise from those Add-Ins, but since I do not know these Add-Ins, I can’t give any guarantees.
Toggle Commented Dec 23, 2017 on Bring your tasks in a row at Clearly and Simply
1 reply
Anwer, except for the missing End Sub in your snippet, the code works for me. It writes the task information always to the same cells on the sheet, so you would have to increase the row counter in the For Each t statement, but other than that, the code works.
Toggle Commented Dec 22, 2017 on Bring your tasks in a row at Clearly and Simply
1 reply
Anwer, the VBA code is not password protected. I assume you clicked on the wrong VBA project in the VBE (maybe on an add-in you are running?). The VBA project in the workbook I posted for download is not password protected. All you have to know is that the main code is in the form frmProgress (right click on frmProgress and select View Code).
Toggle Commented Dec 21, 2017 on Bring your tasks in a row at Clearly and Simply
1 reply