Yes. We can create two chart in one sheet.
Create 2 calculations as follows
If [region] = "Central" or [region] = "West" then [sales] end
If [region] = "East" or [region] = "North" then [sales] end
Drag this into row and select dual axis.One chart as bar and other as line.
Yes Sankar, this is what my requirement.
Thanks a lot.