Display A Custom Benchmark Line Across Graph Plot Area

It works well but the Bars and score cells do not line up when hiding columns....I attached a Graph area....is it possible to get bars to appear in each column from the score without using a selected chart from the ribbon....This way the Bar will always stay about the score.....I do not know but is this only possible with code or could CF work....I would want to to use cell B3 to place the marker line as well

What do you think

Thanks

regc

I don't really think there's anything wrong with the alignment if you just set it once. What's wrong with this for instance?

Yes the sample is exactly what I wanted..you are correct it looks very good..how did you align this please?

What is your recommendations on locking the sheet except for score cells and percentage cell which can be changed,,,

Regards

Regc

I can't think of a way to protect the sheet and allow hiding and unhiding of columns or rows. The recommendation there would be to use VBA macro, but that's a different topic.