I was trying to select two non-adjacent columns for a chart and I can select
one and when I try to select the second range, holding the CTRL key before
selecting, the first selection turns off. I have used this feature for years
and this is the first time I have come across this problem.

Is there an option to turn the Ctrl+select feature off in Excel 2007?