View Single Post
  #1   Report Post  
ab
 
Posts: n/a
Default add to values in the chart not on the worksheet

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.