A formula in Data Range

If I want to plot column C vs. column A, rows 1-5, the Data range is
Sheet1!$A$1:$A$5,Sheet1!$C$1:$C$5

Is it possible to plot instead say the sum of columns B and C (ie B[i]
+ C[i] vs. A[i]) -
or must I instead create a column with B+C and use that?

Thanks!

Hi,

You can not use a formula in the data range itself but you can use Named
ranges.

Insert a named range, Insert > Names > Define Names...
Call it SumData and use the following formula.

=Sheet1!$B$1:$B$5+Sheet1!$C$1:$C$5

you can modify the charts series formula to be,
=SERIES(,Sheet1!$A$1:$A$5,Sheet1!SumData,2)

Cheers
Andy

bartsie wrote:
> If I want to plot column C vs. column A, rows 1-5, the Data range is
> Sheet1!$A$1:$A$5,Sheet1!$C$1:$C$5
>
> Is it possible to plot instead say the sum of columns B and C (ie B[i]
> + C[i] vs. A[i]) -
> or must I instead create a column with B+C and use that?
>
> Thanks!
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info