Leading the way in Microsoft Office Development

Excel

Basic

 -

Getting Started

 -

Chart Wizard

 -

Chart Toolbar

 -

Items

 -

Options

 -

Location

 -

Selecting Charts

 -

Moving Charts

 -

Resizing Charts

 -

Printing Charts

Advanced

 -

Chart Types

 -

Chart Types - Changing

 -

Chart Types - Default

 -

Chart Types - Custom

 -

Source Data

 -

Source Data - Changing

 -

Source Data - Advanced

 -

Source Data - Data Series

 -

Chart Axes

 -

Chart Axes - Category

 -

Chart Axes - TimeSeries

 -

Formatting

 -

Formatting - Invert If Negative

 -

Formatting - 3D

 -

Formatting - Advanced

 -

Advanced Techniques

 -

Office Online

 -

Knowledge Base

Shortcut Keys

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

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

Tools > 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 Topics

 -

Charts Common Problems

 -

Pivot Tables