I need help with a Customer Service KPI Dashboard

Nick24

New Member
Joined
Dec 1, 2014
Messages
9
Hi everyone,

I'm really struggling with how to show some information on excel.

I'm trying to create a very simple dashboard that shows a pie chart for incoming calls received by each customer service employee. And another for outgoing and then a total.
I would like a bar chart next to it that relates to the pie chart showing.
The problem is that I would like a drop down box that seletea which chart to show, e.g incoming, outgoing & total.

Ive managed to play with data validation and make a drop down box, butdonr know how to link this to the relevant pie chart and bar graph.

I've also learnt to use named ranges to name each coloum.

The information is currently in 5, rows. With the titles: executive, incoming calls, outgoing calls, total calls. Then the 7 employees data and a final total row.

I would appreciate any help as I'm trying to impress mangement and eventually create great dashboards. I'm a very fast learner.

Many thanks

Nick
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Use vlookup() with your data validation cell to reference the data from your table
 

Nick24

New Member
Joined
Dec 1, 2014
Messages
9
Hi Steve,

Thank for the reply,

Could you possibly elaborate a little, im only used to using vlookup() to get one value, e.g one of the customer service teams outgoing calls, not all of them for the chart to use,

Thanks
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
send me a pm with your email address, and I will send you a sample file
 

Nick24

New Member
Joined
Dec 1, 2014
Messages
9
Okay so i managed to get it working, But only if i split the data up on another tab so that it was specific to the executive. As i couldn't vlookup() both the name and type of call into one box. example for one below, the rest were listen below with a space in between.

Executivebob
Incoming Calls397
Outgoing Calls140
Total Calls537

<tbody>
</tbody>

etc

This way i could just do =VLOOKUP(C6,Sheet1!A12:B15,2,FALSE) next to each of their names and below the data validation cell, (C6 being the data validation cell and the Sheet1!A12:B15 being each specific table for the executives).

Is there anyway i could use the Data validation cell to bring up a named range or something so i don't have to split all the information into each persons stats?
 
Last edited:

Nick24

New Member
Joined
Dec 1, 2014
Messages
9
Okay ignore the above i just pasted the table horizontally and it worked fine, (above but all the name next to each other with below data) Is there any way to do this vertically?
 

Forum statistics

Threads
1,082,367
Messages
5,365,028
Members
400,819
Latest member
Gossow

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top