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 treatment of dates. I have seen this sort of designs in many magazines and wanted an afternoon challenge to do this in Excel.

A neat horizontal axis by using only a single month label for each month
It uses alternating blocks in the plot area to indicate passing months.

The exercise wasn’t very challenging after all. I managed to capture the nice features of the original chart. To create the clean horizontal date axis, I used a column with the formula “=IF(DAY(A2)=1,A2,”")”. This formula only displays a date if it is the 1st day of the month. The alternating month blocks was created with an area chart using a column of formulas like this: “=IF(MOD(MONTH(A2),2),3000,NA())”. This creates a pulse train that varies between 0 and 3000 across months.

To learn more about how to create beautiful charts like these in Excel, check out this workshop: Beautiful Excel Charts

Related posts:

1. 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...
2. Bullet chart in Excel A bullet chart is a relatively new kind of chart invented by Stephen Few.  I was pleasantly surprised to see one in a recent copy...
3. Do it in Excel: Ring charts are better Pie charts Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented...