Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Charts< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Chart Wizard

Step By Step

 -

Chart Toolbar

Step By Step

 -

Items

Step By Step

 -

Options

Step By Step

 -

Location

Step By Step

 -

Selecting Charts

Step By Step

 -

Moving Charts

Step By Step

 -

Resizing Charts

Step By Step

 -

Printing Charts


 

Advanced

 
More Details

 -

Chart Types

More Details

 -

Chart Types - Changing

More Details

 -

Chart Types - Default

More Details

 -

Chart Types - Custom

More Details

 -

Source Data

More Details

 -

Source Data - Changing

More Details

 -

Source Data - Advanced

More Details

 -

Source Data - Data Series

More Details

 -

Chart Axes

More Details

 -

Chart Axes - Category

More Details

 -

Chart Axes - TimeSeries

More Details

 -

Formatting

More Details

 -

Formatting - Invert If Negative

More Details

 -

Formatting - 3D

More Details

 -

Formatting - Advanced

More Details

 -

Advanced Techniques

More Details

 -

Office Online

More Details

 -

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

 
GoTo

 -

Charts Common Problems

GoTo

 -

Pivot Tables


 Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top