Hello guys,
my problem is about making analysis of hourly intervals from sectional graph (like mean, min, max) and then subsequent correlation among columns D-F in table. Graph is made from table.
I started with MATLAB, where i made application, which exports data into Excel in form of table and then in VBA I made macros for creating graphs from table. Below u can see current results.
Sectional graph is made like when u click in the column "C" on some time. e.g.: 19:00. The graph will show one hour before this time and 2 hours after.
tabulka_excel.jpg -> Table
Cely graf.jpg -> Graph made from whole table
usek.jpg -> Sectional graph made from table, when i clicked 19:00. So it shows 1 hour before and 2 hours after.
visual.jpg -> Code in Visual Basics for making sectional graph
So i just need to make analysis from sectional graph..The best thing will be to insert it into macro for sectional graph. But i dont know how. I cant using VBA at all.
Thank u very much.