Candles!!

How to add a comparison line in a quote chart in Excel?

I’m using an Excel (2003) Chart to track a portfolio’s performance. I’m using the candlesticks option. However, I want to draw a comparison line with the Dow Jones Industrial Average, and another line with the S&P500. How can I do this? Thanks for your help.
Manshu, Thanks for your answer. However, that just gives me a chart with 3 lines. What I want to do is draw 2 lines (the Dow and the S&P) on top a candlestick chart of my portfolio.

You need to fill in three adjacent columns with the closing values of your portfolio, S&P and DJ for the time period that you want to compare.

Next click on Chart wizard, select Line and Chart Type and select the three adjacent rows and click on Finish. This should give the comparison lines to you. You can right click on the chart itself to modify it to the way it suits you.

Turning Points using 30 Minute Candle Stick Chart Dow Jones

Essentials of Technical Analysis for Financial Markets (Essentials (John Wiley)) $39.95 Comprehensive, accessible guide to technical analysis and market trading strategiesEssentials of Technical Analysis for Financial Markets is an all-encompassing handbook on navigating the financial markets successfully using technical analysis. Clearly written, easy-to-understand, and straightforward, this guide focuses on the key information needed by traders and investors to take on any financia…

Traders Guide to Technical Analysis In easily understood language, this book shows you how to use technical analysis to decide when to buy and sell stocks, evaluate a stock’s performance, and forecast probable long-term trends in the stock market. Written for the average investor, the book provides guidelines on how to apply the same tools of technical analysis that the experts use to interpret what’s happening on Wall Street. …