This option is disabled when the chart itself is actually enabled, which is why you have to click off the chart and choose a cell near, but not on or under, the chart. Click off the note and you’ll see a small red triangle in the cell with the note. When the comment window appears, type the note. Click the “Review” tab at the top of the page.Ĭlick the “New Comment” button. Format the text so it fits inside the text box or stands out from the chart by clicking the “Home” tab and using options such as the “Font size” or “Font color” menus on the left side of the ribbon.Ĭlick off the chart onto a cell directly above, below or next to the chart. Make sure the Show Input Message When Cell is Selected check box is selected. The Input Message tab of the Data Validation dialog box. Make sure the Input Message tab is displayed. A blue dotted line surrounds the text box, but those lines won’t appear on the chart, they just symbolize the text box’s location. To add such a feature, follow these steps: Select the cell for which you want the pop-up to appear. Position the cursor on the chart and draw the text box. The cursor changes to an upside down cross. Click the “Text Box” button on the ribbon. Type directly over the text with your own note.Ĭlick the “Insert” tab at the top of the workspace. Highlight the text Excel automatically inserted. For example, in a pie or bar chart, text boxes are added to each pie piece or bar.Ĭlick into one of the newly added text boxes. Small text boxes are added to the chart – this will depend on the type of chart.

Click the first button in the “Chart Layouts” section of the ribbon. Click the “Close” button.Ĭlick the chart to enable the green “Chart Tools” tab at the top of the screen. Click into the “Description” text box and type a note about the chart, such as a short description of what the chart represents. There is an option to add comments in an Excel worksheet, what are the cells called in which comments can be added Cell Tip Comment Tip Smart Tip Point Tip. Choose “Format Chart Area” from the fly-out menu.Ĭlick the “Alt Text” link on the left side of the “Format Chart Area” window.

Add notes to excel cell