I plotted some data in a Box & Whiskers plot and I would like to draw a horizontal line across at a certain value. I don't normally do this type of chart, but typically when I need to do this I go to Format - draw shape - line and just draw a line where I need it and then format it how I would like it.
With the chart selected, I try to go to the format menu but everything in the "Insert Shapes" portion of the ribbon is grayed out, as is everything in "WordArt Styles", "Arrange", and "Size".
I also tried going to the "Insert" ribbon but the only thing that is not grayed out on that ribbon is "Header & Footer".
Having done some searching, I also went into Options - Advanced - Display Options for this Workbook and clicked "All" on the show objects part. I have saved and re-opened this workbook.
I'm running Excel 2017
This question was asked on Stack Overflow and it was suggested I try it here