Lollipop approach to clarify Microsoft Excel line charts
Traditional Microsoft Excel line charts have a common problem. It is hard to visually associate the data points with the horizontal axis. The traditional axis line is no help at all.
The data points are not clearly associated with the horizontal axis labels
We can get around this problem by using data markers. Certainly an improvement, but we still need to mentally drop imaginary lines between the points and the labels.
Use data markers to make the data points more prominient
My solution is to add 100% negative error bars for each data point. This removes any ambiguity between the data points and the axis labels. I call this the “Lollipop Approach” for line charts! The error bars may add additional weight to the chart, but they serve a useful function.
Error bars from each data point associates the relevant axis labels clearly
In a later post, I will show you a beautiful excel chart example using this lollipop approach.
Related posts:
- BP Oil Spill shown in a Microsoft Excel Chart On 20 April 2010, a BP oil well exploded in the Gulf of Mexico, causing the largest offshore spill in U.S. history. This Microsoft Excel...
- Excel Line Charts with Elegant Dates I came across this stock chart in the Kuala Lumpur’s edition of the Business Times while I was in Malaysia. The chart has an elegant...
- Making Beautiful Excel Charts is Simple Have you ever told yourself that creating great looking Excel charts is hard? Well it’s not. You only need to understand the only reason we...
I like that a lot. It is only in recent times that I have seen and learnt about how useful error bars can be.
Thanks very much.
ASM
ps. Good looking blog. I will be adding to my list of regular visits.