Hi Norbert, this was very helpful.  Thank you for the start.  I took what you did and added a date and filter.  My question is, I'd like the axis to show 6AM-8PM for each day.  But when I change the filter, the axis stays on the original date and doesn't show the chart.  I've attached my workbook.  Any thoughts.

That worked.  Thank you very much!

Another question, if appointments have the same starting time for the same office, is it possible for the bars to stack on top of each other?  Or how can I depict two appointments that coincide with each other? Thank you

If you look at the attached workbook, for 6/14, there are overlapping appointments for the South office: 12-1:30 and 1-2:30.  The second appointment (green) looks like it starts at 1:30 on the axis because the first appointment (blue) is over-top.

Thanks for the reply ZZ.  The ID is actually the appointment ID.  Some days we have 50+ appointments at one office so that would not represent the same thing in a few lines.  I think I will just do some borders to better show this.  My only issue will be, if you have overlapping appointments, the tooltip can only show the details for the top one.