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,078,520
Messages
5,340,922
Members
399,399
Latest member
SravanaSandhya

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top