Recent content by Hellomoto

Thanks for your reply Luke. Although the physics of a funnel is clear, I think most business execs failed elementary school physics :) Some genius saw that the curves produced by the reduction in stuff as it goes through the phases looks like a funnel. Hence, the use of the term funnel. That's...

I want to create a product funnel chart (a funnel oriented horizontally) using a bubble chart and a picture of the funnel as the background. the picture is aligned such that each phase review is aligned with a whole number in the x-axis. Then, the idea is to plot bubbles in the space between the...

What are the differences between Indirect and offset? Both functions can be used to perform the similar tasks. When is one better than the other?

I figured out why it didn't work. I didn't enter any text in the cells. After typing something in the cells, the filter command worked. It can't handle blank cells. Two issues with this technique: 1: pictures don't work. to use pictures, create an autoshape and fill with picture 2: the...

Hi Hui, How is the filter actually applied. I get the error message: The command could not be completed by using the range specified. Select a single cell within the range and try the command again. I created two objects (using insert>shapes), placed each in its own cell. Tried...

I thought I read this in one of the chandoo blogs but could not find it anymore. the best search term is eluding me. This is what my memory tells me: (sorry for not being very clear, my memory is shotty) for dashboards, instead of using the traffic lights found in excel 2007 conditional...

Thanks Luke, I didn't know that the first argument in lookup can be a range... always learning something new at chandoo.org. I spent hours coming up with creative ways to use sumproduct and other functions, all worked but not elegant. Should've posted this question sooner. Again, thanks Luke.

I created a table consisting of 5 questions (columns B,C,D,E,F) x number of survey responders (estimated to be 100+ rows). Each cell will be validated so that each respondent will select from the following: No, yes, maybe, and N/A. Each response is weighted, example: No= -3, yes=+3, maybe=+1...

this question was inspired by "Making a Dynamic Dashboard in Excel [Part 2 of 4]". Assume scenario: I have 4 tables of data( A, B, C, and D), all the same size and type of data. e.g. 5x6 filled with text. Cell A2 is validated to list A,B,C, and D. Below A2 is a blank table with equal size and...

kchiba, good point. I sort of "cheated" by forcing all the expenses to be on separate days. So the first expense would be due on Dec 12, the next expense is moved to Dec 13 (or dec 11). I felt the cheat was acceptable because there aren't that many expenses that fall on the same date or day of...

Hui, The reason why I separated the month and day is because I used the Vlookup function to compare the day from column A (or B) to the day in the data table. example: IF(ISNA(VLOOKUP(DAY(B21),$O$21:$O$29,2,FALSE)),"",VLOOKUP(DAY(B21),$O$21:$O$29,2,FALSE)) Where the Range is $O$21:$O$29...

After finding this sight, I got motivated to create my own excel 'something'; and that something is a daily budget worksheet. The worksheet looks like this: Column A lists months, Column B lists days of the month, Column C lists names of expenses, Column D lists dollar amounts, column E is the...