Excel bar chart - how to make axis as time scale - Super User

The most simple way to do it is with an Scatter (X-Y) chart but this is a line chart and won't display the bars you want. To do it with bars you need to create a pivot table with date in the row labels and sum of qty as the values. Note this will only wor

superuser.com