ICAEW.com works better with JavaScript enabled.
Exclusive

Exploring Charts in Excel

Author: Excel community

Published: 10 Feb 2021

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
How to use the many Chart options in Excel and apply the vast array of available graphical choices and features.

Building on the current twelve-part blog series, this webinar shows you how to use the many Chart options in Excel and apply the vast array of graphical choices and features that are available. We begin with a simple Sparkline, that provides a unique visual audit of data, through to multi-layered double axis Charts. Also, how to use the new Excel ‘ideas’ button that does much of the work for you. Along the way we cover axis bounds, axis positions, labels, stacking order, trend lines and the benefit of =NA. 

Charts can convey messages in management reports much more effectively than tables of data, particularly to people who have Numerophobia or a visual learning style.  

With an emphasis on clarity John Tennent takes you through the options.

Broadcast on 10 February 2021

Webinar resources

Allow StreamAMG video

This video is provided by StreamAMG. We ask for your permission before anything is loaded as they place a few cookies on our site. For more information on how we handle cookies, please see our privacy policy and cookies policy. To view this content on the website, please accept and continue.

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.

Excel polaroid
Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250