Chart 1 --> Bar graph with top 5 defects in different colors and remaining in the same color. Chart 2- --> Take the top5 results of the chart 1 and show the chart on the specific date,

If you're talking about the legend, I'd create a legend worksheet, since the colours for each error type will be different depending on your filter selection.