I have used the example of a pre and post assessment around training. There are four questions with a pre and post score. The idea is to compare the pre and post score and identify the percentage change.
The data is fake. I got ChatGPT to generate it for me. Here is the starting file
Here is the finished version
- Step One – Pivot table to summarize your data
- Step Two – Create a table to calculate the growth and create a combo chart
- I used the vlookup, iferror and creating a combo chart for these steps.
- Step Three – Copy this across for other questions