Chart Help: Line graph to only use certain rows if specified name appears in row and ignore rest of data, line graph to Update automatically with any

SJ7987

New Member
Joined
Feb 24, 2015
Messages
2
Hi everyone,

I have a spreadsheet in which I have created a line graph from containing 9 columns and a few hundred rows so far of data. Example below - (please note managers can have multiple scores on any one day and different managers can be audited on the same date)

Date; Area; Event; Employee; Manager; Sc1; Sc2; Sc3; Score %;
08/04; East; Heat ; Sam white; Jon Marr; 9; 3; 2; 78%
22/05; Nrth; Batch; Ben Palm; Nate Gun; 10; 0; 2; 44%
02/06; East; Clean; Jason Ro; Jon Marr; 7; 3; 4; 80%
02/06; Nrth; Trailer; Adam Vin; Tom Clark; 5; 6; 8; 62%
19/07; East; Meet; Liam Sims; Jon Marr; 9; 3; 7; 73%
07/09; West; Heat ; Ty Major; Tom Clark; 9; 7; 1; 34%

The spread sheet details the performance of 20 different managers based around a variety of dates where they have been audited.

I have created a line graph for the total performance scores % in relation to the dates managers have been audited in the company. I will be updating this spreadsheet regularly and require that when new data is input into the spreadsheet for the line graph to update automatically without having to manually select the chart area each time new data is entered.

I am also needing to create a number of line graphs based on each individual managers score using the same spread sheet as previously mentioned so managers and head office can see how each manager performed individually rather than as a whole company. I would need this line chart to only grab the data that corresponds to the manager and disregard all other data whilst updating the chart. automatically as new data is entered.

My individual managers line graph needs to represent the DATE and SCORE %. It can only recognise the data rows of 1 manager eg. Jon Marr and disregard all other rows in the spreadsheet of other managers scores and data. I will be creating an individual graph for each manager.

I hope someone is able to give me some instructions, formulas, or whatever I need to make it work that would be great!
 

SJ7987

New Member
Joined
Feb 24, 2015
Messages
2
Hello and welcome to The Board.
You need to create the chart as a "dynamic" chart. Have a look at the following:
You searched for dynamic chart - Peltier Tech Blog
Note that hiding rows and/or using a formula to create an "error" value (e.g. #N/A) in a cell, is a way to get a chart to ignore data.

Hi Derek,

Thank you for your response, I am still having Issues as I am needing to display numerous charts at once so they can be compared against one another as individual charts rather than a comparrison in the same chart.

I am struggeling creating my chart as I am trying to create a chart that looks at an individual Manager's ongoing Scores and what Dates they occured on whilst disregarding any other managers data (for this chart as they will appear on a seperate chart within the spreadsheet).

My X Value (Date) and Y Values (Score) I am not sure how I can get the chart to recognise another Value of Manager so I can get it to disregard all the other managers scores. I have created

It works perfectly when I filter the data on excel, but it also changes every other chart in the spreadsheet to the filtering I have selected rather than just that specific chart.

Is there a formula I can use that when inputing the Series Values into the chart where I can create a rule that only picks up a rows data if data from a different column to X (Date) and Y (Score) has a specific Value e.g. Tom Clark (A specific Managers name).

Any further help would be great.
 

Forum statistics

Threads
1,082,305
Messages
5,364,401
Members
400,800
Latest member
germanpbv

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