Results 1 to 4 of 4

Format control to show data in charts

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    833

    Format control to show data in charts

    Hi guys,

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

    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.
    Attached Files Attached Files
    Last edited by rayted; 06-08-2018 at 05:02 AM.
    Thanks,

    R.



Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How can I show pivot table data split across two charts?
    By durna01 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2018, 05:47 PM
  2. Replies: 1
    Last Post: 03-08-2016, 08:47 PM
  3. Watefall charts - How to show negative on data labels
    By dluhut in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2014, 09:32 PM
  4. Dynamic Pivot Charts: show data from last 6 periods only
    By robertgroen92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2014, 10:58 AM
  5. Replies: 1
    Last Post: 10-21-2013, 02:29 PM
  6. Control charts and six sigma charts
    By Climaxgp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2010, 08:05 AM
  7. Charts - Line Chart, How to Show data Ranges?
    By chickencoop in forum Excel General
    Replies: 4
    Last Post: 01-06-2009, 08:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1