20 December 2024

How PowerPoint sabotages your poster (and how to fix it)

PowerPoint is the software most commonly used to make conference posters, by a long way. Here’s a few ways that PowerPoint works against you when you are creating a conference poster.

Size limits

PowerPoint slide size dialog box showing length and width as 56 inches.

PowerPoint will not make a page bigger than 56 inches along either edge. 

I have usually used a large format printer than is restricted to 42 inches along one side (usually poster height). But I have used many poster boards that are substantially more than 56 inches wide. Some poster boards are 96 inches wide. Which means a PowerPoint poster only uses 58% of the available space. I want to use all the space available to me!

Unfortunately, this cannot be fixed within PowerPoint. But there is a workaround.

Figure out the aspect ratio of your available space. Let’s say it’s 72 inches wide by 48 inches high (6 feet by 4 feet, a 2:3 aspect ratio). Divide 56 inches (PowerPoint’s max) by the longest edge (72 inches) to find the scale: 77.78%. Multiple 48 inches by 0.7778 to get the height in PowerPoint, 37.33 inches. 

(You could also use one of many resizing calculators on the web to do this math.)

In PowerPoint, create your custom size: 56 inches by 37.33 inches.

Export your final poster as a PDF. Then, when you print the PDF, you should have the option to select “Custom scale” to enlarge your poster to the final size you want.

Screenshot of PDF printing menu, highlighting the "Custom scale" option.

Using the example above, 72 divided by 56 equals 128.57%.

PowerPoint resizes text and changes line spacing without telling you

Several PowerPoint templates have space for text with an option, “Shrink text on overflow” turned on. If you change text within that text box, PowerPoint will shrink text and / or change the line spacing to make the text fit in the box you drew. 

In some cases, the line spacing will come down to less than single spacing. Most accessibility guidelines strongly recommend more than single spacing, so coming down to a line space of 0.9 or 0.8 is just horrible for readability.

In a couple of templates, changes in one text box may automatically carry over to all the other boxes. So if one box is badly typeset, the other one will be, too.

When you put text into a box, sometimes a small little icon appears in the lower left side that will provide you with text fitting options.

Screenshot of PowerPoint showing the location of an icon (two vertical arrows surrounding two horizonal lines) in the lower left hand corner of a selected text box.

PowerPoint’s rescaling means that you can have a hodgepodge of inconsistent sizes and spacing scattered over your poster. On a series of slides, this might not be so bad, because the audience only ever sees one slide at a time. But when all your pieces are text are visible at the same time, it becomes noticeable.

If you draw a text box on a blank slide, the default option is “Resize shape to fix text.” Not helpful if you have an exact space on your poster that you need to fill, like a single column.

Here’s where the autofit options are if you don’t see that pop-up icon.

Screenshot of PowerPoint showing the location of the text box setting for text autofit in the right hand sidebar.

You can turn off these autofit options, but there does not appear to be any way to make any one of them the default. You have to do it for each text box individually. This can be tedious, since a conference poster usually has many individual text boxes.

Automatic borders around text boxes

I mentioned this in a previous post, but it’s worth revisiting. Alignment is one of the basic elements of graphic design. PowerPoint makes it difficult to align text with edges of almost any other graphic element.

Two paragraphs of text under a header box. Left: Text box with PowerPoint's default margins does not align with box above it. Right: Text with margins set to zero does align with box above it.

This can be fixed by setting margins to zero.

Screenshot of PowerPoint showing the location of the text box setting for margins in the right hand sidebar.

 Again, I’m not sure that there is a way to set zero as a default.

No filtering for fonts

PowerPoint lists all fonts alphabetically. It doesn’t allow you to select, say, the serif fonts or bold fonts or script fonts or variable fonts. When I am making a poster, I often want to use a sans serif for the main text, but I don’t want to use Arial or Helvetica or Calibri or Aptos again. So you spend more time scrolling through font options than if you could just select a checkbox for “Show sans serif fonts.”

There are font manager apps that can help with this. There is a list of font management apps on Wikipedia, and a quick search for font manager might reveal some more options.

Are these solutions complicated? Yes, but I’m not the one who decided to make a poster in PowerPoint. Don’t get me wrong: I love PowerPoint and use it as a quick graphics editor all the time, but you have got to know it’s limitations.

05 December 2024

Waffle charts are an underused alternative to pie charts

I was looking at a poster with a pie chart recently. Like this:

Pie chart with heading bars above and below it. The heading bars are wider than the pie chart.

There are a lot of criticisms of pie charts, but this was not a terrible example. But I was struck by how awkward that circle looked in a rectangular space.

Pie chart with heading bars above and below it. The heading bars are wider than the pie chart. Empty space around the pie chart is highlighted in red.

Again, this was not a particularly bad example. But if the vertical space is smaller...

Small pie chart with heading bars above and below it. The heading bars are much wider than the pie chart.

The unused space problem gets larger and more noticeable.

Small pie chart with heading bars above and below it. The heading bars are much wider than the pie chart. Empty space around the pie chart is highlighted in red.

Let’s changed our cooked goods metaphor. Instead of pie, let’s try a waffle.

A series of 100 squares. 32 squares are coloured orange. 68 squares are coloured blue. Legend shows the orange aquares as Category 1, blue squares as Category 2.

Waffle charts are also sometimes called “unit charts.” Like a pie chart, they show part to whole relationships. Unlike pie charts, you tend not to end up with tiny slivers, and there is far less temptation to try rotating it or adding 3-D perspectives.

And you can reconfigure the shape to different proportions. A percentage can be shown three ways and have no straggling units. This provides you with more options to fit your graph to a space.

Three sets of 100 small squares. One has squares in 10 rows by 10 columns, one in 5 rows by 20 columns, and on in 4 rows by 25 columns.

All of these could be vertically oriented. That is, 25 rows of 4 columns instead of 4 rows of 25 columns shown above.

And if you are okay with rows or columns having a slightly different number, you have even more options.

So now your space might be filled more like this:

Waffle chart with header bars above and below it. The chart and header bars are exactly the same width.

There isn’t a button in PowerPoint to make a waffle chart, but a series of squares is very easy to draw in PowerPoint! For that matter, it should be trivial to do in any graphics package. Once you have done it once, you can keep one as a template that you can use repeatedly.

Can you make a waffle chart in Excel? Yes, with qualifications. Chapter 10 of John Schwabish’s book Data Visualization in Excel contains a step by step description of how to turn an Excel spreadsheet into a waffle chat. Turning a spreadsheet into a graphic that can be pasted into a large format conference poster might be a little tricky.

Reference

Schwabish J. 2023. Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks. CRC Press. https://doi.org/10.1201/9781003321552