+ Reply to Thread
Results 1 to 7 of 7

advise on building a dashboard with my data

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    389

    advise on building a dashboard with my data

    Can anyone help me with a dashboard that will show me the individual stats Daily and Monthly for my headings in attached sheet, I know I am probably asking for more than I should but any help would be great.

    ps I have excel 2010

    Thanks
    Attached Files Attached Files
    Last edited by dougers1; 12-08-2018 at 01:31 PM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,707

    Re: advise on building a dashboard with my data

    Might be useful if you could tell us exactly what you want to show on this dashboard.

    BSB

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,592

    Re: advise on building a dashboard with my data

    A lot depends on how 'pretty' you want the dashboard to be. If it's meant to be pre-defined colourful report with fonts of various sizes or styles - the sort of thing you might need for a board report then that's one thing, on the other hand if you want a simple and efficient way of analysing, summarising and presenting the data showing different relationships then I can't help thinking a Pivot Table approach with a Slicer or two to filter it would be best.

    To make use of a PT you'd need to change the layout so that you have a four column table. The columns being

    Date
    Name
    Type of Measure - values in this column would be labels you have in C1:N1 Use a data validation list so that you can pick them
    Time/Value

    It may be that an additional helper column might be useful but we'll only know that if we have some visula idea as to what you expect to see
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    389

    Re: advise on building a dashboard with my data

    Richard

    the pivot option is fine this can be done with slicer then have the charts on separate tab yeah?- charts I would like to see would be monthly totals of hours worked, travel time, office time, annual leave ranked by order of amount per person

    I would also like to be able to select a date range example 3rd to 7th December so I can select weekly stats as well as monthly

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,592

    Re: advise on building a dashboard with my data

    OK,

    If you'd like to reformat your data into the 4 columns I mentioned then upload again I'll takea look.

  6. #6
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    389

    Re: advise on building a dashboard with my data

    Richard I need all the data, what I am trying to achieve is a dashboard that will show me a comparison of each person total shift pattern v job hours
    what I need to consider is the travel time and office time
    I would also like it to shot the total effectiveness for each person depending on the date range I select

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,592

    Re: advise on building a dashboard with my data

    I'm not sugggesting you don't need all your data.

    As I said if you'd like to reorganise your data (all of it) and reupload the workbook I'll take a look.

+ 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] Facing issues with data filtering || please advise
    By CaptainSpark in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2017, 05:28 PM
  2. Trouble building a dynamic Dashboard
    By Joao Aleluia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2017, 07:37 PM
  3. [SOLVED] Advice on building a dashboard
    By ClareLou in forum Excel General
    Replies: 1
    Last Post: 02-08-2016, 11:45 AM
  4. Freelancers for Dashboard building
    By Katherine82 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-13-2015, 02:13 PM
  5. Trying to Sort Data Please Advise
    By nick2560 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2014, 05:52 PM
  6. Data Model Advise
    By mpm000 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-03-2013, 11:49 PM
  7. help building a dashboard or graph !
    By masond3 in forum Excel General
    Replies: 1
    Last Post: 01-12-2012, 11:29 AM

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