Post Description

In Excel 2007: Charts in Depth, Dennis Taylor shows how to analyze and communicate 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. Exercise files are included with the course.
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