Can we create accessible charts with Microsoft Excel?: a review of possibilities and limits, with a special focus to users with low vision
Article No.: 2, Pages 1 - 13
Abstract
Introduction: statistical charts are key to data literacy and essential in the process of communicating abstract science concepts and relationships that are difficult to understand through other representations. These types of visualization can present numerous challenges for users with low vision, an often-overlooked group despite its enormous prevalence. To evaluate MS Excel's as an accessible authoring tool analyzing ATAG 2.0 compliance, and its capability to create accessible charts according to a set of heuristic indicators proposed by the authors. Methodology: Evaluate a) the compliance of Microsoft Excel software as an authoring tool with ATAG 2.0 guidelines; and b) the compliance of MS Excel-generated charts with a domain heuristic set. For the heuristic evaluation, apart from the original MS Excel chart (XSLX), three exported versions (DOCX, HTML and SVG) of the same chart were created using all the accessibility features available in the software. Results: Regarding ATAG compliance, 48 desired accessibility features applying to MS Excel have been identified and the software meet just 26 of them (54.17%). Regarding heuristic evaluation, the four versions of the chart present a percentage of compliance with the heuristics equal to or greater than 66.66%. The versions that have obtained the best scores are MS Excel original and MS Word exported charts with 72.2% of indicators achieved, followed by SVG and HTML exported charts, both with 66.66%. Even though MS Excel does not meet a good part of the ATAG 2.0 success criteria, it has been possible to create charts with a good level of accessibility following the suggested heuristic principles.
References
[1]
Jake Carlson and Lisa R. Johnston, 2015. Data information literacy: librarians, data, and the education of a new generation of researchers. Purdue University Press, West Lafayette, Indiana, 15.
[2]
Karen Hunt. 2004. The challenges of integrating data literacy into the curriculum in an undergraduate institution. IASSIST quarterly 28, 2-3, 12–15. https://iassistquarterly.com/public/pdfs/iqvol282_3hunt.pdf
[3]
Pedro Arteaga, Carmen Batanero, Gustavo Cañadas and Miguel Contreras. 2010. Las tablas y gráficos estadísticos como objetos culturales. Números: revista de didáctica de las matemáticas 76, 55–67. http://www.sinewton.org/numeros/numeros/76/Articulos_02.pdf
[4]
Yolanda Postigo and Juan Ignacio Pozo. 2000. Cuando una gráfica vale más que 1000 datos: la interpretación de gráficas por alumnos adolescentes. Infancia y aprendizaje, 90, 89–110. http://dx.doi.org/10.1174/021037000760087982
[5]
Rupert Bourne, Seth Flaxman, Tasanee Braithwaite, T, 2017. Magnitude, temporal trends, and projections of the global prevalence of blindness and distance and near vision impairment: a systematic review and meta-analysis. Lancet global health 5, 9, 888-897. https://doi.org/10.1016/s2214-109x(17)30293-0
[6]
WebAIM. 2013. Visual disabilities. Page 3. Low vision. Retrieved March 11, 2024 from https://webaim.org/articles/visual/lowvision. Accessed 24 January 2024.
[7]
C Bruce Warner and Anita M. Meehan. 2001. Microsoft MS Excel as a tool for teaching basic statistics. Teaching of psychology, 25, 4, 295–298.
[8]
W3C. 2023. Web Content Accessibility Guidelines (WCAG) 2.2. Retrieved March 11, 2024 from https://www.w3.org/TR/WCAG22
[9]
Rubén Alcaraz-Martínez, Mireia Ribera and Toni Granollers. 2021. Methodology for heuristic evaluation of the accessibility of statistical charts for people with low vision and color vision deficiency. Univers Access Inf Soc. https://doi.org/10.1007/s10209-021-00816-0
[10]
Frank Elavsky, Cynthia Bennett and Dominik Moritz. 2022. How accessible is my visualization? evaluating visualization accessibility with Chartability. Computer Graphics Forum 41, 3, 57–70. https://doi.org/10.1111/cgf.14522
[11]
Rubén Alcaraz-Martínez, Mireia Ribera, Toni Granollers Saltiveri and Afra Pascual Almenara.2020. Accesibilidad para personas con baja visión de los gráficos estadísticos en la prensa digital: una propuesta metodológica basada en indicadores heurísticos. Prof Inf 29, 5. https://doi.org/10.3145/epi.2020.sep.15
[12]
Rubén Alcaraz-Martínez and Mireia Ribera. 2020. An evaluation of accessibility of COVID-19 statistical charts of governments and health organisations for people with low vision. Prof Inf 29, 5. https://doi.org/10.3145/epi.2020.sep.14
[13]
Rubén Alcaraz-Martínez, Mireia Ribera, Jordi Roig, Afra Pascual and Toni Granollers Saltiveri. 2021. Accessible charts are part of the equation of accessible papers: a heuristic evaluation of the highest impact LIS journals. Library Hi-Tech. https://doi.org/10.1108/LHT-08-2020-0188
[14]
Rubén Alcaraz-Martínez, Mireia Ribera, Adrià Adeva Fillol and Afra Pascual. 2022. Validation of a heuristic set to evaluate the accessibility of statistical charts: a user test with low vision persons. In Interacción '22: Proceedings of the XXII International Conference on Human Computer Interaction. https://doi.org/10.1145/3549865.3549893
[15]
W3C. 2015. Authoring Tool Accessibility Guidelines (ATAG) 2.0. Retrieved March 11, 2024 from https://www.w3.org/TR/ATAG20
[16]
Jim Allan, Andrew Kirkpatrick, and Shawn Lawton Henry, 2019. Accessibility requirements for people with low vision. W3C World Wide Web Consortium, Editor's Draft. W3C. Retrieved March 11, 2024 from https://w3c.github.io/low-vision-a11y-tf/requirements.html
[17]
Juan Miguel López, Afra Pascual, Llucia Masip, Toni Granollers and Xavier Cardet. 2011. Influence of web content management systems in web content accessibility. In P. Campos (eds.). Human-Computer Interaction – INTERACT 2011. Lecture notes in computer science, 6949. Springer, Berlin, Heidelberg. http://dx.doi.org/10.1007/978-3-642-23768-3_79
[18]
Rocío Calvo, Ana Iglesias and Lourdes Moreno. 2012. Is Moodle accessible for visually impaired people? In Filipe, J, Cordeiro, J (eds.). Web Information Systems and technologies 7th International Conference, WEBIST 2011, Noordwijkerhout, 207–220. http://dx.doi.org/10.1007/978-3-642-28082-5_15
[19]
Ana Iglesias, Lourdes Moreno, Paloma Martínez and Rocío Calvo. 2014. Evaluating the accessibility of three open-source learning content management systems: a comparative study. Computer applications in engineering education 22, 2, 320–328. http://dx.doi.org/10.1002/cae.20557
[20]
Jorge Villarroel-Ramos, Sandra Sanchez-Gordon and Sergio Luján Mora. 2018. Architectural metamodel for requirements of images accessibility in online editors. In 2018 International Conference on Information Systems and Computer Science (INCISCOS), 312–319. https://doi.org/10.1109/INCISCOS.2018.00052
[21]
William W. Cohen, Richard Wang and Robert F. Murphy. 2003. Understanding captions in biomedical publications. In Proc of the ninth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, 499–504. https://doi.org/10.1145/956750.956809
[22]
Stephanie Elzer, Sandra Carberry, Daniel Chester, Seniz Demir, Nancy Green, Ingrid Zukerman and Keith Trnka. 2007. Exploring and exploiting the limited utility of captions in recognizing intention in information graphics. In Proceedings of the 43rd Annual Meeting of the Association for Computational Linguistics (ACL’05), 223–230.
[23]
Hong Yu, Shashank Agarwal, Mark Johnston and Aaron Cohen. 2009. Are figure legends sufficient? evaluating the contribution of associated text to biomedical figure comprehension. Journal of biomedical discovery and collaboration 4, 1. http://dx.doi.org/10.1186/1747-5333-4-1
[24]
Stephanie Evergreen and Chris Metzner. 2013. Design principles for data visualization in evaluation. In Azzam, T., & Evergreen, S. (Eds.). Data visualization, part 2. New directions for evaluation 2013, 140, 5–20.
[25]
W3C. 2020. Understanding Success Criterion 3.1.4: Abbreviations. Retrieved March 11, 2024 from https://www.w3.org/WAI/WCAG21/Understanding/abbreviations.html
[26]
Marja-Riitta Koivunen and Charles McCathieNevile. 2001. Accessible graphics and multimedia on the Web. World Wide Web Consortium (W3C)/MIT. Retrieved March 11, 2024 from https://www.w3.org/2001/05/hfweb/heuristics.htm
[27]
Giorgio Brajnik. 2011. Barrier walkthrough. Retrieved March 11, 2024 from https://people.uniud.it/node/3465
[28]
Bruno Splendiani. 2015. A proposal for the inclusion of accessibility criteria in the authoring workflow of images for scientific articles. Dissertation, University of Barcelona. http://hdl.handle.net/10803/386242
[29]
W3C. 2019. Complex images. In Web accessibility tutorials: guidance on how to create websites that meet WCAG. Retrieved March 11, 2024 from https://www.w3.org/WAI/tutorials/images/complex
[30]
HK Ault, JW Deloge, RW Lapp, MJ Morgan and JR Barnett. 2002. Evaluation of long descriptions of statistical graphics for blind and low vision web users. In 8th International Conference, ICCHP 2002, 517–526.
[31]
DIAGRAM Center. 2015. Image description guidelines. Retrieved March 11, 2024 from http://diagramcenter.org/table-of-contents-2.html.
[32]
Katharina Reinecke, David R. Flatla and Cristhopher Brooks. 2016. Enabling designers to foresee which colors users cannot see. In Proceedings of the 2016 CHI Conference on Human Factors in Computing Systems (CHI’16). ACM, New York, NY, USA, 2693–2704. https://doi.org/10.1145/2858036.2858077
[33]
Mario Konecki, Charles LaPierre, Sue-Ann MA and Jerry Berrier. 2017. Providing accessible data visualization. In Proceeding of IAC in Vienna 2017, 159-162. https://publications.hse.ru/mirror/pubs/share/direct/213104122
[34]
W3C. 2020. Understanding Success Criterion 1.4.3: Contrast (Minimum). Retrieved March 11, 2024 from https://www.w3.org/WAI/WCAG21/Understanding/contrast-minimum.html
[35]
W3C. 2020. Understanding Success Criterion 1.4.11: Non-text Contrast. Retrieved March 11, 2024 from https://www.w3.org/WAI/WCAG21/Understanding/non-text-contrast.html
[36]
Michael Bernard, Chia Hui Liao and Melissa Mills. 2001. The effects of font type and size on the legibility and reading time of online text by older adults. In Proc of the ACM/SIGCHI Conference on Human Factors in Computing Systems (CHI2001), 175–176. http://dx.doi.org/10.1145/634067.634173
[37]
Gary S. Rubin, Mary Feely, Sylvie Perera, Katherin Ekstrom and Elizabeth Williamson. 2006. The effect of font and line width on reading speed in people with mild to moderate vision loss. Ophthalmic and physiological optics 26, 6, 545–554. https://doi.org/10.1111/j.1475-1313.2006.00409.x
[38]
Gordon E. Legge. 2016. Reading digital with low vision. Visible Lang 50, 2, 102-125.
[39]
Elizabeth Russell-Minda, Jeffrey W. Jutai, J. Graham Strong, Kent A. Campbell, Deborah Gold, Lisa Pretty and Lesley Wilmot. 2007. The legibility of typefaces for readers with low vision: a research review. Journal of visual impairment & blindness 101, 7, 402–415. https://doi.org/10.1177%2F0145482X0710100703
[40]
Aurélie Calabrèse, Jean-Baptiste Bernard, Louis Hoffart, Géraldine Faure, Fatiha Barouch, John Conrath and Eric Castet. 2010. Small effect of interline spacing on maximal reading speed in low-vision patients with central field loss irrespective of scotoma size. Investigative ophthalmology & visual science 51, 2, 1247–1254. https://doi.org/10.1167/iovs.09-3682
[41]
Charles McCathieNevile and Marja-Riitta Koivunen. 2000. Accessibility features of SVG. W3C. Retrieved March 11, 2024 from https://www.w3.org/TR/2000/NOTE-SVG-access-20000807
[42]
W3C. 2020. Understanding Success Criterion 2.4.7: Focus Visible. Retrieved March 11, 2024 from https://www.w3.org/WAI/WCAG21/Understanding/focus-visible.html
[43]
Loretta Guarino and Andi Snow-Weaver. 2009. WCAG 2.0 for designers: beyond screen readers and captions. In Stephanidis, C. (eds). Universal Access in Human-Computer Interaction. Applications and Services. UAHCI 2009. Lecture Notes in Computer Science, 5616. Springer, Berlin, Heidelberg, 674-682. https://doi.org/10.1007/978-3-642-02713-0_71
[44]
W3C. 2020. Understanding Success Criterion 2.1.1: Keyboard. Retrieved March 11, 2024 from https://www.w3.org/WAI/WCAG21/Understanding/keyboard.html
Index Terms
- Can we create accessible charts with Microsoft Excel?: a review of possibilities and limits, with a special focus to users with low vision
Recommendations
Validation of a heuristic set to evaluate the accessibility of statistical charts
Interacción '22: Proceedings of the XXII International Conference on Human Computer InteractionA remote user test was performed with two versions (one accessible and another one non-accessible) of three types of web-based charts (horizontal bar chart, vertical stacked bar chart, and line chart). The objectives of the test were a) to validate a ...
Comments
Information & Contributors
Information
Published In
![cover image ACM Other conferences](/cms/asset/cfa41421-6864-4156-856e-dedcaa96c0bc/3657242.cover.jpg)
June 2024
155 pages
ISBN:9798400717871
DOI:10.1145/3657242
Copyright © 2024 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 19 June 2024
Check for updates
Author Tags
Qualifiers
- Research-article
- Research
- Refereed limited
Conference
INTERACCION 2024
Acceptance Rates
Overall Acceptance Rate 109 of 163 submissions, 67%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 10Total Downloads
- Downloads (Last 12 months)10
- Downloads (Last 6 weeks)5
Reflects downloads up to 01 Sep 2024
Other Metrics
Citations
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign inFull Access
View options
View or Download as a PDF file.
PDFeReader
View online with eReader.
eReaderHTML Format
View this article in HTML Format.
HTML Format