Phone:+16179821253
Address: 315 W 3rd St, Boston, Massachusetts, 02127, USA
Email: sloanecarter773@gmail.com
Phone:+16179821253
Address: 315 W 3rd St, Boston, Massachusetts, 02127, USA
Email: sloanecarter773@gmail.com
Excel has no violin chart, so here is how to build one with formulas and which faster workarounds exist.
Excel has no built-in violin chart type. At the time of writing, the chart gallery in Excel for Microsoft 365 includes a box and whisker chart and a histogram, but no violin. You can still build one by hand: estimate the density with formulas, then plot it as a mirrored scatter chart. This guide shows that method, the other workarounds, and how long each one takes.
If you just need the picture, the fastest route is to copy your column from Excel and paste it into our free violin plot maker. It draws the chart in your browser and lets you download it, with no add-in or signup.
Excel 2016 and later, including Microsoft 365, include a Box and Whisker chart under the statistical charts. It shows the median, quartiles, whiskers and outliers. It does not show the shape of the distribution, so two very different datasets can produce the same box. That gap is the main reason people want a violin. Our comparison of the violin plot vs box plot shows what each one hides.
The Histogram chart shows shape for one dataset at a time. It is awkward for comparing several groups side by side, which is what violins do well.
| Method | Effort | Needs | Good for |
|---|---|---|---|
| Formulas plus mirrored scatter chart | High the first time, then reusable | Any recent Excel | Staying fully inside Excel |
| Python in Excel (seaborn) | Low if you know a little Python | A Microsoft 365 plan that includes Python in Excel | Repeat work inside a workbook |
| Third-party statistics add-in | Low once installed | Install rights, often a paid licence | Teams that already use the add-in |
| Paste into an online maker | Very low | A browser | One-off charts for reports and slides |
A violin is a kernel density estimate drawn on both sides of a centre line. Excel can calculate a Gaussian kernel density with SUMPRODUCT and NORM.S.DIST. The steps below build one violin. Repeat the block for each group.
Place the values for one group in A2:A101. Adjust the range to your data. Remove blanks and text, because they break the counts.
The bandwidth sets how smooth the outline is. Silverman’s rule of thumb is a common starting point. Put this in H2:
=0.9*MIN(STDEV.S(A2:A101),(QUARTILE.INC(A2:A101,3)-QUARTILE.INC(A2:A101,1))/1.34)*COUNT(A2:A101)^(-1/5)
A smaller value shows more bumps. A larger value smooths them away. Try halving and doubling it to see how sensitive your chart is. The violin plot bandwidth guide explains the trade-off.
The density is calculated at evenly spaced points from the minimum to the maximum. In Microsoft 365 or Excel 2021 and later, one formula in D2 fills 50 rows:
=SEQUENCE(50,1,MIN(A2:A101),(MAX(A2:A101)-MIN(A2:A101))/49)
In older versions, put =MIN(A2:A101) in D2, then =D2+(MAX($A$2:$A$101)-MIN($A$2:$A$101))/49 in D3, and fill down to D51.
In E2, enter this and fill down to E51:
=SUMPRODUCT(NORM.S.DIST((D2-$A$2:$A$101)/$H$2,FALSE))/(COUNT($A$2:$A$101)*$H$2)
For each grid value, this adds up a small normal curve centred on every data point. That sum is the kernel density estimate. FALSE tells NORM.S.DIST to return the curve’s height rather than the cumulative probability.
Scale the density so the widest point is a fixed half-width, here 0.4, around a centre of 1. For the second group, use a centre of 2, and so on.
F2 (right edge): =1 + E2/MAX($E$2:$E$51)*0.4
G2 (left edge): =1 - E2/MAX($E$2:$E$51)*0.4
Fill both down to row 51. Dividing by the maximum gives every violin the same width. If you want widths to reflect sample size, divide by one shared maximum across all groups instead.
F2:F51 and Y values from D2:D51.G2:G51 and the same Y values.You now have the outline of a violin. To mark the median, add one more series: a single point with X = 1 and Y = MEDIAN(A2:A101). Quartiles work the same way with QUARTILE.INC.
Once built, though, the workbook is reusable. Paste new data into column A and the chart updates.
Some Microsoft 365 plans include Python in Excel, which runs Python code in a cell with the =PY() function. The bundled environment includes seaborn, so a short script can draw a real violin from a table in your sheet. Availability depends on your plan, platform and region, so check whether =PY appears in your Formulas tab. The seaborn steps are in our violin plot in Python guide.
Several third-party statistics add-ins for Excel advertise violin or density plots. Features and prices change, so check the vendor’s current feature list and whether your organisation allows installing add-ins before you rely on one. An add-in makes sense if your team already uses it for other analysis. It is a lot of setup for one chart.
For a one-off chart, this is the least work:
The trade-off is that the image does not update when your data changes. You paste again instead.
Whichever method you use, read the width at each height as “how common values are here”. A violin with two bulges means two clusters of values, which a box and whisker chart would hide. If a group has only a handful of points, show the points too, because a smooth outline can look more certain than the data is. Our guide on how to read a violin plot goes further, and the violin plot guide covers when the chart is the right choice.
Not as a built-in chart type. Excel for Microsoft 365 includes box and whisker and histogram charts, but a violin has to be built with formulas, an add-in or another tool.
The Box and Whisker chart, available since Excel 2016. It shows quartiles and outliers but not the shape of the distribution.
SUMPRODUCT with NORM.S.DIST(...,FALSE) gives a Gaussian kernel density estimate. You divide by the count times the bandwidth.
Yes. Copy the column and paste it into a free online violin plot maker, then download the chart and insert it back into your file.
Transform complex datasets into clear, interactive visualizations with Violin Plot. Start exploring data distributions in a way that empowers insight and drives smarter decisions.



