Creating a Pre to Post Chart in Microsoft Excel

This works especially well when you provide Excel with a very simple data set that contains only pre and post data (in addition to student or group identifier). You can do this in under a minute using a relatively newer feature in MS Excel (starting with 2013) called Recommended Charts. Watch this:

This feature is also available in Google Sheets which you can see in this video:

Finally, check out the F11 trick:

If you like this, you’ll love My Data Boot Camp! Also, check out this Facebook Page.