Hi. I have two columns of data relating to two products. I would like to
'normalize' the data so that in graph format, they both start from the same
point giving a realistic comparison between the movement of both. The data
is as follows:

ColumnA ColumnB
1.09% 24.00%
-0.11% -2.03%
-1.95% -0.13%
-18.54% -14.99%
-13.92% -15.56%
-31.25% -27.62%
-17.57% -23.33%
-9.63% -16.19%
-5.78% -11.19%
6.78% 5.33%
4.45% 10.55%
-4.95% 4.40%
10.23% 13.59%
1.84% -4.24%
7.73% 9.89%

Is this possible please?
Thanks
Yvonne

This data looks fine in a line chart without any normalization. The
first point of column B is a bit off, but the rest of the A and B points
follow each other.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



yvonneb wrote:
Hi. I have two columns of data relating to two products. I would like to
'normalize' the data so that in graph format, they both start from the same
point giving a realistic comparison between the movement of both. The data
is as follows:

ColumnA ColumnB
1.09% 24.00%
-0.11% -2.03%
-1.95% -0.13%
-18.54% -14.99%
-13.92% -15.56%
-31.25% -27.62%
-17.57% -23.33%
-9.63% -16.19%
-5.78% -11.19%
6.78% 5.33%
4.45% 10.55%
-4.95% 4.40%
10.23% 13.59%
1.84% -4.24%
7.73% 9.89%

Is this possible please?
Thanks
Yvonne