Create accessible tables from data sets
Tables can help you identify a set of data by name, or apply a more polished format that makes that data stand out. By carefully naming and formatting your table you can be sure that everyone can understand your data. This includes those with low vision or users of screen reading software.
To turn your Excel data into a table:
- select any cell within your data set
- on the ribbon, select Insert and then Table
- drag the highlighted selection to adjust or redefine the cell range
- select ‘My table has headers’
This is important for accessibility, because screen readers use table headers to navigate.
To give your table a descriptive name:
- click anywhere in the table and select the Design tab
- under Table Name, replace the generic name ‘Table_1’ with a more descriptive one
With a descriptive name, you can now jump to the table using the ‘Go To’ command or the ‘Name’ box. You can also refer to the table in formulas.
A meaningful table name like “EmployeeList” is more helpful than the generic “Table1” or a table reference code such as: $A$3:$D$16.
Certain table formats can be hard on people with low vision, so be sure to choose a format with good contrast and readability.
Here are some tips to optimise your table for accessibility using the Design tab:
- Excel includes Header rows by default, because they are essential for accessibility
- to make the labels in the first column stand out more, select First Column and then choose Banded rows. This makes the separation between rows more visible
- there are lots of table styles to choose from. Lighter coloured tables with low contrast can be hard for anyone to read, but it’s even harder for people with low vision. Styles that alternate between white and a dark colour – such as black, dark grey or dark blue – provide a strong contrast that makes a table more accessible
- to make sure the text inside a table is readable, you can adjust the font, row and column size. To do this go to the Home tab, select Font Size and increase the point size up to 14
- make sure there’s enough space around the text to keep it from looking crowded. Users with dyslexia can find crowded text especially tough to read (under Format, select Row Height and increase it to 30. This makes the rows a little taller)
- if the text is still too big to fit in the cells comfortably, select the columns and click Format again
- choose AutoFit Column Width then add a little more white space manually by dragging the column dividers outwards
- it is good practice to increase the font size and embolden the title of your table, to make it stand out, much like a ‘Header 1’ element
Create accessible charts
The charts and graphs you create in Excel help make complex information easier to understand. To make this visual information accessible for those with low vision you need to use words carefully. This way people with low vision can understand what others see. If you label chart elements with care and include Alt Text, all users will better understand the data.
Create a chart from your data table
- Select the data you want to use for the chart.
- Click on the Insert tab.
- Select a Chart Type from the available options.
Making chart elements accessible
Select the generic chart title – ‘Chart 1’ – and replace it with a meaningful title.
Add Axis titles
- Select the chart, and click on Design > Add Chart Element > Axis Titles.
- Select Primary Horizontal or Primary Vertical.
- In the chart, select the new Axis Title field and type a title that clearly describes the axis.
Add Data labels
- Select the chart, and then click on Design > Add Chart Element > Data Labels.
- Choose Outside End.
Data label format
- Select the horizontal or vertical axis.
- Choose Format > Current Selection > Format Selection.
- On the Format Axis pane, set options to adjust the format and legibility of the axis. Options include the axis type, axis crosses, position, tick marks, label position, interval and number format.
Use light-coloured text on a dark background (or dark text on a light background) and apply a simple, sans serif font that is 12 points or larger.
To do this:
- select the chart text that you want to change
- click on the Home tab and change the Font, Font Size, Font Colour and other attributes
Add Alt Text
- Right-click the chart and select Format Chart Area.
- Select Size & Properties > Alt Text.
- Add a meaningful Title and Description.
After adding these elements, your charts will communicate better visually and to users with low vision or screen readers.