There are several ways to add text next to a Gantt chart in Excel. ... you can place a text box beside the chart. ... cells of the first column containing the data pertaining to the Gantt chart.

How to Add Zoom & Scroll to an Excel Chart. ... Click the button in the text box labeled "Chart data range." Select the range from Step 2. Click "OK" to close the dialog box.

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...

Back in the Select Data Source dialog box, click the Add button again. Then, select the Duration (Days) header in the sheet for Series name . For the Series values text box, select all the days ...

Type into the text box the text for the label. Repeat to add additional labels. Click the "File" tab, then click "Save As." Type a name for the new graph and click the "Save" button.

Click the Developer menu at the top, select Insert, then choose the Text Box component. Go back to the space and draw the box using your mouse. You will have an empty text box. Right-click the text ...