Working with accounting data in Excel: Excel 2013 charts

After looking into some of the more sophisticated reporting and analysis tools in Excel 2013, Simon Hurst goes back to basics with a tutorial on the spreadsheet program’s enhanced charting features.

So far in this series, we have been looking mainly at the process of linking to data and summarising and manipulating it, using PivotTables to produce the figures required for reporting. This time we will concentrate on the presentation of the data, particularly the use of Excel charts. Excel 2013 incorporates many changes to the tools used for working with charts as we shall see.

One of the issues with creating a chart is knowing which chart type and sub-type will do the best job of representing the data. Excel 2013 helps to narrow the choice by including a Recommended Charts option. As well as being included in the Insert ribbon tab, Charts group; the new Quick Analysis option also displays a restricted list of Recommended Charts...

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.