+ Reply to Thread
Results 1 to 2 of 2

Need Help Building a Dashboard

  1. #1
    Registered User
    Join Date
    01-29-2021
    Location
    Cleveland, OH
    MS-Off Ver
    OFFICE 2016
    Posts
    1

    Need Help Building a Dashboard

    Attached is a file containing Sample Data in Table Format. I am looking to build charts on a Dashboard to display the following:

    1. "Previous Day Output" vs. "Daily Target": Display Actual, Target and % of Target Achieved
    2. "Current Week to Date Total Output" vs. "Weekly Target": Display Actual, Target and % of Target Achieved
    3. "Current Month to Date Total Output" vs. "Monthly Target" : Display Actual Target and % of Target Achieved

    Week is Sunday - Saturday

    The data table will be updated daily and displayed on monitor in our plant. Would need to display data based on Current Day, Week and Month.

    Any help would be greatly appreciated. I know how to build charts but do not know how to make them interactive do update as described above.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,241

    Re: Need Help Building a Dashboard

    In the top menu bar (lighter blue) you will see a Dashboard button, and if you click on this you will see the 3 winners of a Dashboard Competition held on this forum a few years ago, and you can also view some of the other contributions made at that time.

    Perhaps they will give you some ideas.

    Hope this helps.

    Pete

+ 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. Replies: 2
    Last Post: 03-20-2020, 07:16 PM
  2. advise on building a dashboard with my data
    By dougers1 in forum Excel General
    Replies: 6
    Last Post: 12-09-2018, 06:53 PM
  3. Trouble building a dynamic Dashboard
    By Joao Aleluia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2017, 07:37 PM
  4. [SOLVED] Advice on building a dashboard
    By ClareLou in forum Excel General
    Replies: 1
    Last Post: 02-08-2016, 11:45 AM
  5. Freelancers for Dashboard building
    By Katherine82 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-13-2015, 02:13 PM
  6. Replies: 2
    Last Post: 10-08-2012, 12: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