In 2015 I gave a presentation to my fellow Redvespa business analysts called 86 tips for better charts.
The goal of the presentation was to provide simple tips that could applied in their day-to-day work, and to stimulate discussion about what works better than standard Excel defaults.
These tips have been collated into a online book, which is available on Redvespa's website, and now contains 100 tips:
The intended audience is those people, and not just business analysts, who occasionally have to present charts and graphs, and don't have the time to delve head first into the wonderful word of data visualisation.
Of course, I hope that by reading through the tips, you will be encouraged to read more, especially from those authors I refer to in the introduction, such as Alberto Cairo, Stephen Few, Isabel Meirelles and more.
These tips are my opinion. As tip 100 says:
There are no strict rules in data visualisation. No tip for data visualisation should be followed if it results in a lower quality visualisation. I hope that, by thinking about these tips in the context of your own work, you will think about what you are trying to achieve with your visualisations, and how chart choice, design, colour, text and layout can help to achieve those goals. By practising and learning where certain design choices work well,you can understand where it makes sense to deviate from these tips.