Violin Plot

%3CLINGO-SUB%20id%3D%22lingo-sub-1598226%22%20slang%3D%22en-US%22%3EViolin%20Plot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598226%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wanted%20to%20know%20if%20it%20is%20possible%20to%20make%20a%20Violin%20plot%20using%20Excel%2C%20without%20having%20to%20build%20it%20piece%20by%20piece%20(see%20attached%20file)%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FViolin_plot%23%3A~%3Atext%3DA%2520violin%2520plot%2520is%2520a%2Cby%2520a%2520kernel%2520density%2520estimator.%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fen.wikipedia.org%2Fwiki%2FViolin_plot%23%3A~%3Atext%3DA%2520violin%2520plot%2520is%2520a%2Cby%2520a%2520kernel%2520density%2520estimator.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20manged%20to%20find%20the%20solution%20from%20a%20forum%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fforum%2Fthreads%2Fviolin-plots-in-excel.5929%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchandoo.org%2Fforum%2Fthreads%2Fviolin-plots-in-excel.5929%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20implemented%20it%2C%20the%20problem%20this%20is%20time%20consuming.%20Can%20it%20be%20done%20by%20a%20macro%3F%20I%20am%20not%20sure%2C%20as%20I%20am%20not%20expert%20in%20Macros.%20Hopefully%20someone%20can%20help%20with%20this%20matter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20the%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1598226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Contributor

I wanted to know if it is possible to make a Violin plot using Excel, without having to build it piece by piece (see attached file)?

https://en.wikipedia.org/wiki/Violin_plot#:~:text=A%20violin%20plot%20is%20a,by%20a%20kernel%20densi...

 

I manged to find the solution from a forum, https://chandoo.org/forum/threads/violin-plots-in-excel.5929/

 

I also implemented it, the problem this is time consuming. Can it be done by a macro? I am not sure, as I am not expert in Macros. Hopefully someone can help with this matter.

 

see the attached file

0 Replies