could you please solve to me the 4th question please ?

I need the steps for doing it on Excel

1. Itaining type werording to the Number of frainung sold with a posvibility 10 solect them according to the year (USe at sficel) 4 Marks 2. Training type accordine fo Sale values (Sales). The proposed chart must offer the possibality of ielection by vear fuse the gieviout alicer) 4 Marka 3. The number of training vold by wearia Marka 4. A bar char showing vum of ales by year. This chart and the just previous one can be selected togother by training Name. (use a shicet) 4 Marko File Home Insert Page Layout Formulas Data Review View Help Power Privot Tell me what you want to do fro ABCCD 1. Itaining type werording to the Number of frainung sold with a posvibility 10 solect them according to the year (USe at sficel) 4 Marks 2. Training type accordine fo Sale values (Sales). The proposed chart must offer the possibality of ielection by vear fuse the gieviout alicer) 4 Marka 3. The number of training vold by wearia Marka 4. A bar char showing vum of ales by year. This chart and the just previous one can be selected togother by training Name. (use a shicet) 4 Marko File Home Insert Page Layout Formulas Data Review View Help Power Privot Tell me what you want to do fro ABCCD