Gfrktyl

I have a line graph with the performance of two employees. 
How do I get Excel to automatically show only the last five weeks’ numbers without me having to select the data manually and without the "total" column showing up on my graph. 
Here’s a screenshot of my data:

Any help is appreciated.

Create a dummy region
that automatically shows the last five weeks’ performance (and only that). 
Let’s suppose your raw data are in Columns A and B. 
Pick a 2×6 range that you aren’t using.* 
It could be on another sheet, or it could be way out, e.g., AA1:AB6. 
I’ll assume that you’ve chosen G1:H6. 
Copy your column headers to G1 and H1. 
Enter

=INDEX(A:A, COUNTA(A:A)+ROW()-6)

into G2. 
Drag/fill down to G6 (i.e., for five weeks)
and right to H2:H6 (for two employees). 
G2:H6 will now display the last five weeks’ data from A:B.

Quick explanation:

• 
  COUNTA(A:A) counts the number of non-blank cells in Column A. 
  If the most recent cell, and all the cells above it, are non-blank,
  and all the cells below it are blank,
  then this will give you the row number of the most recent data. 
  If you have blank cells above, or non-blank cells below,
  you will need adjust this or devise something different.


• 
  ROW() is the number of the row that it is in. 
  I.e., in G2 and H2, it is 2; in G6 and H6, it is 6.


• 
  COUNTA(A:A)+ROW()-6 is (COUNTA(A:A)-5+1) + (ROW()-2).
  
  
  
  
  • 
    (COUNTA(A:A)-5+1) is the row number of the fifth-to-last week’s data. 
    For example, if you have 100 rows of data,
    then the last five are 96, 97, 98, 99 and 100, and 100−5+1 is 96.
  
  
  • 
    (ROW()-2) is the zero-based row number within the G2:H6 range. 
    I.e., in G2 and H2, it is 0; in G6 and H6, it is 4.
  
  
  • So, adding them, we get the numbers of the fifth-to-last row,
    the fourth-to-last row, the third-to-last row, the second-to-last row,
    and the last row (e.g., 96, 97, 98, 99 and 100).
  
  
  
  


• 
  INDEX(A:A, <row_number>) gets the value
  from the indicated row in Column A. 
  When you drag the formula from Column G to Column H,
  this automatically changes
  to INDEX(B:B, <row_number>).

So G1:H6 shows the last five weeks’ performance (including column headers). 
Base your chart on that range:

If you add data to Columns A and B, the chart will automatically adapt:

______________

* You could probably use a 2×5 range by not including the column headers.