Normalizing chart by scale Normalization by Scale is very useful if you want to see two different Data Columns simultaneously with the same scale. To Normalize Chart by Scale: Select the desired second Data Column. Click the Chart settings button. In the appeared dialog box set Normalization to By scale. Click the button.