View Single Post
  #1   Report Post  
masfkb2424 masfkb2424 is offline
Junior Member
 
Posts: 1
Exclamation Need a better charting solution

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 frustrating to identify specific values and dates just from highlighting the cursor over the chart.

I need a solution that will allow me to quickly create graphs from excel data (programmatically would be ideal) that I can easily read and navigate, and ideally, annotate by adding markers or lines or by highlighting certain data points. Does anyone know of an excel add-in perhaps or other solution that has those capabilities? Something with the capabilities of google finance charts below to easily grab a data point and to look at shorter/longer time frames, along with the ability to add annotations would be perfect. Does anything like this exist as an integration into excel?

http://www.google.com/finance?q=%5EDJI