VBA Plots KPIs Values Against Dates for Multiple Series

Hi All,

This is my first post on excel forum.
I am stuck with a typical problem. I have data set in the below format...
I need to plot individual Line markers graphs for each of the KPIs....i.e.

Graph 1 - > It shall plot KPI 1 values for Host 1 and Host 2 (Host 1 and Host 2 becomes the series and date should be X axis)
similarly...
Graph n - > It shall plot KPI n values for Host 1 and Host 2 (Host 1 and Host 2 becomes the series and date should be X axis)

The dates May or May NOT be exactly same for host 1 and host 2...i.e. host 1 may be plotted for 10 dates whereas host 2 plotted for 15 dates....

Bascially this process is to be executed for 100s of KPIs and hence I need the most efficient code to avoid any unnecesary load/time for processing...
Your help shall be really appreciated.

Regards
Mangalam


Time HOSTNAME KPI1 KPI2 KPI3 KPI4
24-Sep-2013 21:00:00 Host1 50 0 0 0
24-Sep-2013 20:30:00 Host1 60 0 0 0
24-Sep-2013 20:00:00 Host1 70 0 0 0
24-Sep-2013 19:30:00 Host1 80 0 0 0
24-Sep-2013 19:00:00 Host1 100 0 0 0
24-Sep-2013 18:30:00 Host1 20 0 0 0
24-Sep-2013 18:00:00 Host1 30 0 0 0
24-Sep-2013 17:30:00 Host1 40 0 0 0
24-Sep-2013 17:00:00 Host1 50 0 0 0
24-Sep-2013 16:30:00 Host1 70 0 0 0
24-Sep-2013 16:00:00 Host1 90 100 0 63.63636364
24-Sep-2013 15:30:00 Host1 100 100 0 57.14285714
24-Sep-2013 21:00:00 Host2 20 0 0 0
24-Sep-2013 20:30:00 Host2 54 0 0 0
24-Sep-2013 20:00:00 Host2 56 0 0 0
24-Sep-2013 19:30:00 Host2 26 0 0 0
24-Sep-2013 19:00:00 Host2 80 0 0 0
24-Sep-2013 18:30:00 Host2 305 0 0 0
24-Sep-2013 18:00:00 Host2 40 0 0 0
24-Sep-2013 17:30:00 Host2 50 0 0 0
24-Sep-2013 17:00:00 Host2 70 0 0 0

Hi all,

Any clues?

Thanks
Mangalam