=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
.