Ch4ClassNotes_sp11

Ch4ClassNotes_sp11 - Chapter 4: Excel Charts Chapter Skills...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 4: Excel Charts Chapter Skills Identify the appropriate chart type for a set of data. o Column chart (including clustered column and stacked column charts) o Bar chart (including stacked bar chart) o Line chart o Scatter chart o Pie chart Arrange source data so that chart data will be correctly identified. Arrange source data to maximize the effectiveness of a particular chart type. Copy and paste Excel charts into a MS Word document (or PowerPoint presentation). Embed an Excel chart into a MS Word document (or PowerPoint presentation). Into a MS Word document (or PowerPoint presentation), paste a link to an Excel chart. Use the chart context ribbon tabs to format charts. Chapter Vocabulary chart data point Parts of a chart ("chart objects"): o Chart title o Value axis o Category axis o Axis labels o Axis titles o Chart legend o Gridlines o Chart area o Plot area o Data markers Context ribbon tabs (for charts) Arranging Chart Data In order for Excel to properly locate the correct data for a chart, the data must be organized according to a few basic rules: 1. The range must be contiguous in that there can be no blank columns or rows in the table of data. 2. There must be no data stored in cells adjacent to the list. A blank column and a blank row should separate the table from all other data on the worksheet. (There may be blank cells in the table, but just not a complete blank row or column.) 3. Column headers must be formatted differently from the data. 4. In most cases, you should remove any calculated totals from the table, or make sure those are not included in the source data you have identified for the list. (In most cases, charts include either detailed data or summary data, but not a mixture of the two 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
types of data.) Chapter Demonstration 1: Creating a Column Chart 1. Open the practice file, ChartPractice.xlsx . Select the worksheet named Column . 2. Select a cell in the table of data (Excel automatically selects the source data if it is structured correctly). Select Insert(tab) Column (chart) . Select the first type of column chart listed. 3. What can you do to emphasize the portion of managers to staff for each department? Make a 100% stacked column chart.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/21/2011 for the course ACIS 2504 taught by Professor Mtgriffin during the Spring '08 term at Virginia Tech.

Page1 / 5

Ch4ClassNotes_sp11 - Chapter 4: Excel Charts Chapter Skills...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online