6 Attachment(s)
EXCEL (macro) - Analysis of hourly intervals from sectional graph, correlation
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.
Attachment 21308 -> Table
Attachment 21305 -> Graph made from whole table
Attachment 21306 -> Sectional graph made from table, when i clicked 19:00. So it shows 1 hour before and 2 hours after.
Attachment 21307 -> 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.