) I have been able to simply write: ActiveChart.ChartType = xlColumnClusteredīut, when I want to do it for a box plot (xlboxwhiskler) I have not been able to complete it. My goal is to create some BoxPlot Charts in Excel at this time, I have been able to create some For/If loop to capture the Data in my different worksheets (ex: I have a Ftotal column in each worksheet, but from different length that I want to add to my boxplot). Note also that the Percentage option may be very useful if your dataset is not made of the actual percentage value that the slices represent: this option makes a calculation based on the ratio between the data value and the sum of all data in the series, then multiplies it by 100.I am a beginner in VBA, so be indulgent in my lack of methodology while working on some VBA macro for Excel. You may as well tune the position of the label, the number formatting, the colors and much more.

This opens a panel to the right of the screen which allows you to add/remove the series name, category name, value, percentage… to/from the label. Additionally, if you right-click on the labels of the pie chart, the contextual menu gives you the option Format Data Label. Yo may use the Font section in the ribbon under the Home tab to modify the font type, size, color and all details that usually apply to text. Repeat the procedure with more slices if you wish (see picture to the right). Then, right-click and choose Add Data Label.

Instead of clicking and activating the whole pie, click and activate only the slice(s) of interest. Note that it is actually possible to restrict the display of values to only the slices that you want. If you want to add the actual values from the dataset on top of the corresponding slices, select the pie by clicking on it, then right-click and choose Add Data Labels.

The pie chart that you’ve created previously and modified until now still looks a bit “naked” as there is no display of numerical data or scale. In Excel16 -3- Figures and graphs / MS Excel 2016 (EN)

Add labels to boxplot in excel 2016