ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   xlStockVOHLC chart with extra xlColumnClustered series (https://www.excelbanter.com/charts-charting-excel/256031-xlstockvohlc-chart-extra-xlcolumnclustered-series.html)

amir

xlStockVOHLC chart with extra xlColumnClustered series
 
hi all,
I have ActiveChart.ChartType = xlStockVOHLC
I'm trying to add to him additional bar:
ActiveChart.SeriesCollection(6).ChartType = xlColumnClustered
and getting error "Some Charts types cannot be combined with other chart
types".
this worked for me in Office2003.
Is it possible there is no backward computability?
How can I do it in Office2007?
10x




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com