Align Bar Chart With Corresponding Data In Source Range

[regc]

Hi

This is a new thread continuing on from post - http://www.excelfox.com/forum/f2/dis...lot-area-1291/
I will need VBA for the following please
I require the Bars to be displayed after looking at the Scores in G14:P14 ( I have placed a dummy bar for demonstration).The Columns can be hidden depending on what needs to be visible..
There are Score markers from 0 -50-100 which will remain static.Can the Benchmark Line look at E4 and place the Line % in Red on the graph area
I need to then have a code for protection for cells G2:P23.I will use a commandbutton to protect/unprotect saying protect/unprotect.The sheet will protect on closing of workbook

Not sure if possible but will be good if achievable

Thanks

Regc