• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Using Analytic Hierarchy Process (AHP) in Excel?

    Hi everyone, I'm working on a project and would like to utilize the Analytic Hierarchy Process (AHP) to try to rank and weight intangible criteria. (See here: http://en.wikipedia.org/wiki/Analytic_Hierarchy_Process .) Does anyone know of any Excel tools that do this? Thanks! Kelly
  2. T

    entering data in one cell but having it create a new column each time

    Hello, I hope I can explain this well enough to get some help. I'd like to enter a piece of data for "truck number" (e.g., M14853) in a cell on Sheet1. Then I'd like that same data (M14853) to populate another cell in Sheet2. For example, I'd enter "M14853" in Sheet1!A1 and it'd come up...
  3. T

    determining assignment dates T-5, T-10, T-20 dates before project review

    Hello, We always have project reviews on Mondays. In helping our client prepare for these reviews, we have provided them a "checklist": *T-5 business days (thus, previous Monday): make sure room is reserved *T-10 business days: (thus, two Mondays before) make sure all people are invited to...
  4. T

    adding data labels to bubble chart via VB and not add-in

    Hello, I'm interested in adding data labels to a bubble chart that I have. I have used the oft-reference "XY Labeler" (?) which works great, but as I eventually have to pass along my Excel file to my client (who may not be able to download this add-in), I'd like to embed some VB coding. I...
  5. T

    making Pivots off master project data but choosing which projects get calculated

    Dear All, This has been a very helpful forum, and I've already learned a lot. Thanks! I've created a rudimentary portfolio management tool for my client showing, among other things, charts regarding total budget, budget-by-fiscal-year, number of projects, etc. It works now but my concern...
  6. T

    Looking to not show 0 values in PivotChart

    Hello, I have a few PivotCharts and often I have values that are "0" (see here: http://twitpic.com/3g7clq ). Usually I just delete the "0" values manually from the chart, but is there a trick to not showing the "0" values at all? Note that in the picture, I'm only concerned about Alpha...
  7. T

    Bubble charts | how to differentiate bubbles that appear on top of each other?

    Hello, First off: what a great resource this is! I have two questions regarding a bubble chart that I created. 1) If I want to use a combination of colors for my bubbles, should I individually change each bubble's color? 2) I have a few bubbles (different sizes) that happen to be...
Back
Top