but is there a way to chart it using the original data?

"Jon Peltier" wrote:

The best way to do this is in fact with another range, but you can use
formulas to make your life easier.

You want to get the data from alternating cells between B2 and X2. In
another range (I used B7:M7, but pick a convenient location). The formula I
entered into B7 is

=OFFSET($B$2,0,(COLUMN()-2)*2)

and I filled the range B7:M7 with this formula. If your output range starts
in another column, change the 2 (for B) in (COLUMN()-2) to whatever the
column number is for the first cell of the output range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Wanda" wrote in message
...
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?