I have two columns: day of week, hours (for each day) and number of things occurring on each hour of a specific day of week.
Below an example with first two days:
I want to plot these data as a line chart where on the horizontal axis I only show the days (hours would make it too overcrowded), and I want to show in the grid the vertical lines for the days (start and end) and the day name (on the axis) should be centered between its too lines.
Below what I managed to get so far, by having the horizontal axis refer only to days:
As you can see the vertical lines are denser than needed, one for each record (on for each hour) instead of one for each day. Moreover I struggle to get the day name centered, it rests on the left.