add to values in the chart not on the worksheet

[ab]

Hi,

I have a set of values which I have plotted.

A B
1 1
2 4
3 9
4 16
5 25

Now, I want to add a constant value to values in column B without
calculating them again in a column. I am wondering if i can do this
directly in the "chart dialog box". I will appreciate any help.

Thanks.

[Anne Troy]

Perhaps this will help:

http://www.officearticles.com/excel/...worksheets.htm

************
Anne Troy
www.OfficeArticles.com

"ab" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a set of values which I have plotted.
>
> A B
> 1 1
> 2 4
> 3 9
> 4 16
> 5 25
>
> Now, I want to add a constant value to values in column B without
> calculating them again in a column. I am wondering if i can do this
> directly in the "chart dialog box". I will appreciate any help.
>
> Thanks.