problem with series names in excel 2016 boxplot - shows 1 label instead of series labels

%3CLINGO-SUB%20id%3D%22lingo-sub-334312%22%20slang%3D%22en-US%22%3Eproblem%20with%20series%20names%20in%20excel%202016%20boxplot%20-%20shows%201%20label%20instead%20of%20series%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334312%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20set%20up%20a%20boxplot%20chart%20in%20excel%202016%2F365.%20I%20have%2018%20series%20showing.%20However%2C%20it%20won't%20show%20the%20labels%20for%20these%20series.%20I%20know%20the%20labels%20are%20there%20and%20correct%20because%20I%20can%20get%20it%20to%20show%20the%20series%20labels%20in%20a%20legend%2C%20but%20across%20the%20bottom%20of%20the%20chart%20it%20shows%20%221%22%20as%20the%20label%20for%20all%20the%20series%20combined.%20How%20do%20I%20fix%20this%20-%20I%20need%20the%20labels.%20Showing%20it%20in%20a%20legend%20is%20not%20ideal%20as%20it's%20harder%20to%20line%20up%20what%20labels%20goes%20with%20what%20box.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20figure%20out%20how%20to%20get%20the%20boxes%20labeled%20on%20the%20x%20axis%20instead%20of%20using%20the%20legend%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-334312%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have set up a boxplot chart in excel 2016/365. I have 18 series showing. However, it won't show the labels for these series. I know the labels are there and correct because I can get it to show the series labels in a legend, but across the bottom of the chart it shows "1" as the label for all the series combined. How do I fix this - I need the labels. Showing it in a legend is not ideal as it's harder to line up what labels goes with what box. 

 

I'd like to figure out how to get the boxes labeled on the x axis instead of using the legend

 

0 Replies