Charts

=Charts =



__**Practical Projects and Application for Excel **__
Complete an excel data source sheet with your monthly budget (total output). When it is complete, turn that data into a PIE chart. Complete an excel data source sheet with the x-axis as number of miles driven per day and the y-axis as days of the month. Create a chart and add a trend line. Keep track of wins/losses of NFL teams and compare them against each other.

media type="youtube" key="c70cjQXWkFI" height="315" width="560" align="center"



=More Charting Enhancements =

=Adding Some Spark to Your Spreadsheets =

Chart–Visual representation of numerical data

 * ===== Gets a message across =====
 * ===== Picture is worth a thousand words =====
 * ===== Numbers are boring =====

__**Chart Preparation **__

 * ===== Have a plan =====
 * ===== Determine the message =====
 * ===== What data =====
 * ===== What chart type =====
 * ===== What colors =====
 * ===== What descriptions =====

__**Creating a Chart **__

 * ===== Select the data source =====

** TIP **–Do not include totals

 * ===== Select the chart type and chart subtype =====
 * ===== Position and size the chart =====

Chart sheet–Contains a single chart and no spreadsheet data and no spreadsheet cells

Chart Tools contextual tab–Select a chart, Excel displays the Chart Tools contextual tab, containing the Design, Layout, and Format tabs. Use commands on these tabs to modify the chart

 * =====Chart Tools Design contextual tab contains options to modify the overall chart design=====
 * =====Chart Tools Layout contextual tab contains options to enhance charts by selecting specific chart elements, inserting objects, displaying or removing chart elements, customizing the axes, formatting the background, and including analysis=====
 * =====Chart Tools Format contextual tab contains options to modify the format of chart elements=====

Chart Tools Design tab

 * ===== Changing the chart type—use Change Chart Type button =====
 * ===== Changing the data source and structure—by default, Excel displays the row labels in the first column =====

** TIP –** Demonstrate Switch Row/Column button

 * ===== Applying a chart layout and a chart style =====
 * ===== Moving a chart =====

**__Printing Charts __**

 * ===== Print an embedded chart, with or without data =====
 * ===== Print a chart sheet =====

__**Chart Layout **__

 * ===== Add visual elements to enhance chart effectiveness not overpowering it =====
 * ===== Modify a chart by adjusting individual chart elements =====