Search results

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

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...

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...

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...

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...

Luke, Thanks for the information! Best, Kelly

Hello, Thank you; that's great information! So, it seemed to work: my $0s became nothing. Great. In addition to the number, I'm also choosing Label Options -> "Category Name" (i.e., "Delta" shows up on one slice, "Gamma" shows up on another slice, etc. Any method of *not* showing...

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...

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...