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

    Adding a Sheet to a bunch of selected Workbooks [SOLVED]

    imla this is amazing thanks a lot and I really understood your code thanks to the comments! I'll give you all my internet points for the day. Cheers!
  2. A

    Adding a Sheet to a bunch of selected Workbooks [SOLVED]

    Hey can you give me an example of what the wbk variable would look like? Is it the actual path of the file or just the name of the workbook? Thanks
  3. A

    Adding a Sheet to a bunch of selected Workbooks [SOLVED]

    I was wondering if there is a way add a sheet or two from one workbook into a certain number of existing workbooks without having to manually do it one by one. Either an automated way of doing it or being able to select all the workbooks you want to add the specific sheet. If anyone knows a...
  4. A

    Extend a formula to a certain size [SOLVED]

    Well, I think I have a decently good automated system going now. Thank you very much for your time and effort. It really means a lot. Congrats on four years of service too!
  5. A

    Extend a formula to a certain size [SOLVED]

    Ok, I keep getting this message, the maximum number of data points that you can use in a 2D graph is 32,000 etc. I don't get why I am getting this error. If i am just highlighting the column and I only have data in 10 rows
  6. A

    Extend a formula to a certain size [SOLVED]

    For the chart you gave me, how is it ignoring your #N/A cells
  7. A

    Extend a formula to a certain size [SOLVED]

    If what I'm asking doesn't make sense. Try this: Open a blank excel sheet In column A1:A8 just type in random numbers Highlight all of column A Then insert 2D column graph. Notice how it just grabbed the values that were filled in and ignored empty cells even though I highlighted the whole...
  8. A

    Extend a formula to a certain size [SOLVED]

    Or is my only solution to keep the number of bins constant? And if I wanted to vary the number of bins I would have to manually make graphs for each?
  9. A

    Extend a formula to a certain size [SOLVED]

    All of the calculations are correct I think. I just want to paste data in and it will give me a graph output. However, if I try to create a graph using column F (my frequencies) the bins keep going out even though there is no data there. I was wondering if there is somehow an automated way I...
  10. A

    Extend a formula to a certain size [SOLVED]

    Here it is: https://www.dropbox.com/s/9zdw18qeus91x9p/Help%20please.xlsx
  11. A

    Extend a formula to a certain size [SOLVED]

    Hello, I was wondering if there is a way to extend a formula to a given size that I can give. I am trying to create a dynamic histogram and the data I have to input varies in size. Some data is 400, others 20, and some 20000. So right now I have just extended my formulas to 20,000 which is my...
Back
Top