Abstract
To my knowledge, there is little in the current spreadsheet literature discussing best practices with data visualization. There are many books on how to create pie charts, three-dimensional charts, and spider-charts, but few discuss why for each of these charts there is always a better choice available. I see why tutorials on these subjects are at first appealing; after all, the former charts are part of the Excel core package library. Therefore, to perhaps pass the Expert Microsoft Excel certification, knowing how to create these charts may be of service to you. However, for us, the developers and data consumers, these charts do more harm than good.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Colin Ware, Information Visualization: Perception for Design, Second Edition (Morgan Kaufmann, 2004)
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Jordan Goldmeier and Purnachandra Duggirala
About this chapter
Cite this chapter
Goldmeier, J., Duggirala, P. (2015). The Principles of Data Visualization in Microsoft Excel. In: Dashboards for Excel. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4945-0_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4945-0_3
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4944-3
Online ISBN: 978-1-4302-4945-0
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)