Bespoke Microsoft Office Development 
 Consultancy|

Excel

|Word|PowerPoint|Outlook|VBA|Tools|Newsletter 
 Excel > Charts< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Tabs - Design

Step By Step

 -

Tabs - Format

Step By Step

 -

Tabs - Layout (Removed 2013)

Step By Step

 -

Task Pane - Formatting (Added 2013)

Step By Step

 -

Chart Elements

Step By Step

 -

Chart Location

Step By Step

 -

Creating Charts

Step By Step

 -

Selecting Charts

Step By Step

 -

Formatting Charts

Step By Step

 -

Deleting Charts

Step By Step

 -

Copying Charts

Step By Step

 -

Moving Charts

Step By Step

 -

Resizing Charts


 

Chart Data Source

 
More Details

 -

Chart Data Source

More Details

 -

Chart Data Source - Range Indicator

More Details

 -

Chart Data Source - Hidden Empty

More Details

 -

Chart Data Source - Changing

More Details

 -

Chart Data Source - Complex


 

Chart Types

 
More Details

 -

Recommended Charts

More Details

 -

Chart Types

More Details

 -

Chart Types - Changing

More Details

 -

Chart Types - Default

More Details

 -

Chart Types - Templates

More Details

 -

Chart Types - Combination


 

Chart Axes

 
More Details

 -

Chart Axes

More Details

 -

Chart Axes - Value

More Details

 -

Chart Axes - Category Text

More Details

 -

Chart Axes - Category Dates

More Details

 -

Chart Axes - Category MultiLine


 

Advanced

 
More Details

 -

Naming Charts

More Details

 -

Printing Charts

More Details

 -

Finding Charts

More Details

 -

Chart Series Formula

More Details

 -

Advanced Techniques

More Details

 -

Version Changes

More Details

 -

Office Online

More Details

 -

Knowledge Base

More Details

 -

Knowledge Base - Numerical

More Details

 -

VBA Code


 

Shortcut Keys

 
 

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

 
 

(Alt + F1) - Creates a default chart on the active worksheet 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

 
GoTo

 -

Charts Advanced

GoTo

 -

Pivot Tables


 © Better Solutions Limited 02-Sep-2014Top