+ Reply to Thread
Results 1 to 4 of 4

Interactive Excel 2007 dashboard

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2007
    Posts
    2

    Interactive Excel 2007 dashboard

    Hello,

    I am trying to set up a dashboard that is driven by dropdown lists. The attached spreadsheet shows the set up that I want to use. I would like the data to be driven by cell C3 on the "dashboard" tab. I would like the drop down list to follow the hierarchy listed in the text box on "Sheet1" - cells A1 - B6. Basically,the flow of the data should be Area, Region, Territory. Is there anyway to do this? I would also like to hide the zeros on the charts.

    Thanks in advanced for the help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Interactive Excel 2007 dashboard

    Im not sure what you mean by the FLOW of data should be Area, Region, Territory. I only see Area on the dashboard.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    08-22-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Interactive Excel 2007 dashboard

    I want the data validation lists to show. The first selection would be area, then region, followed by a list of territories. I want the territories to be filtered based on the region selection.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Interactive Excel 2007 dashboard

    To show where? I dont see them on the dashboard.

    Also I will split out the data validation into clear lists instead of how you have yours laid out, just to keep the logic as simple as possible.

    For example:
    http://exceliseasy.wordpress.com/201...-in-5-minutes/

+ 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. Interactive Excel 2007 Charts
    By Rachel716 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-11-2010, 03:34 PM
  2. "Dynamic Interactive Error Graph / Chart "in excel 2007
    By Aniruddha in forum Excel General
    Replies: 7
    Last Post: 08-24-2010, 08:09 PM
  3. [SOLVED] Excel 2007 BI Dashboard
    By Michael in forum Excel General
    Replies: 0
    Last Post: 06-23-2006, 04:45 PM
  4. iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB
    By kathy in kansas in forum Excel General
    Replies: 0
    Last Post: 01-24-2005, 04:06 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