Closed Thread
Results 1 to 12 of 12

Interactive Dashboard and data filtering

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Interactive Dashboard and data filtering

    I am trying to create an interactive dashboard but being an unexperienced person with excel functionality I ham facing some challenges and wondering if one of you can help me out.
    I am attaching a sample data file that contains two tabs (data and dashboard). By looking at dashboard tab you will know what I am trying to build. Based on the drop down values I would like to populate the data on the dashboard tab.

    let me know if its not clear or if you have any questions.

    Really appreciate your help!

    thanks
    Attached Files Attached Files
    Last edited by cloudno9; 11-04-2013 at 04:07 PM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: dashboarding....

    please elaborate on your orange DV

    not sure exactly what you want in there

    the yellow one wasnt too complex on its own, see attached
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: dashboarding....

    Hi and welcome to the forum

    Administrative Note:
    • We would love to help you with your query, but first, before we can proceed…
    • Please see Forum Rule #1 about proper thread title
    • Please PM me when complete (Also, include a link to your thread - copy from the adress bar) and this post will be removed which will reset the replies to zero…

      To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    11-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: dashboarding....

    Based on the value user select from the Orange drop down box the value under the capabilities (red section) changes. for example if i selected Total App it will show the count of "id" under each capability (like you are showing for yellow DV). If i select total cost it should change the count of "id" to total cost associated with the capability.

    Once i populated the value based on the orange DV than based on the yellow box it should apply the filter by CIO column. Default value for the yellow DV is all.

    I hope this helps!

    Really appreciate your help

    thanks
    Last edited by cloudno9; 11-04-2013 at 05:14 PM.

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Interactive Dashboard and data filtering

    try this version

    i didn't know how exactly you wanted to view criticality it was kind of weird but you should be able to get the gist of it

    on the side all the work is done which you can hide

    on the dash board is just references

    hopefully this is enough to get you on the right track as i am sure you want to expand it later down the line
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Interactive Dashboard and data filtering

    Thanks much...
    One question...does this means I have to build the data first like you did on the dashboard tab and then use that to show the values? if I want to add more capabilities to it?

    Thx.

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Interactive Dashboard and data filtering

    its easier way of doing it
    otherwise you will have in single cell a very long and convoluted formula which would be hard to maintain

    the "building" does not have to be on the same sheet if you dont want it

  8. #8
    Registered User
    Join Date
    11-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Interactive Dashboard and data filtering

    Thanks...I have created a separate sheet to calculate the value.

    I have encountered one thing and thought maybe you can help me out with this.

    I am attaching the sheet, look at the row # 106 & 115 under data tab. Now when I count total apps for online it should not add these two lines in the total. How could I do this? Also this will impact the Total Cost too?

    How could I do this by comparing all three levels of capability L1, L2, & L3?


    Really appreciate your help!

    Thanks
    Attached Files Attached Files
    Last edited by cloudno9; 11-06-2013 at 01:49 PM.

  9. #9
    Registered User
    Join Date
    11-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Interactive Dashboard and data filtering

    Never mind, I figured it out. I added another criteria with in SUMIFS and changed SUMIF to SUMIFS.

    Really really appreciated your help!

    Regards,

  10. #10
    Registered User
    Join Date
    11-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Interactive Dashboard and data filtering

    Hi,

    Sorry to bug you again...I have another scenario that i have put it under dashboard tab. See if you can help me with that?

    Regards,
    Attached Files Attached Files

  11. #11
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Interactive Dashboard and data filtering

    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  12. #12
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Interactive Dashboard and data filtering

    cloudno9


    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    Thread closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. DASHBOARDING chart type
    By jcaranibar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2005, 06:20 PM
  2. [SOLVED] DASHBOARDING chart type
    By jcaranibar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2005, 06:17 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