graph only part of a data table

J

Jack235

New Member
Joined
Jan 25, 2018
Messages
6
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.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
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.
Archive - J2Jack
Input - H3Jack
Input - D18Jack
Input - C2:AA2Jack
Sheet1 - A3:C20Jack
Sheet1 - A3:A12Jack
Jack
Jack
Risk Register - F10Jack
Sheet1 - A3:A5Jack
Sheet1 - A3:A14Jack
Sheet1 - A3:A26Jack
Sheet1 - A3:B14Jack
Sheet1 - A3:B14Jack
Sheet1 - A3:B5Jack
Risk Register - G8Jack
Risk Register - H7Jack
Risk Register - J8Jack
Risk Register - J10Jack
Risk Register - L11Jack
Risk Register - L13Jack
Risk Register - K13Jack
Risk Register - C2Jack
Risk Register - C3Jack
Risk Register - C4Jack
Risk Register - C5Jack
Risk Register - C6Jack
Risk Register - C6Jack
Risk Register - C5Jack
Risk Register - C4Jack
Risk Register - C3Jack
Risk Register - C2Jack
Risk Register - C3Jack
Risk Register - C4Jack
Risk Register - C5Jack
Risk Register - C6Jack
Risk Register - C2Jack
Risk Register - C3Jack
Risk Register - C4Jack
Risk Register - C5Jack
Risk Register - C6Jack

<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>
[TD="width: 124"]Column1[/TD]
[TD="width: 101"]Column2[/TD]
[TD="width: 79"]Column3[/TD]
[TD="width: 101"]Column4[/TD]

[TD="class: xl67"]Risk Register - C2[/TD]
[TD="align: right"]1[/TD]
[TD="class: xl67"]Jack[/TD]
[TD="class: xl68, align: right"]1/26/2018 21:33[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/26/2018 21:33[/TD]

[TD="align: right"]7[/TD]

[TD="class: xl68, align: right"]1/26/2018 21:40[/TD]

[TD="align: right"]6[/TD]

[TD="class: xl68, align: right"]1/26/2018 21:41[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/26/2018 21:41[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:02[/TD]

[TD="align: right"]4[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:02[/TD]

[TD="class: xl67"]Risk Register - C2[/TD]
[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/26/2018 21:33[/TD]

[TD="class: xl67"]Risk Register - C2[/TD]
[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:04[/TD]

[TD="align: right"]6[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:04[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:04[/TD]

[TD="align: right"]6[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:04[/TD]

[TD="align: right"]2[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:04[/TD]

[TD="align: right"]9[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:05[/TD]

[TD="align: right"]8[/TD]

[TD="class: xl68, align: right"]1/26/2018 22:05[/TD]

[TD="align: right"]9[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]1[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]7[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]4[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]2[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]6[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]7[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]2[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]7[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]6[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]6[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]4[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]9[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

[TD="align: right"]5[/TD]

[TD="class: xl68, align: right"]1/27/2018 12:26[/TD]

</tbody>
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Line Graph query
Replies
5
Views
244
awoohaw
awoohaw
N
  • Question Question
Dashboards
Replies
1
Views
345
awoohaw
awoohaw
V
  • Question Question
VBA to create and format graph
Replies
0
Views
221
VEVE4014
V
R
  • Solved
VBA Function to remove line spaces in an Email
Replies
2
Views
135
Ragham26
R
B
  • Question Question
record changes to a worksheet - (2)
Replies
1
Views
337
Joe4
Joe4

Forum statistics

Threads
1,223,901
Messages
6,175,277
Members
452,629
Latest member
SahilPolekar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top