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.
More below>>
Line Chart Trend

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 prominent

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 shall show you a beautiful excel chart example using this lollipop approach.

About Aeternus Consulting

Related Link: Aeternus Consulting Excel Training Courses Singapore

Aeternus Consulting offers an excellent workshop Storytelling with Data Visualization using Beautiful Excel Charts. This workshop is aimed at students visualizing thesis data, managers and analysts needing to communicate in a data-driven way and leaders informing their board to drive actions.

Related Link: Making Charts Beautiful with Microsoft Excel

excel courses in singapore
Advanced Excel Training Courses Classes Singapore: making beautiful charts

One Response

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *