Three Key Principles of Visual Design in Excel

by Matthew Kuo on May 10, 2013

in Excel, Visual Design

To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the
 

Visual Design is a concept that many people don’t think about when using Excel.  However, given how much Excel’s visual display capabilities have improved over the years, the concept is becoming more and more important.  There are a number of great books on Visual Design and they all have very similar themes.

The following post is intended to summarize these themes with three major principles.  These are simply three things you should keep in mind whenever creating an Excel output.  Below each principle, I’ve included some examples of how the principle can be tactically utilized.  Please note that, while Visual Design is primarily relevant for charts and graphs, it can also be applied to most other Excel outputs as well.

Remove Non-Essential Components

In his book, the , Edward Tufte coined the phrase chartjunk, which represents anything in a chart that is not required to understand the components of your data.  The term chartjunk and the definition clearly imply that anything falling under this classification should be removed.  By removing the unimportant elements of your outputs, you allow the important aspects of your data to better stand out.  People vary with how they interpret what’s important and what’s not, but by keeping this principle in mind while you work, you’ll significantly improve the Visual Design of your outputs.

Tactical Uses:

  • Use soft gray lines in place of dark black lines
  • Remove legends and titles when they are redundant
  • Remove any excessive formatting
    • Remove 3D effects
    • Remove borders
    • Remove background pictures

Emphasize Important Data

Every output you create gives you a chance to tell a story.  If you’re in a situation where you absolutely need to get a message across to your audience, don’t leave that responsibility to the end user.  Make it as easy as possible for your audience to interpret and understand your point.  Highlighting the important aspects of your output guides your audience towards understanding the purpose of your work.  Additionally, if you use conditional formatting, the emphasis can also bring attention to areas of concern.

Tactical Uses:

Design with a User Focus

Few people design their outputs with a focused attention towards the person they’re handing it off to.  We often make the assumption that, “if I can understand it, so will my audience.”  While this sometimes works out, it’s still important to put yourself in the end user’s shoes and imagine looking at your outputs for the first time.  What additional context does this person need?  How will he or she read and interpret this data?  What would be the first question this person asks?  By asking yourself these questions and taking into consideration the audience’s perspective, you’ll be able to better address their needs and thus create a more powerful output.  While there is some conflict between this last principle and the first one mentioned, finding a balance between the two is what Visual Design is all about.

Tactical Uses:

  • Include documentation
  • Include a source citation
  • Include a units measure when appropriate
  • Use the appropriate chart to display data
    • Don’t use pie charts to show composition, use bar charts instead
    • Use stacked bar charts to show composition over time
    • Use line charts for trends
  • If black and white printing is likely to be used, adjust the colors accordingly

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post:


Related pages


column chartsvlookup between two sheetsvlookup example dataexcel count cellsformulas of excel sheetexcel compare multiple columnssimple excel graphnewest version of excelnested if function excel 2007how to delete duplicate records from tablereplace in excel formulaexcel vlookup formulas with examplesmultiple if formula in excelexcel sum columnsshortcut excel keyslookup value in table exceladobe acrobat convert to exceldelete duplicate entries in excelozgridmultiple if excel formulawhat is hlookup in excel 2007vba vlookup functionvlookup two conditionsrandom number list generator excelhistogram graph in excelexcel paste value shortcutexample of vlookup formula in excellookup on excelduplicate records in exceluw software discountexcel auto multiplyhow to generate random numbers in excel 2010how to eliminate rows in excelhow to use iserror with vlookupv lookup in excelhistogram bins excelrandomizer for namesremove duplicates excel 2013isna excel 2010combining if statements in exceltick on wingdingsvlookup excel 2003 exampleisna excel formulaquick keys for excelfind duplicates excelexcel eliminate duplicatesexcel tax templatetax excel templateexcel value lookupwhere is a check mark in wordexcell if statementsexcel identify duplicates in a columnexcel hlookup examplehow to use hlookup formula in excelcheapest microsoft office home and student 2013sheet formula excelhow do you check for duplicates in excelhow to do vlookup in excel 2010 step by stepvlookup learninghow to write formulas in excelexcel match lookupdownloading microsoft excelexcel sheet convert to pdf fileusing vlookup functionword tick mark symbolquestions to ask at mba interviewexcel ref errorvba excel function return valueremoving duplicate data in excelharvard mba syllabushlookup in excel 2010 with example
\n