Two ways to build dynamic charts in Excel

Source: tr1.cbsistatic.com