Before doing this, have more than one worksheet tab open. Select the chart, then go to the Chart Design tab. In the Location group, click the Move Chart button. In the Move Chart dialog box. Select ...

Learn how to autofit comment box in Excel using Format Comment option &VBA Code. This automatically resizes comment box to fit comment text.