2 type of charts in one

[lezawang]

Hi
I have 2 data series and I want to draw different chart for each one. The first one is Column chart and the other one is Line chart.
I am using excel 2013. So I created the first one then went to chart tools tab -->design and added the second series. I made the second one as secondary axis. So far is good, when I changed the type of the second series to Line chart, the first one will change to as well? Why is that?

month	articles	vistors
jan	62	975
feb	86	865
mar	76	869
apr	74	507
may	72	856
jun	96	867

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[iliace]

I only have Excel 2016 available, but I believe this change was made beginning with Excel 2013.

When you select Change Chart Type, towards the bottom there should be an option for Combo Chart. There, you can select individually what Chart Type each series uses.

Post back if this does not solve your issue.