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

Recent content by ang.ru

  1. A

    Finding Data Shortcut

    Thanks Hui!
  2. A

    Finding Data Shortcut

    Say I have a bunch of numbers that I want to find in my excel spreadsheet, like the following; 27001407 27001436 27001438 27001439 27001440 27001464 27001544 27001545 27001547 27001548 27001549 27001564 27001570 Is there anyway for excel to find all these for me at once instead...
  3. A

    Creating Multiple Scatterplots Automatically [SOLVED]

    Sam, Thank you so much! This worked perfectly!!! :D
  4. A

    Creating Multiple Scatterplots Automatically [SOLVED]

    Hi everyone, I'm currently making around 100 scatterplots for a set of data; is there anyway for excel to automatically make these for me instead of me creating each graph one by one? Here's the link to the data on dropbox for reference...
  5. A

    Adding Trendline in Excel [SOLVED]

    Hi SirJB7, Thanks for the help, I really appreciate it! (:
  6. A

    Adding Trendline in Excel [SOLVED]

    Sure thing! here's a link for just a little sample of what i have : https://www.dropbox.com/s/0idba1416bwk8un/Workbook12.xlsx and when I issued "?chtobj.Name, I", it identified "Sub Add_All_Trendlines()" as the error. What exactly does variable not defined refer to? thank you!
  7. A

    Adding Trendline in Excel [SOLVED]

    Hui, I'm currently using excel for mac 2011, does that have anything to do with it?
  8. A

    Adding Trendline in Excel [SOLVED]

    Hi SirJB7! a. Yes b. Yes c. I tried and it didn't fix the situation. Any other ideas? Though it would be a lot easier for me to upload the file, I unfortunately can't because everything on it is confidential.
  9. A

    Adding Trendline in Excel [SOLVED]

    SirJB7, For one of my spreadsheets, the code worked perfectly, but for another spreadsheet, I got a popup from excel saying "Compile Error: Variable Not Defined". Does anyone know why/what I can do to fix it?
  10. A

    Adding Trendline in Excel [SOLVED]

    thank you SirJB7 (:
  11. A

    Adding Trendline in Excel [SOLVED]

    Thank you, I appreciate the help :D
  12. A

    Adding Trendline in Excel [SOLVED]

    Thanks Hui, you've saved me so much time!!! Also, is there a function in excel that can automatically pick up trends (upward, downward, horizontal) and categorize them for me?
  13. A

    Adding Trendline in Excel [SOLVED]

    Hi all, I'm looking at roughly 200 graphs on a single spreadsheet, is there a option in Excel where I can add a trendline to all 200 at once, instead of doing it graph by graph?
  14. A

    Stagger Cells in Excel Spreadsheet

    Hui, My problem was inserting a row to the right and between each currently filled cell, hence the "staggering". I simply used bobhc's trick, the 3rd post.
  15. A

    Stagger Cells in Excel Spreadsheet

    Thank you all for the help, I have it all sorted out now :D
See more
Back
Top