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
Alok, not with the basic implementation posted in the article above. However, it is possible of course. You would have to adjust / enhance the VBA code to make sure only unique texts are displayed. The VBA project in the workbook posted for download has no password protection, so please feel free to adjust the code as you like.
1 reply
Kristie, I am sorry, but I do not understand your question. Can you please describe your problem / requirement in more detail or post an example workbook somewhere?
1 reply
Ankamma, you can combine measures and dimensions in dynamic sorting by following the steps 3 and 4 in the section "the enhanced version" of the article above.
Toggle Commented May 17, 2016 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
jcaron, what is the problem with downloading the workbook?
Toggle Commented May 12, 2016 on Cartograms in Microsoft Excel at Clearly and Simply
1 reply
Philipp, unfortunately, I can't tell you why the appointments in Outlook do not show up after you dragged and dropped them into the other calendar. As you said, maybe an Outlook issue. Truth be told, I am everything else than an Outlook expert. Having said that, maybe you can avoid the workaround. The question to export the tasks to another calendar has already been raised and answered. Please search for my conversation with Aileen back in July 2010 in the avalanche of comments above. There is a little code snippet provided which allows to specify the calendar the tasks shall be exported to.
1 reply
Flo, the code uses Windows functions for the timer and this will definitely not work on a Mac. Go to the code and delete the module modTiming and in the module modMain the sub EHTimer and all calls of EHTimer. This should at least eliminate this restriction. No guarantee it will fix all problems, though. I do not have a Mac available, so I can't test this.
1 reply
Nikita, I do not know what Amrit's problem was, but I do not think there is any difference between using the camera tool and a shape linked to a cell range or named range.
1 reply
Nikita, shpClickBox isn't supposed to show anything. It is formatted to be invisible and used to handle the web actions. shpToolTip is the shape which shows the tooltips. Are you sure you have the name of the shape correct and the shape is linked to the cell range with the content? If you want to, you can send me your workbook by email and I will have a look.
1 reply
Catherine, it is a very simple code snippet and it works well on my PC, so I assume this might be a Mac problem. I can't reproduce the issue because I do not have a Mac available. My wild guess would be that the .GetOpenFileName statement is causing problems, because of different file type definitions or the different path separators (":" instead of "\") on a Mac. You could try to call .GetOpenFileName without parameters (i.e. simply delete everything in parentheses behind the statement) and see if it works then. Just a wild guess, though. I am poking around in the dark here. Sorry.
1 reply
PM, I am not sure I understand what you mean by "label version". In the enhanced template you are referring to, the textboxes are labeled with the absolute value, the percentages or both, depending on what the user selected with the radio buttons. Maybe you want to add the category names to the labels? If so, I would recommend against this idea, because the category names are already shown in the row and column headers (so the label would just be redundant information) and – even more important – this would clutter the display. See also my reply to Erna above.
1 reply
PM, this is not exactly how a Marimekko is defined, but it is possible, of course. You will need another cell range with the values defining the widths of the columns and a few changes in the code to use those values in the calculations of the widths of the textboxes: another named range, one or two more variables, a few additional lines and a few changes in the calculations of the columns widths should do the job. The VBA project is not password protected, so feel free to change it as you like.
1 reply
PM, the width of the column is relative to the sum of this column divided by the grand total. Have a look at the original file I posted for download: the sum of the first column is 553. Grand total is 4,552. The width of the first column makes 12.1% of the total width of all columns. The sum of the second column (477) divided by the grand total makes 10.5%. Thus, the width of the second column makes 10.5% of the total width of the marimekko, and so forth. If all your columns have a width of 8.3%, I'd assume you have 12 columns and each column has the same column sum. Maybe the data points by column in your data are percentages and each column adds up to 100%?
1 reply
PM, maybe I am misunderstanding your question, but the column widths are already adjusted according to the total value of each column.
1 reply
Sandip, I created the texts with the triangles in a text editor (e.g. Word), copied the text and inserted it into the parameter list in Tableau. It is important to use a symbol from one of the standard font types (like Arial), not from a special font like Symbol or Wingdings 3.
Toggle Commented Apr 6, 2016 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
Mauricio, you have to take care of the numbering convention in the first column: the number of the topic followed by a period and the number of the checklist item. The code uses this first column to identify what is a topic and what is an item and which item belongs to which topic.
1 reply
Neil, here is the required step by step to insert more columns into template 08: 1. Insert entire columns (as many as you need) after column H, i.e. between Status Column 4 and Status Column 5 2. Copy the entire column H and paste it into to the columns inserted in step 1 3. Change the last parameter of the UDF StatusCompletionRate in row 3 for all inserted columns and the last status column. Column H has as the second parameter 7. Set the second parameter of the UDF in cell I3 to 8, in J3 to 9, in K3 to 10, etc. 4. Adjust the column headers as you like As per your second question: this is possible, but you need to combine the VBA code of the various templates in one workbook. As you said, definitely too much to explain in a step by step. You can send me an email with your requirements and we can discuss what you need and how long this would take.
1 reply
Sifar, instead of trying to pass several non-continuous ranges to the UDF (which will not work, of course), you have to adjust the code so that only the visible cells are transferred to the VBA array varWordList. Have a look here: Download Word Clouds UDF filtered only (zipped Excel workbook, 58.5K) By the way, if you received the code from someone else and my name and blog URL weren't in the comment header of the code modules anymore, this "someone" is breaching my license terms.
1 reply
Sifar, before I answer your question, I would like to ask you something first, if you don't mind. You find a piece of code on a blog with an open comment section and instead of posting your question in a comment here, you start a thread on another forum. I have seen this behavior before and I was really wondering why readers are doing that. Don't get me wrong: I am well aware that many outstanding Excel and VBA experts are active on forums like stackoverflow. However, they do not know the code you are referring to and first have to understand the entire context of your question. Can you please tell me why you are transferring your problem to another forum instead of directly asking your question here on the blog where you got the code from?
1 reply
Timothy, I do not have an iPad (I am using a Microsoft Surface), so I can't tell you for sure. My wild guess would be that the Office apps for iPad and iPhone may not support VBA (or only in specific versions). I never owned a Mac or an iPad, so I am sorry, but I can't help you here.
1 reply
Mark, technically: yes, you can use another chart type. Whether a line chart would make sense depends on how your data looks like, what you want to display and what you want to animate.
1 reply
Hilary, you are right, it is B5. Sorry for the typo. I am glad you got it working now.
Toggle Commented Mar 18, 2016 on Bring your tasks in a row at Clearly and Simply
1 reply
Hilary, "Project Plan" is indeed the name of the worksheet. If the sheet with the project plan has a different name in your workbook, you have to change the name in the VBA code accordingly. "myProjectFileName" is the name of the cell C5 on the worksheet. The code gets the file name with a File Open Dialogue window and it stores the name of the selected project file in this cell. But this is for informational purposes only (to document which file has been imported). If you do not need this information, you can delete the entire line of code. The import will still work.
Toggle Commented Mar 18, 2016 on Bring your tasks in a row at Clearly and Simply
1 reply
Rick, if you want to use this technique in your own workbook, you have the following options: Option 1: copy the entire worksheet from my template to your workbook and adjust the named range myData to cover all rows and columns of your data. Delete the existing data and transfer your own data to the range myData (by e.g. copying and pasting or by linking to another sheet of your workbook). Save the workbook as a macro enabled workbook, close it and open it again. Option 2: conduct the following steps: 1. Go to the VBE (ALT-F11), click on the worksheet object of my template and copy the entire code of this object. Go to the worksheet object of your workbook (the one with the data in) and paste the code there 2. Go to the worksheet and insert the named ranges myActiveRow (set it to e.g. 4 as an initial value, it will be updated by the code during execution) and myData (the range where your data is) 3. Go to my template, copy the 2 textboxes myExtensionRight and myExtensionLeft and paste them to your workbook. The Selection Pane (Alt-F11) will make it easier for you to select and copy the textboxes 4. Save the workbook as a macro enabled workbook, close it and open it again. One remark, if I may: if you really have 90 columns in your data, I do not know if the technique will work well. It depends on the widths of your columns, but if e.g. 20 columns are visible on the screen, one textbox would have to display up to 70 data fields, i.e. the textbox would have 70 rows. Even if you decrease the font size of the textboxes to e.g. 8, this is probably too much to be visible on the screen.
1 reply
Meghan, have a look here: Download Marimekko Template with Labels (53.9K)
1 reply
Craig, I never tried a map of New Zealand, but I do not see why the tutorial shouldn't work for New Zealand. It always depends on the EMF- or SVG-file you are using, though. If it doesn't work with your SVG-file, you could also try to find ESRI shape files and transform them as described here: Create Excel Choropleth Maps from Shape Files
1 reply