How do I merge two Excel Graphs into one?

[Helal]

Attached is a sample data and the two graphs. I would like to combine the two graphs in one based on region (urban and rural). Any help/advise is very much appreciated.

Helal

 

[Faseeh]

Hi Helal,

Simply combine all the six data series, use similar color for similar urban/rural series, but use different line styles for each pair. lets say red color for dis enrollment but solid line for urban and doted for rural.

 

[Helal]

Hi Faseeh,
Thank you. I did that. But I like of have a split graph..Urban on one side (right side) and rural on another(left side) Does it make sense?

 

[AIM]

@Helal

Please refer to the below link, this should help

http://www.contextures.com/excelpanelchart.html

Regards!!