I have a MailChimp data export in google sheets and I want to create some charts that can show the best time of day/day of the week based on my data for our mail outs when compared to open rate (%). I have all the days and all the exact times but can't for the life of me find a way of setting up an axis for 24 hours and plotting the percentage of opens placed in the 24hour period to compare, or have the 7 days of the week and have the bars located with the highest average opens for each day, etc.. Is this possible?

  • select column B:C
  • Insert > Chart
  • tick Agregate for x-axis


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy