SalmanGenProg
New Member
- Joined
- May 24, 2010
- Messages
- 19
Good morning!
I am using Excel 2007 and I want to chart stock price data (in the Open High Low Close or OHLC format) but want to add two additional data series to this graph: data points showing the prices where i bought the shares and another set showing where i sold the stock. Whenever i try to add these two additional data series to the OHLC graph, excel screws up the formatting completely.
i have tried the methodology of adding new data as scatter chart points (as described at: http://peltiertech.com/Excel/Charts/StockChartPlus.html) but it doesn't seem to work in my excel.
Please help...
Thank you very much in advance!
Salman
I am using Excel 2007 and I want to chart stock price data (in the Open High Low Close or OHLC format) but want to add two additional data series to this graph: data points showing the prices where i bought the shares and another set showing where i sold the stock. Whenever i try to add these two additional data series to the OHLC graph, excel screws up the formatting completely.
i have tried the methodology of adding new data as scatter chart points (as described at: http://peltiertech.com/Excel/Charts/StockChartPlus.html) but it doesn't seem to work in my excel.
Please help...
Thank you very much in advance!
Salman