How To and Tips


Less is more, more is more

Always ask yourself: “what can I remove from this chart”? Remove Excel defaults, remove grid lines, make the chart smaller, use soft colors, remove irrelevant labels, remove the legend (by directly labeling series), remove series that you don’t really need, remove frames, remove decimal places, remove visual fluff.
Then ask yourself: “what can I add to [...]

10 x 10 tips to improve your (Excel or not) charts: the scatter plot

This is the time for scatter plots in the 10 x 10 charting tips series:

A scatter plot is square by definition (I forget that sometimes…);
In some cases, it makes more sense to use a scatter plot than two column charts: for example, instead of having a column chart to display product market [...]

10 x 10 Tips to improve your (Excel or not) charts: column and bar charts

These are 10 basic tips for column and bar chart design:

A column chart is not a skyline: if you can’t see the individual patterns, consider removing some series or create several smaller charts;
If you are charting categorical data sort the columns; if there is more than one series, allow the user to sort the data [...]

10 x 10 tips to improve your (Excel or not) charts: Line charts

Following the 10 x 10 post series on tips for better charts, these are the 10 tips for line charts:

Don’t use line markers unless you really need them to identify b&w printed charts;
Don’t use a legend; directly label the series, instead;
If you can’t easily see the pattern of each series you may have too [...]

10 x 10 Tips to improve your (Excel) charts: pie charts

I know, I know, no one likes pie charts, but I can’t ignore them. A pie chart compares proportions but it is of limited use: either the data is too complex and a pie chart can’t handle it, or it is too simple and you should just use a table. So, the first [...]

10 x 10 Tips to improve your (Excel) charts: formatting

This is the second of 10 posts where I’m listing tips for better charts. Please take a look at the first post where the project is discussed. These are my chart formatting tips:

Use the right chart type for the data and the problem;
Apply sound design principles;
Use color strategically: mute axis and grid lines [...]

10 x 10 Tips to improve your (Excel) charts: general tips

This is the first in a series of 10 posts where I’ll suggest a (hopefully) coherent set of tips to improve our charts and, more important, to improve the way we make sense of the data. These are the planned posts:

General charting;
Formating;
Column/Bar charts;
Line charts;
Scatterplots (XY charts);
Pie charts;
Other chart formats;
Dynamic charts;
Dashboards;
Miscellaneous tips;
Bonus post: online resources.

These will [...]