Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Rule 1: Always Label Everything

...

Warning

You now have a pie chart of your data, but it is inaccessible to some readers. Lots of important information is missing in this chart, like the percentage numbers for each sport. A color blind user may not be able to tell which section is dedicated to which sport. Other users may not be able to tell the colors apart or know what the chart is trying to show them.

A pie chart of the most popular sports with no numerical data visible.Image Removed

...

Tip

In the chart above, Data Labels were added to show readers the sports in each section and their percentage of popularity. Another good thing to do is check the sections color contrast ratio to the text.

A pie chart of the most popular sports with numerical data and labels visible.Image Removed

Rule 2: Charts and Graphs Must Not Rely on Color as the Only Way to Show Information

...

Warning

This graph has two lines that look similar with color being their only difference. A person who is color blind may not be able to tell the difference between the the lines.

A chart of airline flights per month, with the data lines having different colors.Image Removed

...

Tip

This graph has two lines that look different from each other. Now the reader will be able to tell which line is presenting the data they are reading.

A chart of airline flights per month, with the data lines having different colors and styles.Image Removed

Rule 3: All Charts and Graphs Must Have a Complete Description

...

Warning

There is no descriptive text. Readers will have a very hard time learning what is on the page or in the graph without a visual queue or description.

A bar graph of the number of MLB teams from 1950 to 2000 without a text description.Image Removed

...

Tip

The long description describes the bar graph down to the last detail. No information is left out and is easily readable for screen readers and will not confuse the reader.

A bar graph of the number of MLB teams from 1950 to 2000 with a text description.Image Removed

Section 5.2: Images

When making accessible images in Microsoft Excel, there are two types of images: Meaningful and Decorative. Meaningful images are images that have importance to a spreadsheet. Decorative images are meaningless images and only added to the spreadsheet for the purpose of making it look nice. Meaningful images require an alt text, while decorative images do not.

  1. To add Alternative Text, move your image next to Cell A1.

    An image of a collection of camera equipment. The image is selected.
  2. In Cell A1, type in the title or name for your spreadsheet.

  3. Type in content that is in the picture in the cells below Cell A1.

...

Tip

Our example shows the Alt Text from Cell A1 to A23. The list of things to pack describes what is in the photo.

A photography packing checklist with an image of the items to pack. The alt text is the list of items to the left of the image.Image Removed

...

Warning

The Fredonia label is meant to be decorative, so there is no need for the information in cell B2 to be there.

A worksheet with the Fredonia Logo and text SUNY Fredonia logo in cell B2Image Removed

...

Warning

The Alt Text is in the wrong place.

The alt text section in Microsoft Excel with Mark as Decorative checked.Image Removed

...

Tip

The text in cell B2 has been deleted and now the Fredonia image is considered decorative.

The Fredonia Logo is now labeled as decorative with no text in cell B2.Image Removed

Section 5.3: Using Embedded Files

...

Floating objects should not be used. This is because NVDA cannot read the inside of the floating object. If you do need to use them, you have to include a text alternative for the reader.

...

Warning

This spreadsheet does not have any alt text. Screen readers do not read smart art, so alternative text is needed.

The five steps of the Product Development Process as blue Word Art. No Text Alternative.Image Removed

...

Warning

This spreadsheet has a text alternative, but it is in the wrong place. Place the Alt Text in a cell next to the smart art.

The product development process shown as blue smart art. An Alt Text has been included to the right of the screen.Image Removed

...

Tip

Instead of placing the Alt Text in the Alt Text Panel, place it inside the cells next to the smart art.

The Product Development Process typed in a list next to the word art.Image Removed

Section 5.5: Watermarks and Backgrounds

...

Rule 1: Videos with dialogue must have a full transcript and captions

...

Warning

This link to a video only shows a link. There is no explanation for why it is there or what it is supposed to be.

Explore Fredonia Link in light blue.Image Removed

...

Tip

This worksheet has everything a reader would need to watch their video. It has a transcript to refer to, as well as instructions for how to access it.

An embedded file for video transcripts with a text description.Image Removed

Rule 2: Videos without dialogue must have a text description and audio description
Rule 3: Audio only elements must have a full transcript

...

Warning

There is no transcript provided.

Link to the History of Western Europe Lecture 3.Image Removed

...

Tip

There is both a link to the lecture and a transcript available to the student.

Link to History of Western Europe Lecture 3. A second link under it for a transcript of a lecture.Image Removed

Rule 4: If the video or audio element is embedded as an object, all of the rules for embedded files must be followed.

...