How to Create Box and Whisker Chart in Microsoft Excel
-
In today's lesson, you will learn how to create box and whisker chart in Excel.
Open an Excel file you need. Select data you need in a chart and go to the ‘Insert’ tab. Click on ‘Recommended Charts’. Go to the ‘All charts’ tab. Select ‘Box & Whisker’ from the list. Click ‘Ok’.
Resize the chart if needed. You can choose the look of your chart. Choose the style you like under “Chart Styles” block. If you click on the plus icon next to the chart you can add some additional chart elements. For example, Axis Titles or Data Labels. If you click on the arrow next to ‘Legend’ option, you can move it to any side of the chart.
You can also change the graph colors. To do so, click on ‘Change colors’ in the top left corner of the window. Select the charts and choose the colors from the palette.
Watch video How to Create Box and Whisker Chart in Microsoft Excel online without registration, duration hours minute second in high quality. This video was added by user HOWZA 08 August 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 47 once and liked it 0 people.