Welcome to another requested Excel video from Change Tips and Tools! In this tutorial, we will show you how to create a Box Plot chart in Excel and a Violin chart in Excel with no add-ins.

To create the violin support data, we will combine the BYROW Function and the LAMBDA Function with the NORM.DIST Functions.

Two extremely useful charts for examining data reference summarizing and displaying the distribution of continuous data at a glance. Join us as we compare the Box Plot vs the Violin Plot chart to see which one you prefer.

Let us know your thoughts in the comments below!

Delivered by @Changetipsandtools

This Video includes:
00:00 - Intro
00:29 - What we will cover in this video
00:58 - Create some Student test score data quickly with the RANDARRAY Function
02:45 - Create Box Plot Chart
05:15 - Build Violin chart support data
09:34 - Create our Violin Chart
19:49 - Compare our charts

Follow link for the source Excel file for your reference:
https://drive.google.com/drive/folder...

#excel #exceltips #boxplot #violinchart #pmo #dataanalysis #datavisualization #violinplot #howto #microsoft #fyp #datadistribution