graph only part of a data table

[Jack235]

I have created a data log in excel that shows all of the changes that have been made in my workbook. How would i create a line graph that just tracks the changes in some of the cells, that also automatically updates when one a change is added to my log? Thanks.

 

[Jack235]

To make this a little clearer. The table looks like the below (apologies the table is a little out of line, the second number goes in column 2) and I'd like the graph to show separate trend lines for data changes in risk register c2, risk register c3 etc... an leave out all other parts of the log and for it to automatically update when anew entry in one of these fields is added at the bottom. Thanks.

Column1	Column2	Column3	Column4
Risk Register - C2	1	Jack	1/26/2018 21:33
Archive - J2	5	Jack	1/26/2018 21:33
Input - H3	7	Jack	1/26/2018 21:40
Input - D18	6	Jack	1/26/2018 21:41
Input - C2:AA2	5	Jack	1/26/2018 21:41
Sheet1 - A3:C20	5	Jack	1/26/2018 22:02
Sheet1 - A3:A12	4	Jack	1/26/2018 22:02
Risk Register - C2	3	Jack	1/26/2018 21:33
Risk Register - C2	3	Jack	1/27/2018 12:26
Risk Register - F10	3	Jack	1/26/2018 22:04
Sheet1 - A3:A5	6	Jack	1/26/2018 22:04
Sheet1 - A3:A14	3	Jack	1/26/2018 22:04
Sheet1 - A3:A26	6	Jack	1/26/2018 22:04
Sheet1 - A3:B14	2	Jack	1/26/2018 22:04
Sheet1 - A3:B14	9	Jack	1/26/2018 22:05
Sheet1 - A3:B5	8	Jack	1/26/2018 22:05
Risk Register - G8	9	Jack	1/27/2018 12:26
Risk Register - H7	3	Jack	1/27/2018 12:26
Risk Register - J8	1	Jack	1/27/2018 12:26
Risk Register - J10	3	Jack	1/27/2018 12:26
Risk Register - L11	7	Jack	1/27/2018 12:26
Risk Register - L13	3	Jack	1/27/2018 12:26
Risk Register - K13	5	Jack	1/27/2018 12:26
Risk Register - C2	4	Jack	1/27/2018 12:26
Risk Register - C3	2	Jack	1/27/2018 12:26
Risk Register - C4	6	Jack	1/27/2018 12:26
Risk Register - C5	5	Jack	1/27/2018 12:26
Risk Register - C6	5	Jack	1/27/2018 12:26
Risk Register - C6	5	Jack	1/27/2018 12:26
Risk Register - C5	5	Jack	1/27/2018 12:26
Risk Register - C4	7	Jack	1/27/2018 12:26
Risk Register - C3	2	Jack	1/27/2018 12:26
Risk Register - C2	5	Jack	1/27/2018 12:26
Risk Register - C3	3	Jack	1/27/2018 12:26
Risk Register - C4	7	Jack	1/27/2018 12:26
Risk Register - C5	6	Jack	1/27/2018 12:26
Risk Register - C6	5	Jack	1/27/2018 12:26
Risk Register - C2	6	Jack	1/27/2018 12:26
Risk Register - C3	4	Jack	1/27/2018 12:26
Risk Register - C4	9	Jack	1/27/2018 12:26
Risk Register - C5	5	Jack	1/27/2018 12:26
Risk Register - C6	5	Jack	1/27/2018 12:26

<colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> </colgroup><tbody>
</tbody>