HELP!I need to show daily 4 KPIs in 1 excel sheet

[Ahmed Goreshabatly]

I need to make a daily report of 4 sets of charts.
I am thinking about using Scroll Bar to change the date, so that you can select the date of the month.
However, I also want to use Combo Button to be able to select the type of charts.
Can you do this?

Thank you for your help!

 

[Asheesh]

Hi Ahmed,

can you share the sample data please...

 

[Ahmed Goreshabatly]

Thank you for your reply.
Please find the attached.

4 sets of KPIs are:

1. No of Complaints
2. No. of Assessment
3. No. of New Sales
4. No of Exchange

I get data and need to visualize it on a daily basis.
I want to be able to select charts by Date.

I looked at Mr Chandoo's Interactive Chart Tutorial but
not sure what is the best option to approach this.

I would be extremely grateful if you could help me.

Thank you!

 

[Asheesh]

Ahmed, I suggest you to go for 4 charts where in each chart represents a metric for all the sales reps for a date selelcted using drop down...

That way you will be able to compare the individual performance on a daily basis for each metric...

 

[Ahmed Goreshabatly]

Asheesh, thanks for your reply. I will try that.

 

[Asheesh]

Happy to help...