Que.Charts.and.Graphs.for.Microsoft.Office资源-CSDN文库

需积分: 9 80 浏览量 2014-08-19 01:19:20 上传评论收藏 19.77MB PDF 举报

资源详情

资源评论

www.sharexxx.net - free books & magazines

Charts and Graphs for Microsoft

Office Excel

2007

or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise,

without written permission from the publisher. No patent liability is assumed with respect

to the use of the information contained herein. Although every precaution has been taken in

the preparation of this book, the publisher and author assume no responsibility for errors or

omissions. Nor is any liability assumed for damages resulting from the use of the informa-

tion contained herein.

International Standard Book Number: 0-7897-3610-1

Library of Congress Cataloging-in-Publication Data

Jelen, Bill.

Charts and graphs for Microsoft Office Excel 2007 / Bill Jelen.

p. cm.

ISBN 0-7897-3610-1

1. Microsoft Excel (Computer file) 2. Business—Computer

programs. 3. Electronic spreadsheets. 4. Charts, diagrams, etc.—

Computer programs. I. Title.

HF5548.4.M523J447 2007

005.54—dc22

2007004763

Printed in the United States of America

First Printing: April 2007

10090807 4321

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks have

been appropriately capitalized. Que Publish-ing cannot attest to the accuracy of this infor-

mation. Use of a term in this book should not be regarded as affecting the validity of any

trademark or service mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but

no warranty or fitness is implied. The information provided is on an “as is” basis. The

author and the publisher shall have neither liability nor responsibility to any person or entity

with respect to any loss or damages arising from the information contained in this book or

from the use of the CD or programs accompanying it.

Bulk Sales

Que Publishing offers excellent discounts on this book when ordered in quantity for bulk

purchases or special sales. For more information, please contact

U.S. Corporate and Government Sales

1-800-382-3419

corpsales@pearsontechgroup.com

For sales outside of the U.S., please contact

International Sales

international@pearsoned.com

Associate Publisher

Greg Wiegand

Acquisitions Editor

Loretta Yates

Development Editor

Laura Norman

Managing Editor

Gina Kanouse

Project Editor

Michael Thurston

Copy Editor

Kitty Jarrett

Indexer

Cheryl Lenser

Proofreader

Water Crest Publishing

Technical Editors

Juan Pablo Gonzalez

Bob Umlas

Publishing Coordinator

Cindy Teeters

Book Designer

Anne Jones

Composition

Gloria Schurick

Contents
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Choosing the Right Chart Type  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2
Using Excel as Your Charting Canvas  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
This Book’s Objectives  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4
A Note About Bugs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Special Elements in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Next Steps  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6
1 Introducing Charts in Excel 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
What’s New in Excel 2007 Charts  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
New Charting Tools and Menus  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8
Using the Insert Tab to Select a Chart Type  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
Using the Expand Icon to Access a Gallery of All Chart Types  . . . . . . . . . . . . . . . . . . . .10
Understanding the Chart Thumbnail Icons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
Using Gallery Controls  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13
Creating a Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14
Selecting Contiguous Data to Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14
Selecting Noncontiguous Data to Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Creating a Chart by Using the Insert Ribbon Icons  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Creating a Chart with One Keystroke  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Working with Charts  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Moving a Chart Within the Current Worksheet  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Locating a Chart at the Top of Your Dataset . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19
Reversing the Series and Categories of a Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .20
Changing the Data Sequence by Using Select Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21
Leaving the Top-Left Cell Blank . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .23
Moving a Chart to a Different Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24
Customizing a Chart by Using the Design Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Choosing a Chart Layout  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Choosing a Color Scheme  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .26
Modifying a Color Scheme by Changing the Theme . . . . . . . . . . . . . . . . . . . . . . . . . . . .27
Creating Your Own Theme  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28
Choosing Effects for a Custom Theme from an Existing Theme  . . . . . . . . . . . . . . . . . .29
Understanding RGB Color Codes  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .30
Converting from Hexadecimal to RGB  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .30
Finding Complementary Colors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .31
Specifying a Theme’s Colors  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32
Specifying a Theme’s Fonts  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .33
Saving a Custom Theme  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .34
Using a Custom Theme on a New Document  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35
Sharing a Theme with Others  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35
Next Steps  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35

