combining two cell values to one value to chart

[SteveZmyname]

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

 

[SteveZmyname]

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.

 

[Jon Peltier]

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

- Jon

 

[SteveZmyname]

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

 

[David Biddulph]

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