+ Reply to Thread
Results 1 to 4 of 4

Charting dates and times

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2010
    Posts
    31

    Exclamation Charting dates and times

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Charting dates and times

    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.

  3. #3
    Registered User
    Join Date
    04-20-2011
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Charting dates and times

    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.
    Attached Files Attached Files

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Charting dates and times

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1