If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
charting two stocks as candlesticks in same graph
Hi,
I want to graph in one same candlestick chart two stocks over the same period. how do i do that? can i do it for two dif time periods as well? i.e. in same graph i want feb-jun of year 1 and feb-jun of year 3 of the same stock/index . |
#2
|
|||
|
|||
charting two stocks as candlesticks in same graph
One set of OHLC can go on the primary axis and the other on the secondary
axis. This is a bit tricky to produce. Make a candlestick with the first set of OHLC. Copy the range with the second set, including the dates, select the chart, and use Edit menu Paste Special to add the data as new series with the appropriate options. This messes up the candlestick, but we'll fix it. Select each of the second set of OHLC series, press F1 to format, and on the Axis tab, choose Secondary. All of these will now be regular line chart series. Double click one of the secondary axis series, and on the Options tab, choose the High-Low Lines and Up-Down Bars options. Then format each of these series on the Patterns tab to have no markers and no lines. The conversion of line chart to candlestick is described in this article: http://peltiertech.com/Excel/ChartsH...artTricks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "nathan11" wrote in message ps.com... Hi, I want to graph in one same candlestick chart two stocks over the same period. how do i do that? can i do it for two dif time periods as well? i.e. in same graph i want feb-jun of year 1 and feb-jun of year 3 of the same stock/index . |
Thread Tools | |
Display Modes | |
|
|