combination of charts

[#1]

Hello ,

I wish to plot combination of charts into a single chart.

I've two different units Sales and Margins.

for Sales , i wish to show as Bar chart in manner.

for Margins , i wish to show in Line chart.but both are on the same chart.

for this, i mentioned two expressions for both Sales and Margins in Expression tab.for Sales,i checked Display type to Bar.

For Margins, i am unable to check the Line type in the same way.not allowing me to check.

Can anybody suggest me on which case it allows me to check.

Thank you.

Regards

Charitha.

[Nicole-Smith · Accepted solution]

Change the chart type to combo chart, then you can do what you want:

[#3]

i got this by choosing Combo chart before go to Expression chart.