text.skipToContent text.skipToNavigation
  1. Home
  2. Business & Economics
  3. FT Press
  4. Excel 2013 Charts and Graphs

Excel 2013 Charts and Graphs, 1st edition

  • Bill Jelen

Published by Que Publishing (February 14th 2013) - Copyright © 2013

1st edition

Chosen format
View all
Excel 2013 Charts and Graphs

ISBN-13: 9780789748621

Includes: Paperback
Free delivery
$39.99

What's included

  • Paperback

    You'll get a bound printed text.

Overview

Table of contents

Introduction: Using Excel 2013 to Create Charts .................. 1

Choosing the Right Chart Type ...........................................1

Using Excel as Your Charting Canvas ...............................2

Topics Covered in This Book ........................................3

This Book’s Objectives ...............................4

    Versions of Excel ...................................................4

    Conventions Used in This Book ......................................4

    Special Elements in This Book .................................................4

Next Steps.................................................5

 

1 Introducing Charts in Excel 2013 ............................... 7

What’s New in Excel 2013 Charts ........................................................7

Choosing Among the Three Ways to Create a Chart ........................10

    Creating a Chart from the Quick Analysis Icon .........................................10

    Inserting a Recommended Chart .................................................................11

    Creating a Chart Using the Other Icons on the Insert Tab ......................14

    Creating a Chart Using Alt+F1 ............................................................15

Changing the Chart Title ................................................................16

    Editing a Title in the Formula Bar ...............................................16

    Why Can’t Excel Pick Up the Title from the Worksheet? ...............17

    Assigning a Title from a Worksheet Cell ......................................18

Handling Special Situations ....................................................19

    Charting Noncontiguous Data .........................................................19

    Charting Nonsummarized Data ............................................22

    Charting Differing Orders of Magnitude Using a Custom Combo Chart .............23

    Reversing the Series and Categories in a Chart ...............................24

    Changing the Data Sequence by Using Select Data ........................25

For teachers

All the material you need to teach your courses.

Discover teaching material