Downlisad and save the Excel $8$ Template.xlsx file as LastNameFirstNameExcel$8.$xlsx $($e$.$g$.$ BestMarkExcel$8.$xlsx$).$

As an analyst at the Jayhawk Investments financial company, you regularly monitor the performance of your clients' investments. You are preparing for a meeting with one of your investors to discuss how their stocks have performed over the last year and changes they should make to their portfolio. Your client has asked for information on four companies: Wal$-$Mart, Time Warner, AMD, and Intel.

$2.$ Create a chart for each company using the appropriate stock chart sub$-$type. Place the Wal$-$Mart chart on the Wal$-$Mart worksheet, the Time Warner chart on the Time Warner worksheet, etc. Make sure that the charts are easy to read $($i$.$e$.$ you should make them bigger!$).$ Use the following information to help you create the four charts:

Wal$-$Mart Chart

Use the High$-$Low$-$Close Sub$-$Type.

Chart Title $=$ Wal$-$Mart $($in bold$).$

Display the Legend on the Right.

Vertical Axis Minimum $=58$; Vertical Axis Maximum $=70.$