Versions Compared

Key

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

...

  1. After you have a created your data for a chart, highlight your data and select the Insert Tab.

    A table showing the most popular sports by percentageImage RemovedA table showing the most popular sports by percentageImage AddedInsert Tab in Excel
  2. In the Chart section, click the Pie Chart Icon. Select the chart you would like to use.

    Pie Chart Button in Excel
  3. You now have a pie chart of your data, but it is inaccessible to some readers. In our example, we have a chart for the “Most Popular Sports in the USA.” Lots of important information is missing in this chart. The percentage information is missing. 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 RemovedA pie chart of the most popular sports with no numerical data visible.Image Added

    4. To make the pie chart accessible to all readers, click on the chart and click the plus sign in the top right corner. This will allow you to modify your chart and add information. In the chart below, 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 RemovedA pie chart of the most popular sports with numerical data and labels visible.Image Added

Rules for Accessible Charts

...

  1. To add Alternative Text, click your image.

    A collection of camera equipment.
  2. Go to the Picture Format Tab, then click the Accessibility Button.

    Picture format button in Excel.Alternative Text button in Microsoft Excel.
  3. In the Alt Text panel, explain your image in 150 characters or less. If this image is supposed to be decorative, just click the check box.

...

  1. Alt Text section in Microsoft Excel that says, Equipment for a photographer needed to have high quality pictures.Image AddedA photography packing checklist with an image of the items to pack. The alt text section of Microsoft Excel is open with Alt Text.Image AddedA worksheet with the Fredonia Logo and text SUNY Fredonia logo in cell B2Image Added
Warning

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

...

Section 6.4: Word Art, Smart Art, Text Boxes, and other Floating Objects

When using any of these floating objectsFloating 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 if there is any important informationfor the reader.

...

Warning

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

...