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