I've been asked to generate a bar chart that shows the frequency of an event occurring by week (used number of observations as freq). Now that's the ok part (I think)- done a bar chat and formatted the date so it's a week format.
But now what they want is an monthly average of the frequency plotted as a line with the midpoints being the line joining the second and the third week.
Does this make sense at all? I have a feeling the lovely annotate is on the cards!
Any help would be greatly received!