Plot a Chart: selecting maximum of multiple Y values (by the thrid category) for a same date point

i know how to plot a time series via vba. However, i have a speical case. I have below data to plot: