EXCEL (macro) - Analysis of hourly intervals from sectional graph, correlation

[jezurka]

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.