+ Reply to Thread
Results 1 to 10 of 10

Dashboard workbook

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Dashboard workbook

    Hello, some one asked me to upload this workbook, so here it is.

    All respect goes out to https://www.excelforum.com/ and its users for providing the formulas needed for the dashboard.
    Special thanks to Jonmo1 , FDibbins, sandy666, AlKey, shg and Andy Pope .


    Name:  7.0 Classie template.png
Views: 5685
Size:  143.4 KB
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Re: Dashboard workbook

    This was designed for a display dashboard. If one needs to print it, one will need to take a picture of the dashboard and use a paint software like https://www.getpaint.net and invert the colors. So, basically what that gonna do is make it from black and white to white and black.

    In order to look like this (picture down below)
    step 1 take a picture of the display (PrtScn button)
    step 2 past it in ( ctrl + v)
    step 3 invert the colors
    step 4 adjust the white level
    step 5 squeeze the image size

    Name:  IMG_1717 (1).jpg
Views: 5102
Size:  1.52 MB
    Last edited by sovietchild; 04-13-2017 at 01:13 PM.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,033

    Re: Dashboard workbook

    Thank you for the upload. That is a really cool dashboard!
    Dave

  4. #4
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    94

    Re: Dashboard workbook

    sovietchild, Many thanks for uploading your work that supports your dashboard. Will be studying it to learn some new techniques.

  5. #5
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Re: Dashboard workbook

    In order to look like this (picture down below)
    step 1 take a picture of the display (PrtScn button)
    step 2 past it in ( ctrl + v)
    step 3 invert the colors
    step 4 adjust the white levels
    step 5 squeeze the image size

    Name:  IMG_1717 (1).jpg
Views: 5192
Size:  1.52 MB
    Last edited by sovietchild; 04-13-2017 at 01:12 PM.

  6. #6
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Re: Dashboard workbook

    Here is a simple dashboard if anyone wants it.

    Name:  Untitled.png
Views: 5247
Size:  86.1 KB
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Re: Dashboard workbook

    Simple concept. (imitated from google images search through dashboards)

    Name:  CONSEPT.png
Views: 5225
Size:  36.2 KB
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Re: Dashboard workbook

    If anyone wants it.

    Name:  Cos.png
Views: 4103
Size:  179.2 KB
    Attached Files Attached Files
    Last edited by sovietchild; 07-10-2017 at 06:47 PM.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,080

    Re: Dashboard workbook

    Very nicely done!
    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

  10. #10
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    244

    Re: Dashboard workbook

    Here is a simple dashboard that could go well with how products are doing week to week or month to month.

    Attachment 534405
    Attached Images Attached Images  
    Attached Files Attached Files

+ 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. [SOLVED] Add a New Tab within a Workbook containing a Dashboard using CHOOSE and IF
    By slucille in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-22-2014, 06:43 PM
  2. [SOLVED] VBA to data Split from column values as new workbook save into folder with dashboard sheet
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-08-2014, 02:03 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