How do I make Stock Market like graphs?

Question

I have been tracking sales data for over 5 years and would like to make my 5 year long graphs adjustable like the graphs on stock market pages. So visitiors to click on either 1 month - 6 Months - 1 year - 2 years and exc. and the charts would automatically adjust.

I've read the entire excel book and while I've learned a lot I still can't make those types of graphs. Where and how can I make Stock Market like graphs.

Update:

Here are my graphs http://www.coconutpointbonitaspringsrealestate.com...

I'd like them to be clickable like this - http://finance.yahoo.com/echarts?s=GM+Interactive#...

Answer 1

Favourite answer

you need to say what your data looks like - if it's like

COMPANY JAN FEB MAR ... DEC

...then you can go to

Insert --> Chart

Then select type "line" and the format of the line.

Click next and you go to the range - it'll look like this: =Sheet1!$A$1:$E$1

this is one row of data, from col. A to Col. E.

You'll obviously have much more data, so replace the "1" with however many rows you have.

Click Finish and you should have a nice little graph pop up.