ExcelBanter - Two charttype on chart

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Two charttype on chart (https://www.excelbanter.com/charts-charting-excel/22291-two-charttype-chart.html)

shah firdaous via OfficeKB.com

Two charttype on chart

Hi, I have export the data to excel from Vb, then add the graph in excel
and set my secondary axis as..
..SeriesCollection(4).AxisGroup = xlSecondary
then how we set this group only as chatrtype as xlLine
and the primary axis values by Column charttype

--
Message posted via http://www.officekb.com

Andy Pope

Hi,

Try this,

..SeriesCollection(4).AxisGroup = xlSecondary
..SeriesCollection(4).ChartType = xlLine

Cheers
Andy

shah firdaous via OfficeKB.com wrote:
Hi, I have export the data to excel from Vb, then add the graph in excel
and set my secondary axis as..
.SeriesCollection(4).AxisGroup = xlSecondary
then how we set this group only as chatrtype as xlLine
and the primary axis values by Column charttype

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 11:25 PM.