How to add multiple line graphs?

[muna]

I've uploaded an Excel file that contains 4 big green boxes with questions.

Can anyone answer those questions?

 

[Hui]

Please note comments in the file

 

[muna]

Please note comments in the file

wow, many thanks!

I'll see if I can play around with the spreadsheet so I can learn a few things myself. Thanks for the notes, points taken!

If I experience any issues, I'll be sure to report back.

 

[muna]

Please note comments in the file

I said I would get back to you if needs be, I hope you don't mind.

Please see the file uploaded for further comments.

 

[Simayan]

Hi Muna,

Pls Refer to the attachment, for your queries

 

[muna]

Hi Muna,

Pls Refer to the attachment, for your queries

Thank you!

Much appreciated, I fully understand the notes.

1) Do you know if it is possible to put "absent" on the graph when there is no data to display

2) Do you know if it is possible when there is no data to be displayed to have the graph just miss out the dates i.e. 01/04/2015 to not be mentioned on the graph at all

3) Do you know if the graph can only show the full calendar month and nothing more. In other words have the graph show 30 days for April, 30 days for June, 31 days for July and so on.

4) Next to the graph is it possible to have a table of the actual results displaying

a) Calls Taken (figure)
b) Calls Missed (figure)
c) Overall Percentage of calls taken (%)
d) Overall Percentage of calls missed (%)

For All working days, Week 1, Week 2, Week 3 & Week 4

This means that if you struggle to read the graph, the statistics are right next to it.

 

[Simayan]

Hi,

PFA

 

[muna]

Hi,

PFA

Thanks

Any ideas on http://forum.chandoo.org/threads/how-do-i-create-a-referee-rota.24592/#post-147946

?

 

[Simayan]

read this

https://msdn.microsoft.com/en-us/library/office/gg508918.aspx