Column titles
Column titles
Rows or columns?
go in columns Big options (1, 2, or 3) usually go in columns Ranking different values usually is better vertically, it is easier to compare a column of numbers than have your eyes move across a row of columns. Personally, I do what looks best, without applying any specific rules. If one dimension has Rows or columns?
Text columns in PowerPoint
ago, and invented the text column. If you right click a text box in PowerPoint and select format Text columns in PowerPoint columns and the white space in between them to get the desired effect. As an example, below are the opening paragraphs of Alice in Wonderland. text, you see that one of the options you can choose is columns (Mac). Play around with the number of
Years in columns, which way?
Years in columns, which way? looking at time series data It makes tables match line or column graphs that are in the presentation
Combining stacked and clustered columns
column, you zero out the values of the first one. Sounds a bit complicated, but the visual example below In PowerPoint, there is no standard option to create a combined stacked and clustered column chart Combining stacked and clustered columns the format data series menu) to create the white breaks in between the columns Adjust the data . Here is a work around, taking the stacked column chart as the basis. Set the gap width to zero (in points manually. The first stacked column goes in regularly. The second stacked column (that should have
Smart row / column insertion
workflow (even) faster. Now, when you insert rows and or columns, it copies its design and structure background colors. 1) Our starting point 2) Open the grid editor 3) Add a row and a column 4) The result Image via WikiPedia Smart row / column insertion
The lone column
my time at McKinsey, I have seen many examples of "lone columns", column charts with just one number in them, or tables full of tiny column charts with hardly any variations among them. These charts The lone column
Bar versus column charts
Bar versus column charts mimics that of a line chart, you don’t need much space for the column labels (usually years, or bottom list, and you can make more space for labels that usually describe things In this case: bars are better than columns. Photo by Sophie on Unsplash months) Columns for breakdowns. More horizontal space for complicated labels, and a stacked column is a — Benedict Evans (@benedictevans) November 6, 2019 My guideline: Columns to show trends over time. The shape
The lone column
A column chart with just one lone column is not a column chart. Column chart need to compare things, show a trend over time. The lone column
Redundant table column headings
I try to get rid of them, most of the time it is obvious that a column contains a company name, a Redundant table column headings
Column chart with totals
to placing text labels manually, and especially useful when the data in the column charts is changing frequently. Column chart with totals Here is a little trick to create automatic totals on top of column charts. This is an alternative
Bar versus column chart
labels, which have a 1-to-1 relationship to the columns Image source Bar versus column chart
Clear legends to save the audience time
Clear legends in column charts.png big text to the right of a column chart (the last year is usually the most relevant for the audience clutter. Click the image to see the column chart in the template store, subscribers can download it
Wide screen <> wide columns
Wide screen <> wide columns , switch to a multi-column grid, or simple leave space unused left and right of your text (something that many web pages do), see the examples below. newspapers use columns to limit the number of words on one line. Think about this when designing slides
Combining column and line charts
Combining column and line charts chart only works when a column has a reasonable size though. I am not aware of any presentation software Below is an interesting chart from McKinsey. It combines a column chart with a line chart. The
Domino visualisation in a column chart
Domino visualisation in a column chart This visualisation is brilliant. I have never thought about using columns in a column chart as
P&L as a column chart
P&L as a column chart When you want to show a P&L with very few lines, consider using a column chart instead of the more column chart works well, it shows a number of trends in 1 slide: sales growth, profit growth, and how
Columns versus rows and other table design issues
Columns versus rows and other table design issues lots of rows then lots of columns. Long labels go in rows Year on year trend: years go in columns rows and columns so that check marks / similar table content is grouped together Group together table on a slide. Next to swapping rows and columns consider: Shortening column labels Re-sorting When making a table, what to put in columns, what to put in rows? There is no absolute rule here multiple rows, or multiple columns if their content is the same as the neighbour Cut text as much as you
Data chart labels: inside or outside?
labels), and it is easer to put a background image as most labels (in tall columns) have enough this enables you to make the column graph taller as a whole (no need to budget extra space for the , the label is put on top, if possible with a font color that matches the column The advantage is that : When the column is tall enough, the label is put inside with a contrasting white font color If not
Tutorial (3/3)
slide. The implication of this is that you need to add/remove bars and columns to a data chart by a minimum of 3 columns, vertical waterfall charts have a minimum of 3 rows (start, one delta, end waterfall chart is set by the number of columns the chart box covers Horizontal waterfall charts have Adding columns and bars to data charts Data charts are linked to the slide grid to make it easy for by the number of rows the chart box covers The number of columns in a column chart, stack chart, or
See more