+ Reply to Thread
Results 1 to 16 of 16

How to make your dashboard look natural

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

    How to make your dashboard look natural

    Here is a fake dashboard I made. As you can see both pictures almost look alike, don't they?

    Here is a tip how to make your dashboard look natural.

    1. Google.com search for any image you'd like. Could be anything from butterflies, flowers to nature.
    2. Use https://www.colorcodepicker.com/ scroll down to "Dominant Color" and upload your picture.
    3. Use the codes that they provide for you

    for example:

    R 58
    G 60
    B 61

    Those are the codes that excel can read. You can use them to make your dashboard look natural.
    Attached Images Attached Images    
    Attached Files Attached Files
    Last edited by sovietchild; 07-15-2018 at 04:08 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: How to make your dashboard look natural

    There is no attachment ...

    EDIT: There is now!

    The tip is useful - thanks. However, the example is a dashboard that is, in my opinion, too dark for comfort with not quite enough contrast for easy legibility. It's important not to let form overtake function: the latter is more important ultimately than aesthetics.
    Last edited by AliGW; 07-15-2018 at 04:09 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to make your dashboard look natural

    Quote Originally Posted by AliGW View Post
    There is no attachment ...
    Fixed...........

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: How to make your dashboard look natural

    Yes, I know - I had already edited my post.

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

    Re: How to make your dashboard look natural

    @AliGW yes those colors are not the best choice but the point I was trying to make is someone can always use the colors of the nature.
    Attached Images Attached Images    
    Last edited by sovietchild; 07-15-2018 at 06:54 AM.

  6. #6
    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: How to make your dashboard look natural

    I kind of like that scheme, 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

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: How to make your dashboard look natural

    Yes, I know - second one appeals to me better. Good tutorial!

  8. #8
    Forum Contributor
    Join Date
    11-17-2018
    Location
    Los Angeles
    MS-Off Ver
    Office 2010
    Posts
    201

    Re: How to make your dashboard look natural

    Hello sovietchild,

    Can you provide the Excel file with your second color scheme please?

    Thank you.

  9. #9
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Re: How to make your dashboard look natural

    I can't find the file.
    Last edited by AliGW; 11-26-2018 at 12:51 AM. Reason: Unnecessary quotation removed.

  10. #10
    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: How to make your dashboard look natural

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: How to make your dashboard look natural

    I think Sovietchild has lost the workbook, which is rather a shame.

  12. #12
    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: How to make your dashboard look natural

    I can D/L the file in the 1st post, maybe try editing that 1 to suite?

  13. #13
    Spammer
    Join Date
    06-05-2019
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2

    Re: How to make your dashboard look natural

    thank you for you suggestions

  14. #14
    Registered User
    Join Date
    06-14-2019
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    1

    Re: How to make your dashboard look natural

    Hi there,
    i'm teaching myself via various online stuff to get&transofrm data and have begun dabling in building dashboards.

    Would it be possible to get under the hood of your dash?

    Or can you/anyone recommend me self-studie/teaching stuff for creating great looking dashboards?

    i know how to get measures into a single cell via cube function, i am training myself with charts as well and have also used trend mini charts alittle bit.
    But i still have ways to go.. for instance i'm looking at yours and find myself thinking how do you fill up a cell according to it's value? I don't imagine that your value bars are charts?

    so on and so forth

    i'm all on my own when it comes to datamodelling, visualising etc.. i have no coworkers to guide me or spar with

    Regards
    Michael

  15. #15
    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: How to make your dashboard look natural

    Quote Originally Posted by michdk View Post
    Hi there,
    i'm teaching myself via various online stuff to get&transofrm data and have begun dabling in building dashboards............


    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

  16. #16
    Registered User
    Join Date
    02-13-2020
    Location
    Belarus
    MS-Off Ver
    2016
    Posts
    1

    Re: How to make your dashboard look natural

    My God! Excellent colors. Thank you!

+ 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. How to make your dashboard look natural
    By sovietchild in forum Tips and Tutorials
    Replies: 1
    Last Post: 07-15-2018, 04:11 AM
  2. Sql tables to Excel - How to Make Live Dashboard
    By jcmckeon in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-03-2015, 01:00 PM
  3. VBA code to make an intracting dashboard using Hyperlink.
    By sarthak2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2014, 07:43 AM
  4. How to make dashboard scroll table
    By vietdieu in forum Excel General
    Replies: 1
    Last Post: 02-06-2012, 10:42 PM
  5. natural log problem
    By greenlee22 in forum Excel General
    Replies: 2
    Last Post: 04-07-2011, 08:56 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