+ Reply to Thread
Results 1 to 3 of 3

Dynamic dashboard cards

  1. #1
    Registered User
    Join Date
    08-28-2019
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    2

    Dynamic dashboard cards

    Good Afternoon,

    Thanks in advance for any advice I receive on this. I currently have a sales dashboard whereby I present sales team member results for the quarter and year to date on a TV using various pie charts etc. It works well for now however I have found that as new sales team members are on boarded the charts are becoming very busy and the current view won't be sustainable. I had envisaged perhaps having a card view for each sales team member with their photo perhaps showing with their specific results for the quarter and year to date. Each card would cycle every 4 seconds or so and dynamically update through each member and back to the beginning. I'm not sure if this is possible or not and I'm not sure how to approach it. If someone could point me in the right direction or offer some suggestion it would be really helpful.

    regards
    Andrew

  2. #2
    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,946

    Re: Dynamic dashboard cards

    If you need to have the cycling affect you mention, that would probably require VBA.

    However, perhaps take a look at how to explode each segment of your pie, to blow up/show each member?
    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

  3. #3
    Registered User
    Join Date
    08-28-2019
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Dynamic dashboard cards

    Thanks for the reply. I was playing with some VBA that will scroll down and focus on an area for a given time (chart, image etc) before moving on and loops back to the top, so I could use that however it just seems a little messy / clunky.
    Ideally it would just be like an active pane that cycles through different content but just not sure that it's possible. Thanks again

+ 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. Using a UserForm to Display Playing Cards - problem with overlapping cards
    By joebbb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2017, 04:49 PM
  2. Replies: 2
    Last Post: 09-17-2017, 10:34 AM
  3. [SOLVED] Dynamic Excel Chart Dashboard
    By samsfer in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-20-2017, 06:41 PM
  4. Need help with Dynamic dashboard
    By semkaran in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2016, 04:34 AM
  5. Dynamic Excel Dashboard as Web Page
    By SnugglesMcWal in forum Excel General
    Replies: 0
    Last Post: 02-10-2016, 11:58 PM
  6. Replies: 2
    Last Post: 12-10-2013, 02:58 PM
  7. Dashboard for dynamic list
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2009, 11:56 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