Congratulations. You’ve gotten the data you need and placed it into a well-organized report. Your job is done, right?
As any chef will tell you, it’s all about presentation. When creating any “composition,” whether it be a gourmet meal or a business document, providing the basics isn’t enough. The output must look appetizing, as well.
Let’s begin by looking at how to use text to make a beautiful report.
This is not the full white paper. To access the entire white paper download it here.
Every piece of text is displayed in a font, the complete assortment of type of a particular style and size. Fonts reflect the mood and tone of your document.
Fonts can be classified into two main categories: serif and sans serif.
In general, serif fonts make words easier to read (readability) and sans serif fonts make individual letters easier to discern (legibility).
The Big Myth: Serifs Affect Readability on Computer Screens
So what font should you choose?
Choosing a font for readability or legibility is no longer the most important concern. Instead, you should choose a font consistent with the document’s contents. This includes looking at:
Did you know there are commonly accepted ratios for spacing of text elements?
Here are guidelines for:
We read by scanning, so use visual clues to help your readers quickly grasp the content of a report (see what we just did there?).
Separate out key sections with subheads, such as the four main ones (Fonts, Text Blocks, Spacing and Visual Aids) you see in this chapter.
If you need to put text in one area, use visual clues such as:
1. Numbered Lists
“Beautiful” probably isn’t the first word that comes to mind when you think about tables in a report. They’re great for displaying data, but they aren’t in the same class as images or other more exciting visual elements.
But don’t overlook them. Beautiful tables enhance the look of that key document you’ve worked hard to create.
Before you read any further, you have a key decision to make: whether to use a table or a chart to display the information.
If it’s important that the report reader see individual data points, go with a table. If not, you’ll likely want a chart.
Okay, that was a trick subhead. There are no “optimal” dimensions.
As much as we’d love to give you a formula for calculating the height and width of each cell, column and/or row, there is none. It all depends upon the data you’re including in the table. Generally the cell with the most content will determine the height and width of the adjacent cells.
Should your data be aligned to the left in a cell? The right? The center? The top? The bottom?
In general, left-justified text is the most natural for the reader. Center-justified text should be used sparingly, perhaps for elements you want to stand out from the rest, such as column headers and subheads.
One major exception to this rule is when the data is currency or other numbers. You’ll likely want to right justify content so decimal points or base digits line up vertically in each cell, making it easy to scan and compare data.
Also, don’t forget to consider how text is aligned vertically within a cell. Vertically, center-justified text typically is the easiest to read. The major exception here is when cells in one row contain significantly different amounts of information. In this case, top-justified text tends to be the most readable.
Line after line of black and white data in a table can wear down the reader, so show a little mercy by adding a few visual elements.
One common technique is to add background color to your chart. Choose two complementary colors, light enough so they don’t interfere with the text readability, and alternate colors for each row.
You can also use color to help best represent the data. For instance, if a chart contains numbers, you can display negative numbers in red.
Cell borders are another way to add visual interest. This is another area where there are no hard and fast rules, so experiment with the size of borders both horizontally and vertically.
Also, don’t be afraid of using subheads within a table. If a table contains a large amount of data that you can sort easily into logical groups, use subheads to allow readers to quickly jump from group to group.
A word of caution when it comes to visual interest. You don’t want the enhancements to interfere with the purpose of the table: displaying information so that it’s easy for the reader to grasp.
This means avoid any funky shadows, shapes, textures, etc. that detract from the look of the table. The visual elements should make the table easier to read, not more difficult.
Lastly, be sure to give some consideration to the data when determining how to organize it in a table. There are almost as many ways to order data as there are tables. This may not add to the aesthetic beauty of the document, but it can make the report significantly more readable. And readable = beautiful.
Is the data showing change over time? If so, your readers are most likely interested in seeing the most recent data first, so order your table thus.
Will a reader want to search for a particular entry? Then consider organizing the table alphabetically or by date.
Does that table contain data showing various quantities for comparison purposes? If so, you may want to sort the columns in ascending or descending order.
Charts can be some of the most beautiful elements of a report, especially when compared to plain black and white text or tables that are jam-packed with data.
Even if your strength is data and not report design, you can create informative, beautiful charts that wow your audience.
Step away from the keyboard and ask yourself two important questions.
ONE: Am I conveying individual data points or am I trying to show an overall trend instead?
As we discussed in the previous chapter, if it’s important that the report reader see the individual data points, go with a table. If not, you’ll likely want a chart.
TWO: What is the purpose of my chart?
Is it to enable the report viewer to identify one key trend? Compare a variety of information points? Allow for many layers of data or just a single one? Once you’ve figured out the chart’s purpose, you’re ready to dig into designing beautiful charts.
There are standard conventions for placing elements on a chart. For example:
When you don’t follow these conventions, bad things happen.
With a smaller chart, the person viewing the document can pick up key information and see the chart in context with other report elements around it.
A good rule of thumb is to make the chart as large as it needs to be in order for the text to be legible and not much larger.
You’re probably using some sort of reporting software to generate your charts, which means you have some cool visual effects you can apply with a button push. And you probably have.
Remember that visual effects should enhance your numbers, not detract from them.
A chart, just like a paragraph, should focus on one main idea. If that idea can be conveyed in one sentence, great. If not, use visual cues to highlight key information. (See what we just did there?)
There are millions of colors out there, which means either:
Fortunately, there are several principles to help guide your color choices. Here are three key ones:
By now, you may be asking yourself where you should place these awesome charts in your reports. So let’s move on to document layout.
The right report layout does more than make the output beautiful; it also makes the data and information contained within much easier to grasp.
But for a data reporting expert such as yourself, the thought of trying to lay out a good-looking document can be — let’s face it – distasteful. You’re no graphic designer, so the theory goes, so your reports are destined to be limited to a basic layout aesthetic.
Not so. Release your inner designer with the help of the following tips.
Yes, you need margins. They help focus the reader on the document’s content and make for clean, more readable reports.
There are some accepted guidelines, and you will find them as close as the word processing program on your desktop.
For standard reports – printed on an 8.5 by 11” paper or viewed onscreen – in many cases the output will look great with Microsoft Word’s default values of 1” margins for top, bottom, left and right.
We prefer this to Microsoft Excel’s default values of 1” for top and bottom and 0.75” for left and right, because multiple elements on a page can make a document look too busy; a wider margin helps make the content it contains easier to view.
Three notable exceptions to these guidelines:
One of the biggest mistakes we see in report layout is when individual elements break in awkward places, such as when one row of a table is placed on the next page, when a paragraph of text has a hyphen on nearly every line, or when a caption is on a different page from the image it describes.
Your template software likely has some built-in tools, so take advantage of them to eliminate these problems.
You can set these tools to apply globally across your document, but that won’t guarantee you the best report layout. Be sure to tweak the output afterward.
NOTE: The names above are the names of the tools in Microsoft Office; your template-design software may give different names to these tools.
Remember earlier when we said you don’t have to be a graphic designer to create beautiful layouts?
That’s true, but alignment and space among elements is one area where many of us struggle when laying out reports. Graphic designers have extensive training and experience in learning what looks best on a page, and you won’t be an expert after simply reading this blog post.
But take heart; you can fool just about anyone by employing a couple techniques.
Technique #1: Use white space to increase comprehension.
Technique #2: Deliberately align elements to increase page balance.
The bad news: Despite all your hard work, few people will actually read your document.
The good news: They will skim it instead.
Skimming lets readers jump to the parts that interest them AND it helps them get an understanding of the overall report before they decide which portions to go back and scrutinize.
Some tools you can use:
1. Numbered Lists
Numbers Instead of Words: 10
When laying out a document, include the elements that need to be included and don’t include the elements that don’t need to be included.
Here’s one layout technique that, when done right, your report recipient may not even be aware you’ve used.
Conditional visibility is when items in a document display only under certain conditions. These can be user-driven, such as when a user chooses to drill down to see more detail, or content-driven, when certain content displays only under certain conditions.
Lastly, if your template-design tool allows you to create some type of master slide or master template, be sure to take advantage of it when possible. You can set some of the layout properties once (such as margins and footers) and apply them to the entire document, giving it a cohesive, polished look.
There’s another way to add polish to a document. And this leads us to our next chapter, on images.
Ahh, images: the quickest and easiest way to add beauty to a report.
We’re not talking about charts or tables (although those also add visual appeal). We’re talking about logos, screen shots, photos and the like. They’re often colorful, usually informative, and always wise to consider.
If you (or your marketing team) already have images at your disposal, great. You probably don’t have to look far to find appropriate company logos, product photos or screen shots, employee and office life photos, and images of events relevant to the document’s content.
You can also find and easily download images from the Internet, but a couple words of caution:
When it comes to images in reports, the most important decision you’ll make is WHERE to store them.
Embedded Document Images
One option is to embed the images into the document. A copy of the image is stored in the document, so it is always available. The bad news is that it’s always available – even when you don’t want it to be.
Images Stored in a Database
Another option is to store them in your database. This limits the size of the report definition, allows you to change an image once and have the change replicated across all reports, and lets you keep records together.
And if you do store images in a database, you may decide to store them as BLOBs, or Binary Large Objects. (NOTE: This video shows how to use Windward to insert BLOBs stored in a database into your report.)
Images Stored in a File System
File systems are great for storing images because you can easily back them up, update and manipulate the images, and move them to a bigger hard drive if you need more disk space.
And remember, if your images are stored anywhere other than in the template, be careful how you reference them. You’ll need to give as much of a complete path to the image as necessary.
Obviously, images don’t do much good in a report if they’re blurry or much too small, so let’s talk for a second about resolution. Here are a couple general guidelines:
When working with a dynamic reporting solution, positioning becomes crucial. You don’t want to end up with images pushed off the page or in another funky spot.
So at first glance, “pixel-perfect,” absolute positioning, where you place an image at a specific point on the report, sounds great.
But as your report expands and you get a waterfall effect, images in the body of the document can end up in places you don’t expect – or want.
That’s why we recommend you use relative positioning for most images. Here you use some part of the image (top, bottom, left or right) to align the image with a specific element or point on a page.
Before we move on to discuss colors, we leave you with a couple tips:
Tip #1: Use non-traditional images. Basic shapes, stylized text, etc. are also images. Keep in mind that images don’t have to be big and colorful to add beauty to your document.
Tip #2: Follow your brand guide. If your company has a brand guide, it likely has a section on using colors that “match” your brand. A simple change to an image — such as editing the color of an icon in the report — can tie the entire report together beautifully.
There’s no rule that says your business report or document has to be boring in order to be professional. Using color is a fairly simple and quick technique that will give your reports the brilliance they deserve.
First, keep in mind that you don’t need to go overboard. Just a touch of color here or there can add needed “oomph” to your output.
Obvious places for color include table rows and chart data. You can make a document more impressive with background colors in headers and footers. And inserting a company logo is another great way to insert a splash that isn’t overwhelming.
When using colors in a report, think about how to best represent the data through commonly associated colors.
NOTE: Windward customers can find many monochromatic options for charts and tables right within Microsoft Office.
If your report will be printed instead of read onscreen, remember that color can get expensive. You may want to cut down on that cost by using fewer colors in your document. One recommendation is to use colors that work well in various shades, such as darker and lighter blue, to give you more flexibility in design.
Lastly, one piece of advice: Don’t rely solely on color to convey information.
No matter how clear and consistent your document colors are, some readers are bound to ignore or misinterpret them. About 8-10% of the U.S. male population has some form of color blindness, so these readers may not be able to see the colors. Older readers tend to struggle with pale blue. Even those with “perfect” eyesight may be viewing your report as a black and white photocopy.
So our final recommendation is to use text and shapes to give context to any color information.
Text, tables, charts, layout, images, color – it seems like there’s a lot you need to take into account when creating a stylish report. We have just one final item to add to the list: navigation.
Navigation is the final touch that can turn your informative document into an informative and beautiful one.
We mentioned this concept in our earlier chapter on text, but it’s so important that it’s worth mentioning again:
We read by scanning, so use visual clues to help your readers quickly grasp the layout content of a report.
This means separating out key sections with subheads or section titles, such as the four main ones (Subheads, Tables of Contents, Page Numbers and Appendices) you see in this chapter. You allow readers to quickly get a sense of the entire report and to easily navigate to the data or sections that most interest them.
You can also use other “signposts” throughout your report, such as bold text, italics, • bullets and the like to make key information stand out.
Tables of contents are for books and not business reports, right?
Not so fast. We’re big fans of tables of contents when used in appropriate cases, such as when the report is on the longer side or the reader might want to skim to see what it contains.
A table of contents is especially useful when the report is viewed online and the reader can click on each listing to jump directly to the content.
Page numbers resemble tables of contents in that it’s easy to overlook including them when designing your document, but in some situations they can greatly improve that report.
You’ve worked hard to collect meaningful data, but sometimes the best place for your data isn’t actually in the report; it’s after the report.
Appendices are also great places for supporting information that is too large for a footnote and for information that is outside the scope of the report but still useful.
We hope you’ve found these tips useful. As you put them to use, remember to let your template creation software do as much of the work for you as possible.
If you find that your current reporting software makes for a clunky design experience, we invite you to see how easy it is to design reports in Windward.
At Windward Studios we believe that reporting and document generation should be simple—not overly complex, tedious and technical. Your reports deserve to look as impressive as the information they contain.
Why can’t designing documents linked to your data sources be as easy as creating a Word document, Excel spreadsheet or PowerPoint deck?
It can. Windward creates software applications that simplify how businesses design and generate professional reports and documents. Windward provides a unique experience using Microsoft Office to format and edit report templates, and the sophisticated engine pulls data from multiple sources and merges that data into those documents. It’s a hassle-free experience that can actually make generating reports fun.
This is not the full white paper. To access the entire white paper download it here.