Error add the Line Chart

[sachar]

Dear All,

With reference to the attach screenshot (Error char), May I know what is the wrong with sample file DSR_jan’16 when, I added the series of worksheet “Room” “H” column in the in the Daily Sale Chart as a Line Chart.

Please help me how to add the “H” column in the Daily Sale chart as a Line Chart.

 

[Hui]

Please see attached file:

 

[sachar]

Mr. Hui,

Received with thanks, please tell me how can I do it?

 

[Hui]

Right click on the chart
Add a new series
Set it to the secondary axis
Then set the chart type for the new series to line

 

[sachar]

Dear Hui,

Thanks.