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?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks