Charting dates and times

**jrholden** · 08-12-2011, 04:33 PM

Greetings,

My situation is that I have appointments that I would like to chart with a stacked bar graph and have the dates as the X axis and # of appointments as the Y axis but also have the hour as a secondary Y axis.

**teylyn** · 08-12-2011, 06:30 PM

Hello,

can you draw on a piece of paper what you would expect that chart to look like? Create a drawing of the expected results, e.g. with the Excel drawing tools, and post that.

**jrholden** · 08-16-2011, 01:09 PM

Good Morning,

I included an example of the chart on the Chart Example tab. My goal is to eliminate the color banding in the columns and show how many appointments occur within each hour. I'm not sure if then the hours would become the primary axis and # appointments would be in a secondary??? For example, if Provider A did not have any appointments in the 6 o'clock hour then it would be blank but if he had 2 appointments in the 7 o'clock hour on the same day it would show a blank in the 6 and 2 appointments in the 7. This may not even be the right type of chart to accomplish what I need. Thank you so much for helping me.

**teylyn** · 08-17-2011, 07:23 AM

Again, can you draw (on paper or with an electronic drawing tool) what you would want the chart to look like?

Mock up a sample of the desired chart with pen and paper or with MS Paint (or a tool of your choice). Post that.