+ Reply to Thread
Results 1 to 2 of 2

Help with charts and organising data

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Chester, England
    MS-Off Ver
    2007
    Posts
    4

    Help with charts and organising data

    PLEASE HELP!

    I have data for appointments booked at differnt veterinary branches. I'm trying to find a way to see how many appotinments are booked on each day of the week and at each branch. I can easily create a chart to see the count of appointments booked at branch a, b and c or a count of the appointments on each day, but I can't find a way to break this down to how many in each branch on each day (I hope this makes sense!).

    So for example, on the attached sample data I can see that on a Monday there are 2 appointments both in branch A and on a Friday there are 2 appointments in total but one in branch C and one in branch B. I obviously have signifficantly more data so am hoping there is an easy way to produce a chart for this in excel.

    Thanks a million in advance for your help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,064

    Re: Help with charts and organising data

    This attached workbook using Pivot Table and Chart might be the easiest and most user friendly method
    Attached Files Attached Files
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

+ 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