Leading the way in Microsoft Office Development

Excel

Basic

 -

Getting Started

 -

Whats Changed in 2010

 -

Whats Changed in 2007

 -

Tabs - Design

 -

Tabs - Layout

 -

Tabs - Format

 -

Chart Shortcut Menu

 -

Chart Elements

 -

Chart Location

 -

Select Data

 -

Chart Series

 -

Selecting Charts

 -

Deleting Charts

 -

Copying Charts

 -

Moving Charts

 -

Resizing Charts

 -

Formatting Charts

 -

Printing Charts

Advanced

 -

Chart Toolbar and Menu

 -

Chart Wizard 2003

 -

Chart Options 2003

 -

Source Data

 -

Source Data - Advanced

 -

Chart Types

 -

Chart Types - Changing

 -

Chart Types - Default

 -

Chart Types - Custom

 -

Chart Axes

 -

Chart Axes - Category

 -

Chart Axes - TimeSeries

 -

Advanced Techniques

 -

Version Changes

 -

Office Online

 -

Knowledge Base

 -

Knowledge Base - Numerical

 -

VBA Code

Shortcut Keys

(F11) - Creates a default chart using the highlighted cells.

(Alt + F1) - Creates a default chart using the highlighted cells.

Options

(Chart tab, Plot empty cells as) - There are three choices: “Not Plotted” which ignores any blank cells and leaves gaps in the line: “Zero” which means blank cells are treated as zero, so the line drops to the zero-scale: “Interpolated” which means that any blank cells will have a connecting line meaning there are no gaps.

(Chart tab, Plot visible cells only) - If ticked will only plot visible cells and any hidden cells will not be plotted.

(Chart tab, Chart sizes with window frame) - This is only appropriate for charts on separate chart sheets, not for embedded charts.

(Chart tab, Show names) - Displays the item of the chart when you hover over it.

(Chart tab, Show values) - Displays the value of a data marker when you hover over it.

Related Sections

 -

Charts Advanced

 -

Pivot Tables