Charting Non-Sequential data
 

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?

Charting Non-Sequential data
 

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?

Charting Non-Sequential data
 

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?

Charting Non-Sequential data
 

I was able to select all 12 cells using CTRL+Click. If you can't get all 12,
make a chart with as many as you can, then select and copy the rest, select
the chart, and use Paste Special from the Edit menu, and select the Add
Points option.

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


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