Search results

Hi, I am looking to make a certain type of radar chart, which is basically a pie chart with each part evenly divided in number of degrees but the scores shown as the length of each part, similar as in this example:

Thanks! I am always cautious with VLOOKUP because people like to add columns to tables which messes them up (sometimes hard to notice if the data returned is comparable). Combining it with MATCH as you did makes it much more solid. For the 'Comparison' sheet I have the feeling that an array...

Hi all, I would like to create an overview of severance payment according to the local regulations in Indonesia, where my company is based. There are two lookup tables: A table with entitlements in months of salary based on the years of service. There are three entitlements: severance, reward...

Your comment makes much sense. However, I feel that getting a better understanding of Excel myself will be a good investment of my time. Besides that, I am enjoying it so you can also see it as a hobby. I might get an Excel whizkid on board to help me at a later stage, but I want to be able to...

While we agree that Excel is pretty awesome, things can always be improved. Let's share some pet peeves and hopefully workarounds to limit their impact. Here is one of mine: the Paste Special menu containing radio buttons instead of checkboxes so that it can take several repeated pastes to get...

If yes, then what is the meaning of the width? I find it visually confusing that the lowest scoring division has the largest surface area, but maybe I am reading it wrong?

A rated golf course has two scores that are input to the handicap calculation: The rating, which is the score that a scratch (handicap 0) golfer would score on a good round. For an easy golf course this will be lower than the actual par score, so if the par is for example 72 the course rating...

Can I ask, for which case would you use this chart? Does the width of each of the colors have significance?

Thanks both, it's working now. My first insight in the power of SUMPRODUCT.

Yes Power BI looks impressive and as I understand can also handle data from other sources than Excel.

I'm sorry but I cannot make it work. I have done what you suggested and copied the formula to E2, but whatever I do with the values, the result of the formula remains TRUE. It seems that the sumproduct itself is 0. Sorry for the sloppy data btw, I deleted line 6 now so there is only one value...

Thanks, I realize that my description was a bit minimalist. I am currently director of an SME production company where we do production outsourcing. I would like to use Excel to get a better grip on the business. At the moment I am enjoying the learning experience, but rationally speaking it...

Hi all, I am in a management position and have been working with Excel for many years. Recently I realized that my skills and knowledge are quite pathetic so I started doing an online course to refresh and expand my Excel skills. I strongly believe that becoming more Excel literate will help my...

Hello all, greetings from Indonesia. I am doing an online course at the moment and to keep learning about Excel during my commutes I was looking for a podcast, that is how I got to know about Chandoo. Looking forward to keep learning!

Thanks but as you can see all values are formatted according to the rule now, while row 9 should be not formatted since the value is 24. By the way, what is the reason that a column D is added to the data here with exactly the same values as column A? The value in B2 and B3 should have actually...

Not exactly, one day can have several lines for different activities, but I want the data to be highlighted when the sum of hours for that day in the whole table is not 24. In the attachment I formatted manually, 1 November and 31 October each have 24 hours reported so that is fine. 25 and 26...

Hi, I have a table where I would like to add lines of data for time spent on certain categories of activities each day. The columns are date, hours and category. I would like to give all lines where the total for that date is not exactly 24 (either less or more) a different color. What formula...