Skip to main content
M
mjm101
Participant
October 24, 2019
Question

Adding Alt Text to Charts Converted From Word/Excel

  • October 24, 2019
  • 1 reply
  • 4005 views

I can't figure out how to add alt text to charts without getting accessibility errors. I'm converting Word docs to PDF, and the docs have embedded Excel charts.

 

If I enter the alt text in Word or Excel before converting, the Adobe screen reader reads it correctly, but I fail the "Nested alternative text" check. If I convert to PDF without the alt text, I don't get the error, but the screen reader recites the data without the necessary context. I tried converting the chart to a figure using Reading Order, so that I could add alt text in Adobe, but that only converted the chart area to a figure. I still had to deal with all the data points inside. The tags are below (when I converted it to a figure, the first <Span> was <Figure> instead). 

 

Is there an obvious solution I'm missing? I'll take a not-so-obvious one at this point, too.

This topic has been closed for replies.

1 reply

Bevi Chagnon - PubCom.com
Bevi Chagnon - PubCom.com
Legend
October 24, 2019

First, which method are you using to export the PDF from Word? Either:

  • Export from the Acrobat Ribbon in Word (aka, PDF Maker)
  • File / Save as Adobe PDF
  • File / Save As / PDF (Microsoft conversion)
  • File / Print / Adobe virtual printer (not recommended for tagged PDF)

Which version of Word are you using?

And which platform are you on?

|&nbsp;&nbsp;&nbsp;&nbsp;Bevi Chagnon &nbsp;&nbsp;|&nbsp;&nbsp;Designer, Trainer, &amp; Technologist for Accessible Documents ||&nbsp;&nbsp;&nbsp;&nbsp;PubCom |&nbsp;&nbsp;&nbsp;&nbsp;Classes &amp; Books for Accessible InDesign, PDFs &amp; MS Office |
M
mjm101Author
Participant
October 24, 2019

Thanks for responding. The problems I described above came when I exported with File / Save As / PDF (Microsoft). I also tried the other two (but not virtual printer). When I used those methods, the screen reader read the alt text, then also recited the chart data. Plus, I got more table errors that required cleanup, so I'd prefer to avoid those methods, if possible. The first method seemed to be cleanest export, except for this one major issue.

 

I'm using Word for Mac on an Office 365 subscription, updated to the latest version. 

Bevi Chagnon - PubCom.com
Bevi Chagnon - PubCom.com
Legend
October 24, 2019

Unfortunately, you're bumping up against the bleeding edge of the state-of-the-art.

The internal elements that make up charts (labels, axis numbers, pie/bar/line slices, etc.) are being tagged by various conversion utilities and picked up by screen readers. It's a nightmare for everyone.

 

Sure wish Adobe, Microsoft, and other software companies involved would correct this problem in the source document and let the screen reader get only the Alt-text on the entire figure, not read all the flotsam and jetsam of the individual chart parts.

 

How our shop handles this crud:

  1. Using the Content panel in Acrobat, locate all of the individual chart parts that we don't want announnced and artifact them. (Right-click on the element, Artifact \ Page element.)
  2. Leave one remaining element and add the Alt-text to it.
  3. If the document has a large number of charts, ensure that an equally large supply of your "substance of choice" is on hand to ameliorate the pain. (In our shop, it's jumbo lattes and double-espresso brownies.)

 

Some background behind this mess:

 

When you use File / Save As / PDF, you're using a Microsoft utility built into Word. Since the PDF file format has been a public standard for 10+ years, any company can make a PDF exporter/converter. And given that this is an Adobe forum, it's inappropriate for any of us to comment on what Microsoft does with its PDF converter.

 

In our shop, we mainly use PDF converters by Adobe because they give better results, in our experience. But sometimes with a particular document, or type of elements that are in the document, or the version of the software, another manufacturer's product does a better job. And sometimes it will do a better job on one type of element, like tables, but trash everything else.

 

We all are bumping up against the bleeding edge of the state-of-the-art.

|&nbsp;&nbsp;&nbsp;&nbsp;Bevi Chagnon &nbsp;&nbsp;|&nbsp;&nbsp;Designer, Trainer, &amp; Technologist for Accessible Documents ||&nbsp;&nbsp;&nbsp;&nbsp;PubCom |&nbsp;&nbsp;&nbsp;&nbsp;Classes &amp; Books for Accessible InDesign, PDFs &amp; MS Office |
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices