Uh...
Maybe create a pivot table of the data, put the date as the row value, and set MAX value for a given column as the column filter, then create a chart,
then clone the chart, change the column index,
and iterate till you have all your charts?
Anyway I feel like pivot charting will be the best approach.
With an example file, I'd be more comfortable saying more specific things.
Bookmarks