adding a constant to all values in a column

[Billy Wilton]

Help! Can anyone give me some insight into adding a
constant to each of the data points in a line. I'm
hoping to space the lines out as the values of 15 lines
overlap. I'd like to add 1 a set of data point, 2 to a
set, 3 to a set and so on. Instead of making 15 graphs
and pasting them together. Thanks

 

[Frank Kabel]

Hi Billy
several way:
1. create a sperate sheet which links your original data and adds
values to your selected rows/columns. Use this adapted sheet as source
for your chart

2. If you want to change the original data one way would be the
following:
- insert the number to add in a cell
- copy this cell
- select the cells to change
- goto 'Edit - Paste Special'. choose the action 'Add'
- repeat for the other cells