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

    Elegant/pretty spreadsheets

    Hi, Can someone give me advice on how to make my spreadsheets better looking? I am not at all artistic and I want to make my spreadsheets (not charts, graphs) more elegant looking with nice colors and fonts. I have no color sense and everything I try looks very amateurish. Is there anything on...
  2. N

    Squiggly lines

    Hi, I can't seem to find it but Chandoo listed somewhere how he adds those nifty squiggly lines that he uses in his comments and in his tutorials. He downloaded some drawing program to do it. Can anyone remind me what this program was and where I can download it? Thank you, NIRAV
  3. N

    Clustered stack - coloring

    Thanks, Luke. Now if only Chandoo had some templates for clustered stack columns... he can make them look SO much prettier than me! Best, NIRAV
  4. N

    Clustered stack - coloring

    Hi all, So Chandoo says I can change the clustered stack to look better in COLORS "with just a few clicks" (http://chandoo.org/wp/2009/02/09/review-of-pts-clustered-stack-chart/). Can anyone show/explain me how to do this?? Thank you! NIRAV
  5. N

    Add reference line to chart

    Hi all, I used one of Chandoo's bar graph/chart templates and it worked beautifully (as always) but I wanted to now add a reference line to the chart. For example I want to show via a simple straight line that the national sales target is 7.1% across the next 12 months. How would I incorporate...
  6. N

    Can't get started with Subtotal

    Hi, I just can't seem to figure out the Subtotal function. I have my data configured this way: Russian books Chinese books Area Metro East NY Queens, NY 0 400 Brooklyn, NY 500 300 Brooklyn Heights, NY 0 500 Manhattan, NY 200 200 East Detroit Detroit North 500 0 RCM Northern...
  7. N

    Help with Chandoo's instructions

    Thanks Luke. You da man. :) NIRAV
  8. N

    Help with Chandoo's instructions

    Hi there, Been following the step-by-step instructions on Chandoo's link/tutorial: http://chandoo.org/wp/2009/03/12/comparison-charts-1/ - and it says to put in some Index formulas. Trouble is, it doesn't say where I'm supposed to put it. I'm a novice. Can someone talk to me like I'm a 5...
  9. N

    Top 10 unique text

    Luke, I'm humbled by your sheer awesomeness. Thank you! Problem freakin' SOLVED, baby! NIRAV
  10. N

    Top 10 unique text

    Hello, I have 700+ rows of survey responses with "free form" text such as the below example. I need to sort all of these to arrive at the top 10 or 15 responses. Since there were extra spaces, punctuations and other problems scattered thruout the list I used delimiters to sort the words into...
Back
Top