Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 5th 13, 02:25 AM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2013
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a solution CA Linda Excel Worksheet Functions 1 July 7th 09 05:31 PM
My solution Research freak Excel Discussion (Misc queries) 0 April 11th 07 04:30 PM
Solution for charting IF statements that return blank values [email protected] Charts and Charting in Excel 1 December 5th 06 01:20 PM
Need a solution AD108 Excel Programming 0 December 14th 05 10:43 PM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017