Graphs should allow you to roughly compare data within a set. Tip #4: Remove background linesĪs you can see below, there is a massive difference between the ‘before’ and ‘after’ Waterfall charts due to slight changes in design. Do this by minimizing white space in the blocks and between bars, and by making the bars wider. Click on Gap Width – you want less white space but enough to differentiate between blocksĪim to differentiate between a period and a series.The bars should be wider and the distance between the bars narrower. It is easier to understand and there is more space to display the chart itself.Įxcel uses thin bars with wide spacing by default, but the opposite actually works better as it makes it easier to visually compare data. In the ‘after’ chart, you can see that it becomes much clearer when data labels are displayed on the series itself, instead of using both axes. There are two different y-axes, one for the absolute amounts and the other for the percentage. In the ‘before’ chart below, we use a bar chart for absolute numbers such as net sales and a line to display percentages, for example gross margin. Always order your graph in descending or chronological order so it is simple, clear and easy to understand. Bar, pie, and line charts all convey your data differently, so choose the one that best suits the story you want to tell. Bonus tip: Format your financial charts, tables and graphs with a single click Tip #1: Always pick the right chart typeīefore you start tweaking design elements, you need to make sure that your data is displayed in the optimal format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |