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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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

A
  • Question Question
Excel Newbie
2
Replies
11
Views
171
Logit
Logit
R
  • Question Question
Freezing/Logging Data from DDE at 1 Minute Intervals
Replies
1
Views
125
Anthony47
A
M
  • Question Question
Line Graph query
Replies
5
Views
258
awoohaw
awoohaw
N
  • Question Question
Dashboards
Replies
1
Views
354
awoohaw
awoohaw
V
  • Question Question
VBA to create and format graph
Replies
0
Views
222
VEVE4014
V

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

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