Project Description

Add to CartView Cart

Excel chart: dot plot comparing two years

Dotplot comparing two periods

Dotplots are nice alternatives to bar charts: they are much lighter and in many cases detecting a pattern is easier because the chart is much less cluttered.

A frequent issue with dot plots is that, when comparing two periods, growth and decline are not obvious. The reader must pay attention and check when markers switch position along the axis.

This version minimizes this issue by color-coding the gap and displaying the marker for the most recent period only. Making sure colors point to the right values requires a little trick, though.

(30-day, no questions asked, full money-back guarantee. Pay securely with your Paypal account. When buying from this site you are accepting the Disclaimer section in the About page.)