To create these charts you can add a chart to a sheet first, then select the table cells with the data you want to use. Or, you can select the cells first, then create a chart that displays the data. Either way, when you change the data in the table, the chart updates automatically. Want to generate a line chart in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda.

Tip • Excel automatically inserts a legend with default formatting at your selected location in the chart. You can then format the legend's font and change its location via the Legend Options panel. To access the Legend Options panel, start by clicking your chart to select it. Click the 'Charts' tab on the ribbon, click 'Chart Layout,' click the 'Legend' button, and then click 'Legend Options' to load a list of customizable options for your legend. Click the 'Font' tab to customize the font.

Click the 'Placement' tab to change where the legend appears on the chart.

Learn how to use Excel for Mac 2011 to create different kinds of charts—from column, bar, and line charts to Gantt and exploded pie charts—and understand how to decide which type works best for your data. Plus, find out how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Author Dennis Taylor also introduces analytical tools that will help you make sense of your data and a few dynamic controls that allow you to adapt your charts on the fly. Along the way, he provides tips and tricks to be more productive and efficient. Instructor •. Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training.

Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Dennis Taylor course • 4h 31m 16s • 1,413 viewers • Course Transcript - [Voiceover] Hi, I'm Dennis Taylor, and welcome to Excel for the Mac 2011: Charts in Depth.