normalizing some columns to a specific column

[mahmoodn]

Hi there,
I have three columns:

Please Login or Register  to view this content.

I want to create a 2-D clustered column graph while normalizing to column C. I mean all values in column C should be set to 1 and the other two columns are normalized to 1.

I read some documents about how to normalize data in excel, but I can not apply their methods to my problem.

Thanks for any comment.

[mrice]

Please have a look at the attached.

I've used formulae to perform the normalisation.

[mahmoodn]

interesting.... then there is no need for STANDARDIZE, std_dev, ....

thanks a lot