If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart Data Normalization
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 |
#2
|
|||
|
|||
Chart Data Normalization
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 |
Thread Tools | |
Display Modes | |
|
|