+ Reply to Thread
Results 1 to 5 of 5

Creating a Dashboard in excel

  1. #1
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 2007
    Posts
    240

    Unhappy Creating a Dashboard in excel

    Hello everyone my name is sheldon and I am a Queuemanager where I work. I am responsible for reporting. I started building a dashboard in excel but i need a vlookup formula to pull info from different sheets for a specific person. Anybody knows any?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,000

    Re: Creating a Dashboard in excel

    can we see a sample of the sheet , with dummy data
    does vlookup not work - you could try index/match

  3. #3
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 2007
    Posts
    240

    Re: Creating a Dashboard in excel

    Sorry for taking so long to answer, my job is quite demanding lol, I've attatched the worksheet.
    Attached Files Attached Files

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,000

    Re: Creating a Dashboard in excel

    you could use a pivot table for the chart which would have a dropdown

    However, the way you have the data structured , it may require a lot of formulas to actually pull all this together
    Is the data formatted this way for a reason
    if you added a Date column and titles for the W1,2,3,4 - then you would be able to use pivot tables and charts to produce the summary and dashboard

    I'm sure someone else would have dealt with this type of data and may have a solution, I cant think of an easy way

  5. #5
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 2007
    Posts
    240

    Re: Creating a Dashboard in excel

    Thanks Much I can definitey do that. I will try.

+ 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