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.

1 Answer

  • 10 years ago
    Favourite answer

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


    ...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.

Still have questions? Get answers by asking now.