Excel 2010: Charts in Depth

Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately. Topics include: Identifying the plot area, chart area, gridlines, legends, and more Selecting the right chart type Creating charts instantly with shortcuts Choosing a layout Dealing with empty and hidden cells Switching rows and columns for a different view of the data Moving and resizing a chart Inserting pictures and shapes Adding labels to a chart Analyzing existing and future data with trendlines Changing a chart's data source Printing charts