|
Microsoft Office Development and Consultancy |
| Home | | | Excel | | | VBA | | | C# | | | Finance | | | Tools | | | Newsletter | | | Feedback | | | Contact |
| Excel > Charts | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| Step By Step | - | Tabs - Design |
| Step By Step | - | Tabs - Layout |
| Step By Step | - | Tabs - Format |
| Step By Step | - | Chart Elements |
| Step By Step | - | Chart Location |
| Step By Step | - | Selecting Charts |
| Step By Step | - | Finding 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 | - | Chart Types |
| More Details | - | Chart Types - Changing |
| More Details | - | Chart Types - Default |
| More Details | - | Chart Types - Templates |
Chart Axes |
| More Details | - | Chart Axes |
| More Details | - | Chart Axes - Value |
| More Details | - | Chart Axes - Category Dates |
| More Details | - | Chart Axes - Category Text |
| More Details | - | Chart Axes - Category MultiLine |
Advanced |
| More Details | - | Naming Charts |
| More Details | - | Formatting Charts |
| More Details | - | Printing 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 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 |
| GoTo | - | Charts Advanced |
| GoTo | - | Pivot Tables |
| © Better Solutions Limited 10-May-2013 | Top |