Images (including Pictures, Charts, etc.) are found in the Illustrations area of the Insert tab.
Pictures may be added in Excel, and it’s possible to add alt text to them. However, it’s best to avoid using pictures as they may create reading order issues.
The Chart option is located in the Illustrations area of the Insert tab. Contents of charts and graphs should be clear and labeled.
To add a chart, go to Insert > Charts > Choose the type of chart that best represents the data:
Once you’ve added a Chart, you’ll be able to see the Chart Tools tabs for Design and Format. (These contextual ribbon tabs are only visible when you click on an inserted Chart.)
Once you’ve inserted your Chart, add Data Labels. There are several ways to add Data Labels. The Add Chart Element option is available in the Chart Tools Design ribbon tab.
Also, if you click on your chart, several icons will appear, such as the Chart Area icon (which looks like a plus sign).
Click on the Chart Area icon to add data labels. If you go to More Options, you’ll access the Format Data Labels pane.
(Alternately, right click on an item in the chart > Format Data Labels > Make your adjustments using the Format Data Labels pane.)
Once the data labels have been added, you can adjust the size, if needed, the way you would adjust the size of fonts in text. Depending on the type of data your chart illustrates, you may want additional label options. For example, it may be useful to show the Category Name, Value and Percentage. It just depends on the nature of your data and the purpose of your chart.
Provide the data in a tabular format (i.e. use the table that you used to create the chart). This benefits everyone because if you need to edit or copy the data later, tabular data is easier to edit.
Since Charts in Excel don’t have a place to add alt text for screen readers, you may add a description in the cell where the chart is located. Once you’ve typed the description, you may hide it visually by matching the text and background color (e.g. white text on white background).
Join us next week for some tips on adding hyperlinks.