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

    Tide tables - highest tide of the day

    The data is arranged as follows: January ------- Date Hours Meters 1 0350 2.50 0925 3.84 1600 1.06 2300 4.65 2 0500 2.30 1020 3.90 1645 0.93 2340 4.87 3 0550 2.08 1120 4.00 1730 0.84 and so on for every day of every month.
  2. I

    Tide tables - highest tide of the day

    Hi, I have a tide table of the daily water flow in a river during various periods of the day, maybe 3, 4 or 5 observations a day for a particular month. I want to automatically find the high tide for the day and find the total number of days in a month that have tides above 5 meters and...
  3. I

    Moving Avg trendlines not working

    Hi, In my worksheet of the daily index I have added a couple of check-boxes to enable a 52 week and 26 week moving average trendline. But, I am unable to remove individual trendlines when I uncheck the boxes. The code for 52k avg is as follows (similarly for 26 wk avg) and I have attached the...
  4. I

    Frequency Distribution Chart

    Hi, Thanks for the help. I am also trying to include a slide bar to automatically increase/decrease the intervals in the bin values. Any ideas on how we can do this? Thanks Ihsan
  5. I

    Frequency Distribution Chart

    Hi, Appreciate if you could be more specific. Thanks.
  6. I

    Frequency Distribution Chart

    Hi, Is there a way to create a frequency distribution chart (similar to the one below) without writing the values to the sheet. Here is the example: http://rapidshare.com/files/408594396/one-axis-data-distribution-chart-in-excel.xls Any help would be greatly appreciated. Thanks.
  7. I

    Graph from a worksheet array

    Hi Hui, Thanks for the file, it works great. But I have no idea why it didn't before. The data is not private, so delete as per your convenience. Thanks a lot.
  8. I

    Graph from a worksheet array

    Hi, Thanks for the prompt reply. I'm using 2007 but for some reason it is still not accepting the series function you mentioned above. Can you post the completed worksheet, I'll see whether it is working in my computer? That way ill know there is something wrong with the setup. Thanks
  9. I

    Graph from a worksheet array

    Yes, I tried the file name as well but Excel doesnt accept. Please have a look at my sheet. Thanks. Here is the link: http://rapidshare.com/files/408391777/Historical_data.xls
  10. I

    Graph from a worksheet array

    Did exactly as you said but Excel doesn't accept the named range Data!Volatility. Is there someway I can attach the excel file here?
  11. I

    Graph from a worksheet array

    Hi Hui, Thanks for the update. I have entered as follows: I have defined 1 range as BDI -> =OFFSET(Data!$C$5,1,0,COUNTA(Data!$C$5:$C$1997)-1,1) and the 2nd range as: Offset_BDI -> =OFFSET(BDI,-1,0) and the differences as: Volatility -> =BDI-Offset_BDI When I defined the...
  12. I

    Graph from a worksheet array

    I'm sorry but I am not clear as to how to do it. Is it like below: Sub Pass_array() Dim myarray As Variant myarray = Range("a1:a10").Value End Sub and them manipulate myarray? Would appreciate your help.
  13. I

    Graph from a worksheet array

    Hi, I have a table of daily stock prices/indicies for which I am trying to create a volatility chart. So, I am calculating the daily differences in prices as Today's price - Yesterday's price. These values I have stored in an array for eg. {=A2:A100 - A1:A99} My question is, can I directly...
Back
Top