How do I re-arrange this data to get this specific Line Chart?

[zicitron]

Hi all,

I'm using Excel 2010. My charting skills are not so good so I'm turning to this forum for help!

Here is how my data looks:

Now I need to create a line chart with Quarters on the x-axis and Values on the y-axis. The lines inside the Chart will be those showing the room nights and sales revenue of each hotel ((so, 4 lines in all). The way my data is presented right now does not allow me to do this. I've tried several variations but they don't seem to work.

Any help on this issue please?

 

[etaf]

if you delete period name in A2 - so its not selected as one of the qtr
and then select A1 to E6
insert
line graph

works for me OK and show lines with Sales X , Sales Y , Room X, Room Y as legend with 4 lines
qtrs on X
and Amount on Y

 

[zicitron]

Thanks etaf! I guess it was the "Period" in that cell which was causing the havoc! I've done a few research in the meantime and I've found that I can have the second set of data (room nights) display on a secondary axis in the same chart. Thanks again for your help!

 

[etaf]

your welcome, glad its all sorted