In our book, we discuss the history and use of spreadsheets in accounting, chief amongst them Microsoft Excel. Management accountants in particular rely on the graphical depictions of data and information that Excel offers. However, all too often my Excel students in year 2 of their A&F programmes seem to be unsure what kind of chart type is best to illustrate what kind of information. In this blog post by Ryan Dube, he does not only explain when to use the most common chart types, but also provides hands-on examples on how they are to be created. It is highly recommended not only to have a good read, but also apply what he shows in Excel.
Home » Ch 10 - decision support with spreadsheet software » Do you know what chart type to use in Excel?
Business information systems for accounting students 