How can I show only one X on a line?

**Lynneth** · 06-20-2011, 06:10 AM

I have an Excel spreadsheet which will contain 24 questions ranked from -5 (very unsatisfactory) through to +5 (very satisfied). For simplicity, the client(s) will place an x in the appropriate place, which will create a graph. This will enable them to see what requires improving

The problem I have is that I only want them to be able to place one x on the line, so if they change their mind and put an x in a different place, I want the other one to disappear

It should be really simple, but I am struggling

I have attached the spreadsheet so you can see it

I would really appreciate you help

Thank you
Lynne

**teylyn** · 06-20-2011, 06:34 AM

Hello,

this will probably not be doable without VBA. Something along these lines in the Worksheet_Change event.

Please Login or Register  to view this content.

The above code monitors the range C3:M26. Change as required. See attached sample.

cheers,

**teylyn** · 06-20-2011, 06:39 AM

Or, as an alternative approach, create a new column with a data validation list, where the customer selects the rating from a drop down. Then a formula can calculate where to place the x

=IF($C3=D$1,"x","")

See attached.

cheers,