Open your main database. Select Insert > Tables > PivotTable > From Table/Range. Your pivot table is ready for analysis. Head to Insert > Charts and add one of the relevant charts to your Excel sheet.
Please note, the data displayed for this chart reflects the title's midweek position only, peak positions on this chart also relate to midweek chart positions. Official Singles Chart Update data ...