Creating Stacked Chart and Line Chart in one graph

[thetnaingsoe]

Hi guys...

Need help, please.

I was trying to create a single chart in which one set of data (premium) will show in stacked chart and another set of data (policy count) will show as a line chart. All of them will be in a single graph.

I have the data here in google drive. https://drive.google.com/open?id=1CzKIs8hSY0u3gP7R2z4yXPaK293Y_Ihn

Can anyone show me how it can be done, please?

Thanks for the help and appreciate it much.

 

[arunsjain]

Hi,

Right click on chart and go to Change Chart Type. Go to Combo option and choose line chart for count series. Turn on Secondary Axis.

Cheers!!!!