
School
of Business Administration
Decision and Information Sciences
421 N. Woodland Boulevard (Unit 8398)
386-822-7464
pgleason@stetson.edu
|
Excel 2007 Charting Workshop |
Key # |
Time |
|
Identifying the elements on a chart |
2:11 |
|
|
Selecting chart data in adjacent cells |
1:26 |
|
|
Selecting chart data in non-adjacent cells |
1:27 |
|
|
One step charting using the Chart Group buttons |
1:45 |
|
|
Working with tabs and ribbons in Excel |
2:15 |
|
|
Viewing a sample chart |
0:55 |
|
|
Creating column and bar charts |
1:06 |
|
|
Creating line charts |
0:52 |
|
|
Creating pie and doughnut charts |
1:26 |
|
|
Creating scatter and bubble charts |
1:22 |
|
|
Creating area charts |
0:47 |
|
|
Creating radar charts |
0:34 |
|
|
Creating surface charts |
1:40 |
|
|
Creating stock charts |
1:17 |
|
|
Creating a chart template |
1:33 |
|
|
Adding titles and labels |
1:35 |
|
|
Changing the chart type |
1:20 |
|
|
Formatting the chart area |
1:56 |
|
|
Adding a border and/or patterns to the plot area |
1:42 |
|
|
Formatting the axis properties |
2:28 |
|
|
Setting Format options for titles and labels |
1:18 |
|
|
Setting the placement and font for the legend |
1:27 |
|
|
Changing the data series |
1:34 |
|
|
Changing the data series pattern or marker |
3:01 |
|
|
Changing the shape of a 3D data marker |
1:03 |
|
|
Changing the plot order |
1:19 |
|
|
Resizing and repositioning |
1:25 |
|
|
Showing or hiding the data table |
0:47 |
|
|
Changing the gap width and gap depth values |
1:44 |
|
|
Changing the elevation and rotation |
2:03 |
|
|
Pulling out slices |
1:09 |
|
|
Using a graphic or picture |
1:49 |
|
|
Placing a chart on a separate chart sheet |
1:22 |
|
|
Printing your chart sheet |
1:50 |
|
|
Printing embedded charts |
1:56 |
|
|
Inserting a static copy of your chart |
1:33 |
|
|
Inserting a linked copy of your chart |
1:35 |
|
|
Saving your chart as a Web page |
1:43 |