+ 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
    10

    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,067

    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)

Similar Threads

  1. [SOLVED] Organising Data from list into table
    By Ereid99 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-23-2018, 02:19 PM
  2. [SOLVED] Re-organising data in excel
    By be_insane in forum Excel General
    Replies: 3
    Last Post: 02-11-2014, 06:11 AM
  3. Need help organising data
    By Arvon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2013, 05:26 AM
  4. Help re-organising the data
    By billos in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2011, 12:14 PM
  5. Input filtering and organising the data.
    By supermario2k8 in forum Excel General
    Replies: 2
    Last Post: 05-01-2008, 06:00 PM
  6. Re-organising a table of data ?
    By sml in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2007, 07:42 AM
  7. organising data in a worksheet
    By Graeme in forum Excel General
    Replies: 2
    Last Post: 12-14-2006, 06:43 PM

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