Charts - Charts Charts Two basic placements of charts...

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

View Full Document Right Arrow Icon
Charts Charts Two basic placements of charts within a workbook o Embedded charts are objects within another worksheet o Chart sheets Dynamically update based on changes in underlying data To change a chart from an embedded chart to a chart sheet o Chart Tools – Design – Location – Move Chart Charts are composed of multiple objects Objects within a chart (Figure 7-3 within the textbook) Chart basics Types of charts Moving/resizing charts Deleting charts Selecting chart objects (mouse, keyboard, and ribbon) Data Source If you add a row within the current data series, the chart will automatically update If you add a row to the beginning or end of a data series, you will need to modify the data series in order for the chart to update Printing charts If the chart object is selected, that is the only part of the worksheet that will be printed To print a worksheet without printing charts o Chart Tools – Format – Current Selection – Chart Area – Format Selection – Properties (deselect “Print object”) Chart distortion Pie charts – rotation Line charts – axis ranges Sparklines Creates a miniature chart within a single cell
Background image of page 1

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

View Full DocumentRight Arrow Icon
Design tab (Chart Tools) Change chart type Select data o Can change the data used in a chart and modify the series names (can also edit or delete series/data) Chart Layouts o Allows you to choose preset layouts based on the chart type that is currently selected Chart Styles o Allows you to change the style used for certain chart elements Location o Allows you to move the location of a chart, including moving it to a chart sheet Layout tab (Chart Tools) Current Selection o Shows all chart elements/objects o Format Selection – allows you to format the selected chart element/object Labels o Chart title Can reference to a cell (select the chart title, not the text within the title) o Axis titles o Legend (generally not needed for charts with only a single data series) o Data labels – provides the actual data amounts for each data point o Data table – provides a summary of the actual data within the chart Axes o Can make changes to the axes and gridlines Background o Plot area – the actual area on which the data is charted (the chart area is the entire chart object)
Background image of page 2
Pies Worksheet Create a chart o Click within the data set o Insert – Charts (select Clustered Column) Change data o Chart Tools – Design – Data – Select Data (remove cells A1 and A2 from the data included for the chart) Chart title o Delete the current text o Select the chart title textbox (not the text itself) and set equal to the title in cell A1
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/02/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 8

Charts - Charts Charts Two basic placements of charts...

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

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