Must-have Excel add-ins you can’t afford to ignore Since we're dealing with live data to create the dashboard ... pivot table and choose the type of chart you wish to create.