Charting to build summary reports, dashboards and to provide graphical presentation to be shared via PowerPoint are common tasks.  yet for many users, the process of getting a chart just right, is a somewhat hit and miss affair, especially if something out of the ordinary is required.

This session canvasses chart types, what they are useful for, how to layout the data to make building the charts as easy as possible and critical information on understanding how the charting engine works.  Solutions to issues when the data is not neatly arrayed is also presented and can save lots of lost time and pain.  A host of useful guidance on formatting, default options, advanced options and how to corral your charts is shared.  The use of Sparklines is covered,

And simple processes to organise and size charts, arrange them in sets and to copy or link them into PowerPoint are demonstrated.  This can save a lot of time and grief for users who struggle with these tasks on a weekly, monthly or less frequent cycle of reporting.

Users should have some basic familiarity with charts and be comfortable working with data in Excel.  Everything else you need to know will be taught in this lesson.