I'm using Excel 2003 and trying to chart data in 12 non-sequential cells. I
can select 9 of the cells by holding down the <ctrl key and selecting the
cells, but when I attempt to select the 10th cell, the previous 9 cell
references are deleted from the data entry field.

The cells I'm trying to chart are in B2, D2, F2, H2, etc.

I temporarily solved the problem by creating a new table with just the data
I needed for the chart and creating from there, but that seems to be the long
way around it and quite subject to data entry error.

Is there an easier way to do this?