Hello
While making a chart I wish to combine two values from two seperate cells to
make one value to send to a chart. In this case it is the values for the
columns named S3 and S4. Enclosed is the ss please refer to sheet 3. I don't
know the formula for adding the two and displaying.

It's a bit confusing this ss formatting. The S3 col are L and S4 is N. I
don't know if I have to make the calc show in a cell or just do it on the
fly. Using the chart wizard it's the series values I believe is where a
formula could go.

thanks for any help given,
Steve

Sorry, looks like I can't do an attachment. That makes it hard.
The value for S3 is =Sheet3!$L$6:$L$8
and S4 is =Sheet3!$N$6:$N$8
I hope that's enough to go on.

"SteveZmyname" wrote:

Hello
While making a chart I wish to combine two values from two seperate cells to
make one value to send to a chart. In this case it is the values for the
columns named S3 and S4. Enclosed is the ss please refer to sheet 3. I don't
know the formula for adding the two and displaying.

It's a bit confusing this ss formatting. The S3 col are L and S4 is N. I
don't know if I have to make the calc show in a cell or just do it on the
fly. Using the chart wizard it's the series values I believe is where a
formula could go.

thanks for any help given,
Steve

How do you want to "combine" the values? Sum? Average? Adjust the
formula in the cell that the chart uses for its data.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



SteveZmyname wrote:
Sorry, looks like I can't do an attachment. That makes it hard.
The value for S3 is =Sheet3!$L$6:$L$8
and S4 is =Sheet3!$N$6:$N$8
I hope that's enough to go on.

"SteveZmyname" wrote:

Hello
While making a chart I wish to combine two values from two seperate cells to
make one value to send to a chart. In this case it is the values for the
columns named S3 and S4. Enclosed is the ss please refer to sheet 3. I don't
know the formula for adding the two and displaying.

It's a bit confusing this ss formatting. The S3 col are L and S4 is N. I
don't know if I have to make the calc show in a cell or just do it on the
fly. Using the chart wizard it's the series values I believe is where a
formula could go.

thanks for any help given,
Steve

thanks for the reply.
I wanted to add the two. A formula something like =data!(SUM(L6:N6)).
One issue is I have merged cells. The first cell to add is over L and M.
While the 2nd is over N and O. How do I get around this issue? thanks for any
help
Steve


"Jon Peltier" wrote:

How do you want to "combine" the values? Sum? Average? Adjust the
formula in the cell that the chart uses for its data.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



SteveZmyname wrote:
Sorry, looks like I can't do an attachment. That makes it hard.
The value for S3 is =Sheet3!$L$6:$L$8
and S4 is =Sheet3!$N$6:$N$8
I hope that's enough to go on.

"SteveZmyname" wrote:

Hello
While making a chart I wish to combine two values from two seperate cells to
make one value to send to a chart. In this case it is the values for the
columns named S3 and S4. Enclosed is the ss please refer to sheet 3. I don't
know the formula for adding the two and displaying.

It's a bit confusing this ss formatting. The S3 col are L and S4 is N. I
don't know if I have to make the calc show in a cell or just do it on the
fly. Using the chart wizard it's the series values I believe is where a
formula could go.

thanks for any help given,
Steve
.

=SUM(data!L6:N6), but most users here would recommend avoiding merged cells
like the plague.
--
David Biddulph

"SteveZmyname" wrote in message
...
thanks for the reply.
I wanted to add the two. A formula something like =data!(SUM(L6:N6)).
One issue is I have merged cells. The first cell to add is over L and M.
While the 2nd is over N and O. How do I get around this issue? thanks for
any
help
Steve


"Jon Peltier" wrote:

How do you want to "combine" the values? Sum? Average? Adjust the
formula in the cell that the chart uses for its data.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



SteveZmyname wrote:
Sorry, looks like I can't do an attachment. That makes it hard.
The value for S3 is =Sheet3!$L$6:$L$8
and S4 is =Sheet3!$N$6:$N$8
I hope that's enough to go on.

"SteveZmyname" wrote:

Hello
While making a chart I wish to combine two values from two seperate
cells to
make one value to send to a chart. In this case it is the values for
the
columns named S3 and S4. Enclosed is the ss please refer to sheet 3. I
don't
know the formula for adding the two and displaying.

It's a bit confusing this ss formatting. The S3 col are L and S4 is N.
I
don't know if I have to make the calc show in a cell or just do it on
the
fly. Using the chart wizard it's the series values I believe is where
a
formula could go.

thanks for any help given,
Steve
.