+ Reply to Thread
Results 1 to 2 of 2

Need to show seen bar in front of slots bar

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Pittsburgh, PA USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need to show seen bar in front of slots bar

    I have used Excel since 1996 and most of my chart requests have been relatively simple, but this problem has me stumped.

    We are tracking medical appointments over time for 9 providers.

    Each of our providers has X slots in a month. X varies from provider to provider and month to month.

    Each of our providers has Y completed appointments (seen) for that month. Y also varies for each provider and each month.

    Providers are along the X axis. Slot and seen counts are on the Y axis. Each month is a separate set of vertical bars.

    The first edition of this chart shows X and Y side by side for each month. That gets pretty cluttered after 3 months of history. Nine providers with 6 bars each is a mess.

    We want to show slot counts instead of percentages because we want to differentiate between providers with 8 slots in a month vs providers with 150 slots in a month.

    I want to show Y in front of X for each month. That would display one vertical bar showing X for each month with Y as a lighter color in front. A stacked bar chart won't do it because it converts it to a percentage. How can I do this?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: Need to show seen bar in front of slots bar

    Move Seen series to secondary axis and increase Gap Width to narrow the columns.
    Delete secondary Y axis to force both series to use primary Y axis scale.
    Cheers
    Andy
    www.andypope.info

+ 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