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

    power point and excel question

    Hi, I think I am asking the question to right forum. Reference: http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/ My question is reference to above link. 1. I am preparing sales collaterals. One common requirement I have from engineering team is case...
  2. J

    Gauge Chart: Sharing my template

    Hi, Perhaps my first posting. (I have asked many questions, but posting something for the first time.) I hope, I am not making any mistake while doing so. Gauge Charts did fascinate me from the first time I saw and used. I wanted to create a template that will explain as well as provide a...
  3. J

    Problem with named formulas

    Hi, I am using named formulas in my excel. Ofcourse, I am new to it. Here is the problem I am facing: 1. I have a formula that does not use any cell reference e.g. DateOfFirstDay = DATE(YEAR(TODAY()), MONTH(TODAY()),1) This works perfect as there is no cell reference. 2. I have another...
  4. J

    2x2 charts

    Hi, Any idea on plotting a 2x2 chart with area of circles in each quadrant proportional to data point. regards, Jagmohan
  5. J

    (Long Mail and too many questions): Populating database

    Hi, Here are some questions. I will very glad if someone can help me here. Background: 1. Making a management review meeting template. 2. In each management review meeting, per project following needs to be done a. Capture actual cost for the current week b. Capture cost forecast for...
  6. J

    Searching in a table

    Hi, I am not sure how should I do this in Excel. 1. I have a 10x10 table with unique values. 2. I want to search this table for an exact match and get the value in the left(right)most column corresponding to this row. e.g. if the match is found in Column 4, Row 5 then I want value in Column...
Back
Top