Versions Compared

Key

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

...

Section 6.1: Making Charts

Graphs and Charts are very helpful for displaying complex data for readers. If you make one, you need to make sure that they are fully labeled. A student using a screen reader will be able to get the information from a chart or graph, however, screen readers cannot provide a detailed description of a chart. That is something you will have to make yourself.

To make a chart or graph,

  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 percentageInsert 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. 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.

    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.

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.

    Alt Text section in Microsoft Excel that says, Equipment for a photographer needed to have high quality pictures.Image RemovedA photography packing checklist with an image of the items to pack. The alt text section of Microsoft Excel is open with Alt Text.Image Removed

...

Tip

Our example shows the Alt Text created inside the Alt Text panel on the right side of the screen.

...

Warning

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

...

Info

Remember that when you add embedded files, you should always include an explanation of the file and contents.

...

Tip

Cell A1 has an explanation of our new embedded file in Cell B1.

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

...