How do I make Stock Market like graphs?
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.
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#...
- kevin cLv 610 years agoFavourite 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.