Use a helper column where you normalize your numbers using an appropriate
formula prior to charting, and then chart that column with your normalizing
formulas.
HTH,
Bernie
MS Excel MVP
mason said:
How do you normalize a column of numbers using a chart? I know how to do