Home » Accounting » Tips on how to Place a Caption to the Chart in Excel

Tips on how to Place a Caption to the Chart in Excel


Including some sort of caption for a chart within Ms Office’s Excel sheet system will help explain the framework connected with or any type of significant findings that they are drawn from your data currently being represented. This system does not include any sort of pre-installed captioning options, however you have the capacity to set up the one which lines up along with a chart with your file. Use a mix of written text field together with group options so as to add a good caption within your company’s chart in Excel.
Open the Ms Excel document which has your own graph. Click on the Insert navigation within the ribbon at the top of the display.
Click the “Text Box” possibility on the Text area over the ribbon.
Click on any where around the sheet and also pull your cursor towards caption’s wanted size as well as length. Release your computer mouse button in order to complete sizing the written text box.
Enter your expected caption in to the text message box you just created.
Switch the cursor on the outer border of your text box right up until your cursor becomes the cross symbolic representation. Please click and also move the writing box, position it under your current graph.
Click on plus move the bright white squares on the left or right side on the written text box for you to resize that to match the particular width from the chart.
Hold straight down the “Ctrl” key on your computer keyboard then click the chart and then the text field with your mouse. Holding down the Control key enables you to choose both items simultaneously.
Right-click either item as well as maintain your cursor within the “Group” selection. Grouping selections show to the right on your cursor.
Click “Group” from the list of possibilities to far right. The written text field along with the caption turned into locked along, allowing you to resize and align them as single unit, when wanted.