2

I'm not sure exactly what this kind of chart is called, but I'm going to call it a "clock plot"

Basically I want to use it to visualize events that happen at certain times of day over say the course of a month. The idea is to record the time that this particular event occurs during the day and plot it on the graph. That way at the end of the month, I can visualize the frequency of the events over time. Is something like this even possible in Excel and if so, how could I do it? Thanks

enter image description here enter image description here

Improve this question
7
  • This can be created either by Pie chart or Radar,,, but the need is some sample data,, please Edit your post & share some sample data with us!
    – Rajesh Sinha
    Commented Feb 16, 2020 at 5:32
  • It's literally just a list of times (military time and AM/PM) with the cell formatting set accordingly. But I'll edit in the morning when I turn my computer on
    – audiFanatic
    Commented Feb 16, 2020 at 5:35
  • Hey @audiFanatic,, or U may check Tableau since Excel does have limit in that regard!!
    – Rajesh Sinha
    Commented Feb 16, 2020 at 6:13
  • Hi, @Jon Peltier I've seen that you have solved many issues related to data visualization,, can't you try this one for the benefit of the community?
    – Rajesh Sinha
    Commented Feb 17, 2020 at 7:36
  • @RajeshS I added the sample data as requested
    – audiFanatic
    Commented Feb 17, 2020 at 13:35

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .