M Milai New Member Apr 24, 2010 #1 does any one know how to add a line cahrt to the existing OHLC chart . It seems the template in excel doeset provide that capability.
does any one know how to add a line cahrt to the existing OHLC chart . It seems the template in excel doeset provide that capability.
Hui Excel Ninja Staff member Apr 24, 2010 #2 Milai I would suggest using a Box Chart to replicate the OHLC chart and then you can add other data series to your hearts content Box Charts were discussed about a week ago in another post http://chandoo.org/forums/topic/boxplots or have a look here for explanations on how to construct them http://peltiertech.com/Excel/Charts/BoxWhisker.html http://www.bloggpro.com/box-plot-for-excel-2007/
Milai I would suggest using a Box Chart to replicate the OHLC chart and then you can add other data series to your hearts content Box Charts were discussed about a week ago in another post http://chandoo.org/forums/topic/boxplots or have a look here for explanations on how to construct them http://peltiertech.com/Excel/Charts/BoxWhisker.html http://www.bloggpro.com/box-plot-for-excel-2007/