The design and presentation of your charts and graphs should clearly and effectively communicate the message you need to get across. But many visualisations produced in business and elsewhere actually do the opposite. They make it more difficult for the reader to understand what is being shown. Why do we have this problem? Unfortunately, in […]
Creating a Dot Plot in Excel
In the early 1980’s Cleveland and McGill showed that we are better at interpreting the relationship between points on a line better than any other method of representing numerical information – including line length, as used in the ever-popular Bar Chart. The result of their work was a new chart type, the Dot Plot, which […]
Creating a Slope Graph in Excel
A Slope Graph has a lot in common with a Line Graph as it plots change between points. But, unlike a Line Graph, a Slope Graph plots the change between two points only. Increases and decreases between the two points can be seen easily. In fact, you can see how one category increases as others […]