Hi Hui
Here is some sample data
https://hotfile.com/dl/201573298/6c9da11/Sample.xls.html
I'm basically just trying to find a way to have the same kind of user-interactive interface that google finance/yahoo finance provide, but within excel so that I can write vba to create the charts...
I'm trying to create line charts in excel for visual analyses of stocks using date and price data, ie:
1/1/2013 78.63
1/2/2013 79.54
The problem is that the data I am graphing is daily data, and a single year's worth of data creates over 250 date and price data points. This makes it very...