stevezmyname

Hello
While making a chart I wish to combine two values from two separate 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 is 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.

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.

I just saw that it won't let me attach my excel file. Don't know why.

thanks for any help given,
Steve