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

    Anyone attempted to create this using Excel ?

    Hi, For those who are familiar with Edward Tufte book, he talked about this interesting visualization example of a Paris Train Schedule by E.J. Marey. http://c82.net/posts.php?id=66 Wonder if we can re-create this in Excel ?
  2. P

    date issue

    Hi, Assuming below : A1 = 01 B1 = 31 C1 = 2011 D1 = Date(C1,A1,B1) .... then format it as Custom "DDD" is this what you want?
  3. P

    How to lookup a Value from a horizontal table ?

    Great ! It works ! Thanks so much !
  4. P

    How to lookup a Value from a horizontal table ?

    Hi, Have you come across a situation whereby you data is arrange in a horizontal table., lets say you have 3 rows. Row 1: Months Row 2: Sales How can I lookup the Month which has the highest sales ? If it is a vertical table, we can use INDEX and MATCH, but if its horizontal table, what...
  5. P

    How do I resolve this, Reference and Logical formulas, but it doesn't work?

    Hi Felix, Possible for you to upload somewhere a sample of the file, so that I can understand whats your situations. thanks
  6. P

    Challenge #1: How to create a Dynamic Histogram Chart based on a set of Records

    Hi, I have a set of transaction records and I need to learn how to dynamically create a histogram chart by filtering an unique value. I have created a excel to illustrate in details what i mean by that...hope someone can help. thks...
Back
Top