Two charttype on chart

  • Thread starter shah firdaous via OfficeKB.com
  • Start date
S

shah firdaous via OfficeKB.com

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
 
A

Andy Pope

Hi,

Try this,

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

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reverse axis not working as before... 0
putting graph as Line 2
Secondary axis with VBA 1
Changing ChartTypes will not change the color of the Series 2
How do I set the Maximum Property for this Chart in code 1
column charts with set set of data 0
Primary/Secondary Axis series count 1
category Axis 14

Top