Need a better charting solution

[masfkb2424]

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

 

[Hui]

Masfkb2424


You can do most of what you require by simply using data tables, filters, Form Tools or Named Formulas


Can you post a sample of your data and some details of what you want out of it?

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[masfkb2424]

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 automatically and interpret them.


In the sample above, I would like to be able to automatically insert those arrows into the graph indicating buy/sell points under certain conditions (IE: orange price line crossing over the average blue line). But that's not all. As you see in the chart, Excel only shows data labels in 1 yr increments. I need to be able to zoom in/out to smaller/larger time periods to see the day to day changes and I'd like to be able to pull the data values at specific points easily. I'd like to be able to easily identify where the lines are crossing at and easily find a specific value (price) at a specific date visually from the chart. Any thoughts?