Charting Web based data

N

nbs

With the data of say a stock price always changing, how
can you chart it on a line graph to show historical plots?
 
J

Jon Peltier

You can either find a site that posts historical data (often downloadable as a text
or worksheet file), or write a macro that gets the price and puts it next in a column.

Another approach is Stephen Bullen's trick that remembers the last X values. I don't
know how it would work for daily values; I think it's for incoming data that changes
rather frequently. But if you want to try, his site is at http://bmsltd.ie.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Data points in chart incorrect 0
Excel - Stock Chart questions 3
Chart Question 5
Plotting Graph with dynamic table 3
Non Linear Scatter plot, need to find y value 3
Creating a Chart on form from selected data in query. 0
adding trendline to plots from multiple series 1

Top