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.

• Format the Close Markers to Size 8.

\begin{tabular}{|r|r|r|r|r|r|r|r|r|} \hline & A & B & C & D & E & F \\ \hline 1 & Date & Open & High & Low & Close & Volume \\ \hline 2 & 3-Mar-16 & 64.31 & 66.46 & 63.27 & 65.28 & 9682956 \\ \hline 3 & 4-Mar-16 & 63.71 & 65.79 & 62.28 & 64.72 & 9803808 \\ \hline 4 & 5-Mar-16 & 63.55 & 66.12 & 62.69 & 64.84 & 10071432 \\ \hline 5 & 6-Mar-16 & 63.70 & 66.82 & 62.95 & 65.25 & 10293156 \\ \hline 6 & 7-Mar-16 & 64.74 & 67.44 & 64.02 & 66.64 & 11927736 \\ \hline 7 & 10-Mar-16 & 65.24 & 67.43 & 64.17 & 66.18 & 7417440 \\ \hline 8 & 11-Mar-16 & 65.18 & 67.98 & 64.53 & 66.98 & 9094464 \\ \hline 9 & 12-Mar-16 & 65.45 & 67.74 & 64.72 & 66.84 & 6988356 \\ \hline 10 & 13-Mar-16 & 65.38 & 67.55 & 64.39 & 66.49 & 9150192 \\ \hline 11 & 14-Mar-16 & 64.20 & 67.12 & 62.87 & 65.00 & 15654384 \\ \hline 12 & 17-Mar-16 & 64.47 & 67.63 & 63.09 & 65.28 & 11475540 \\ \hline 13 & 18-Mar-16 & 63.99 & 66.66 & 62.91 & 65.32 & 9095544 \\ \hline 14 & 19-Mar-16 & 63.92 & 66.43 & 63.20 & 65.75 & 7454808 \\ \hline 15 & 20-Mar-16 & 64.14 & 66.11 & 62.71 & 64.59 & 11216448 \\ \hline 16 & 21-Mar-16 & 63.37 & 65.34 & 60.76 & 63.15 & 15904404 \\ \hline 17 & 24-Mar-16 & 62.07 & 64.58 & 61.46 & 63.87 & 7735176 \\ \hline 18 & 25-Mar-16 & 62.72 & 64.77 & 60.96 & 62.90 & 14200164 \\ \hline 19 & 26-Mar-16 & 61.72 & 64.65 & 61.02 & 63.96 & 10876248 \\ \hline 20 & 27-Mar-16 & 62.76 & 65.34 & 61.80 & 64.37 & 9377640 \\ \hline 21 & 28-Mar-16 & 63.60 & 66.01 & 62.47 & 65.10 & 9558648 \\ \hline 22 & 31-Mar-16 & 63.38 & 66.01 & 62.70 & 65.02 & 7847496 \\ \hline 23 & 1-Apr-16 & 63.92 & 66.52 & 62.87 & 64.72 & 8817876 \\ \hline 24 & 2-Apr-16 & 62.50 & 65.88 & 61.90 & 65.00 & 7064280 \\ \hline 25 & 3-Apr-16 & 63.65 & 66.01 & 62.46 & 65.28 & 10870740 \\ \hline 26 & 4-Apr-16 & 63.63 & 66.48 & 62.84 & 65.69 & 6908760 \\ \hline 27 & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|r|r|r|r|} \hline & A & B & C & D & E & F \\ \hline 1 & Date & Open & High & Low & Close & Volume \\ \hline 2 & 3-Mar-16 & 64.31 & 66.46 & 63.27 & 65.28 & 9682956 \\ \hline 3 & 4-Mar-16 & 63.71 & 65.79 & 62.28 & 64.72 & 9803808 \\ \hline 4 & 5-Mar-16 & 63.55 & 66.12 & 62.69 & 64.84 & 10071432 \\ \hline 5 & 6-Mar-16 & 63.70 & 66.82 & 62.95 & 65.25 & 10293156 \\ \hline 6 & 7-Mar-16 & 64.74 & 67.44 & 64.02 & 66.64 & 11927736 \\ \hline 7 & 10-Mar-16 & 65.24 & 67.43 & 64.17 & 66.18 & 7417440 \\ \hline 8 & 11-Mar-16 & 65.18 & 67.98 & 64.53 & 66.98 & 9094464 \\ \hline 9 & 12-Mar-16 & 65.45 & 67.74 & 64.72 & 66.84 & 6988356 \\ \hline 10 & 13-Mar-16 & 65.38 & 67.55 & 64.39 & 66.49 & 9150192 \\ \hline 11 & 14-Mar-16 & 64.20 & 67.12 & 62.87 & 65.00 & 15654384 \\ \hline 12 & 17-Mar-16 & 64.47 & 67.63 & 63.09 & 65.28 & 11475540 \\ \hline 13 & 18-Mar-16 & 63.99 & 66.66 & 62.91 & 65.32 & 9095544 \\ \hline 14 & 19-Mar-16 & 63.92 & 66.43 & 63.20 & 65.75 & 7454808 \\ \hline 15 & 20-Mar-16 & 64.14 & 66.11 & 62.71 & 64.59 & 11216448 \\ \hline 16 & 21-Mar-16 & 63.37 & 65.34 & 60.76 & 63.15 & 15904404 \\ \hline 17 & 24-Mar-16 & 62.07 & 64.58 & 61.46 & 63.87 & 7735176 \\ \hline 18 & 25-Mar-16 & 62.72 & 64.77 & 60.96 & 62.90 & 14200164 \\ \hline 19 & 26-Mar-16 & 61.72 & 64.65 & 61.02 & 63.96 & 10876248 \\ \hline 20 & 27-Mar-16 & 62.76 & 65.34 & 61.80 & 64.37 & 9377640 \\ \hline 21 & 28-Mar-16 & 63.60 & 66.01 & 62.47 & 65.10 & 9558648 \\ \hline 22 & 31-Mar-16 & 63.38 & 66.01 & 62.70 & 65.02 & 7847496 \\ \hline 23 & 1-Apr-16 & 63.92 & 66.52 & 62.87 & 64.72 & 8817876 \\ \hline 24 & 2-Apr-16 & 62.50 & 65.88 & 61.90 & 65.00 & 7064280 \\ \hline 25 & 3-Apr-16 & 63.65 & 66.01 & 62.46 & 65.28 & 10870740 \\ \hline 26 & 4-Apr-16 & 63.63 & 66.48 & 62.84 & 65.69 & 6908760 \\ \hline 27 & & & & & & \\ \hline \end{tabular}