# A formula in Data Range

1. ## 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!  Register To Reply

2. ## Re: A formula in Data Range

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  Register To Reply