Normalising Data for plotting graphs in Excel

This short tutorial shows how to normalise grouped data in Excel for the production of graphs showing change in outcome over time where the baseline may be variable but the change in outcome consistent.



© 2015 James Clark

[jmlee]

Hi, just want to let you know that all of your labchart and graphpad videos are very helpful. Thank you.

[jayishnuroy]

Thank you sooo mucch!
I was searching for intuitive understanding of normalisation from long

[SantoshTata]

finally I understood the data normalization thank you very much

[davidbundgaard]

Actually when you expanded horisontal you actually made column 3 and 4 to be percentage of column 2 as you locked the cell.

[Shibu]

Can I use the same technique for forecasting based on time series data?

[husso]

Thanks a lot for the video, it is really helpful. I also liked the graphs template, how can I get something similar? :)

[helloitsme]

Is it a stock chart plotting the average and half the stddev above and below for the stick?

[antoniolee]

Does it make sense to use geo-mean than arithmetic mean here?

[helloitsme]

How do you create the chart in the video?

[FancyAnimal]

Is this the 6 fingered man from Princess Bride?