Charting Help - Stock Prices

[Ligerdub]

Hi there,

I have a presentation next week as part of an interview for a research position. I’d appreciate some advice or help in this area if any of you would oblige me.

I am presenting on a company in the gaming sector, of which there are about 6-7 key competitors within the markets the firm operates in.



I’m looking to analyse stock performance of the relevant competitors over the past 10 years or so. I have all the stock prices of the firms from this period on an excel sheet.

Many of these firms launched their IPO’s only in the last 3-4 years, and all of them have been launched at scattered intervals within this period, so therefore there are different levels of historical prices I can display in the presentation.

With that in mind, what would be the best method for me to chart the performance of the stocks and also how to display this in a Powerpoint document? (My Excel skills are good, my powerpoint skills are not).

I'm looking for a line chart, and to illustrate this over the full 11 year period. I have daily stock prices over this period but I wish the headings at the bottom to reflect the changing years, but yet retaining the data points to show the moving trends. Is this possible?

Many thanks in advance.