2 Customizing Charts  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Accessing Element Formatting Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Identifying Chart Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38
Chart Labels and Axis  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38
Special Elements in a 3-D Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40
Analysis Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40
Formatting Chart Elements  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Formatting a Chart Title . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .42
Formatting an Axis Title  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44
Formatting a Legend  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45
Adding Data Labels to a Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .48
Adding a Data Table to a Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .50
Formatting Axes  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .51
Using a Date-Based Axis to Represent Time  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56
Displaying and Formatting Gridlines  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59
Formatting the Plot Area  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .61
Creating a Custom Gradient  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .63
Formatting the Chart Walls and Floor of a 3-D Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . .65
Controlling 3-D Rotation in a 3-D Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66
Forecasting with Trendlines  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68
Adding Drop Lines to a Line or Area Chart  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .71
Adding Up/Down Bars to a Line Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .72
Showing Acceptable Tolerances by Using Error Bars  . . . . . . . . . . . . . . . . . . . . . . . . . . .72
Formatting a Series . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .73
Formatting a Single Data Point  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .74
Using the Format Ribbon  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .74
Converting Text to WordArt  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .74
Using the Shape Styles Gallery  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .74
Using the Shape Fill and Shape Effects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .75
Using Preset Shape Effects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .76
Replacing Data Markers with Clip Art or Shapes  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77
Using Clip Art as a Data Marker  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77
Using a Shape in Place of a Data Marker . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .78
Creating a Chart Template  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .79
Next Steps  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .79
3 Creating Charts That Show Trends  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .81
Choosing a Chart Type  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .81
Understanding a Date-Based Axis Versus a Category-Based Axis  . . . . . . . . . . . . . . . . . . . .84
Accurately Representing Data Using a Time-Based Axis . . . . . . . . . . . . . . . . . . . . . . . . .84
Converting Text Dates to Dates  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86
Comparing Date Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .88
Dates Not Recognized as Dates: Numeric Years  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .92
Dates Not Recognized as Dates: Dates Before 1900  . . . . . . . . . . . . . . . . . . . . . . . . . . . .93
Charts and Graphs for Microsoft Office Excel 2007
iv

剩余476页未读，继续阅读

评论收藏

内容反馈

Que.Charts.and.Graphs.for.Microsoft.Office

评论0

最新资源

Que.Charts.and.Graphs.for.Microsoft.Office

评论0

最新资源

相关推荐

WPFVisifire.Charts.dll v5.1.7去水印版.rar

WPFVisifire.Charts全版本dll集合

WPF Visifire.Charts的柱状图、折线图、饼图等等实现

WPFVisifire.Charts,柱状图,饼图,曲线图,区域图

Visifire.Charts3.6.1源码

Visifire.Charts4.5.6源码

WPFVisifire.Charts 全部图表例子

DynamicDataDisplay.dll和WPFVisifire.Charts.dll程序集

Visifire Charts 图表 无水印 破解 WPF

WPFVisifire.Charts5 demo

SLWpVisifire.Charts

曲线图示例下载(Visifire.Charts)

Good.Charts.1633690709.epub

EXCEL.2007.CHARTS.MADE.EASY

SLVisifire.Charts 3.0免费开源版

TMS.Advanced.Charts.v3.5.2.2.7z

Visifire.Charts4.6.1报表控件最新源码 包含Demo

Apress.Beginning.JavaScript.Charts.Dec.2013

Visual.Studio.Tools.for.Office.Using.C.Sharp.with.Excel.Word.Outlook.and.InfoPath.Sep.2005

Vector Davinci官方帮助配置使用手册（AutoSAR）.pdf

c++入门，核心，提高讲义笔记

数字图像处理 冈萨雷斯 课后习题

离散数学及其应用 第八版 奇数编号练习答案.pdf

科研伦理与学术规范 期末考试2 （40题）.pdf

最值得收藏的 考研线性代数 全部知识点思维导图整理(张宇, 汤家凤), 附带惯用思维/做题技巧/易错点整理.emmx

软件著作权设计说明书模板（含填写说明）.docx

AUTOSAR培训教材.rar

菜菜sklearn课程讲义.rar

“互联网+”大学生创新创业大赛项目计划书

Visifire Charts 图表无水印破解 WPF

Visifire.Charts4.6.1报表控件最新源码包含Demo

数字图像处理冈萨雷斯课后习题

离散数学及其应用第八版奇数编号练习答案.pdf

科研伦理与学术规范期末考试2 （40题）.pdf

最值得收藏的考研线性代数全部知识点思维导图整理(张宇, 汤家凤), 附带惯用思维/做题技巧/易错点整理.emmx