Excel 2007 : Chart able to differentiate primary and secondary axis

Hi all,

I am trying to create an excel that is able to graph dynamically across multiple worksheet data into one chart. I have 3 Sheets(Graph, PrimaryData, SecondaryData).

The sheets("Graph"), will create a Line Chart which takes data from the sheet("PrimaryData") and plot into the primary axis.

Likewise the data from the sheet("SecondaryData") goes into the secondary axis.

Thanks in advance and hear from you soon!