Click OK to close the Select Data Source dialog box. You will notice that the tasks are in reverse order. We can quickly rectify this by right-clicking them in the chart and selecting Format Axis.

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might ...