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