Following on from this thread:

http://www.excelforum.com/showthread.php?t=1169716

Dear JeteMc and Jeff,

A million thankyou to you both. I think im almost there. Please see attached spreadsheet. i have a few things that i cannot get to work, please could you help? There are as follows:

1. 2. Corp Esc risk Log --> I have added initial/current/target columns. as shown below:

ini.JPG

When i make any changes to these values these are not reflected in in the dashboard as shown below:

inirisk.JPG

The same thing applies to the 4.AOR-Issue log. Any changes made are not reflected in the dashboard

Also these values are not then shown in the two graphs on the dashboard as shown below:

graph.JPG

2. In the graph below when i change the values in tab 2 or 4 they are not reflected in the table and subsequently not reflected in the grapgh below too.

2risk.JPG

3graph.JPG