I have multiple values for each date of sampling, and I want to plot the mean with SE bars for each date as a line graph.

But when I create the chart it instead shows multiple points at each date instead of a mean value. Am I a complete idiot? How can I get Excel to plot the mean, which for any replicated sampling protocol is what you want to do, not plot every single sample value.

Thanks!