Format control to show data in charts

rayted

New Member
Joined
Nov 6, 2017
Messages
9
Hi guys,

I have 2 questions about a dashboard I am trying to create.

https://1drv.ms/x/s!Aqg7XrqBo8Apgkv1pYU4FXb9MlXr

Firstly, I have setup format controls but not sure how/what I need to do for it to populate the corresponding data on any charts I have created.

For example, using the Dashboard tab, if I select 'Q2' (this means Quarter 2), how do I get my charts to pull data for Q2? The last chart for example would consist of: interviewer performance (so this is the 'rating' visible in cell G52 - Dashboard tab or column R on the Interviewer Data tab) and the Quarter. So I want to see Interviewert performance in Q2 (if I select Q2). Hope this makes sense?

Sorry I may have a missing piece here - but I would still appreciate any help with the steps I neeed to take as per my original query.

I have realised I have not input data to show different quarters on the interviewer data tab.

Would this be a problem? If I have the same interviewer listed 4 times (1 row per quarter) with different data? Or does this seem like the easiest way to work with this data?

Thank you.

 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,118,174
Messages
5,570,684
Members
412,336
Latest member
Tiffany927
Top