# Graphing data for investors

I need to analyze data (portion of the retirement investment portfolio) and graph the not so obvious info (such as total value) in a bar, pie, and line graph.

I need to do this in excel and come up with formulas, name for the graphs, Y' and X's.

What information should I be looking for as an investor (that's meaningful and not obvious)?

Which info is suitable with which graph?

Data is as follows:

Stock # Shares 9/30/96 10/31/96 11/30/96 12/31/96 1/31/97 2/28/97

CHV 65 62.63 65.75 67.00 65.00 63.38 64.50

GE 38 91.00 96.75 104.00 98.88 103.50 102.88

GM 50 48.00 53.63 57.63 55.75 59.00 57.88

IP 41 42.50 42.63 42.50 40.50 40.88 41.63

MRK 30 70.38 73.88 83.00 79.63 90.63 92.13

MMM 45 69.75 76.38 83.75 83.00 82.25 92.00

#### Solution Preview

...ferent depending on where your data is. The point is this "structure" of formula would work.) The $ before the B1, B2,etc means to keep the column fixed when you copy this formula to another - which is easier than typing the formula in again and again.

I find it useful to use the "Format Cell" feature in Excel so that dollars have $ in front of them and percentages are written as 00.0% and so on. This makes the graphing easier.

So, a line graph could be used for anything that changes in time - like the value a of a particular stock. You could either plot the value of 1 share (the price of the stock), the value of the shares the investors own, or something like the value of 100 shares if you ...