Excel 2013 Charts & Graphs

Intro to Chart Terminology
o Data Point vs. Data Series
o Axes
o Legend
o Plot Area
o Structuring worksheet data for charting
Creating a Chart
o As a New Sheet
o As an Embedded Chart
o Selecting Contiguous Cells
o Selecting Non-Adjacent Cells
Modifying a Chart
o Changing Chart Type
o Changing Chart Layout
o Changing Chart Styles
o Changing Source Data
▪ Viewing same data as different types of charts.
o Adding and Modifying Layout Elements of a Chart
▪ Data Labels
▪ Axis Labels
Formatting Charts
o Selecting Individual Elements of a Chart
o Text and Number Formatting
o Fill and Border Formatting

2-D Charts (X, Y Axis)
o Formatting and Modifying:
▪ Scale
▪ Trendlines
▪ Switching Rows and Column Data
3-D Charts (X, Y, Z Axis)
o Formatting and Modifying:
▪ Rotation
▪ Perspective
▪ Elevation
Adding Sparklines to a Data Range (Excel 2010 only)
o Line
o Columns
o Win-Loss
Saving Chart as a Template, and setting as default chart type.
Using Charts with Other Applications
(Word, PowerPoint, PDF, etc.)
o Copying
o Linking
o Updating

If you require interpreting services, please contact cpd@rit.edu as soon as possible.

Facilitator Information: 

New Horizons

See registration for details