Skip to Content
Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
book

Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007

by Bill Jelen
April 2007
Beginner to intermediate content levelBeginner to intermediate
480 pages
17h 6m
English
Que
Content preview from Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
19
Working with Charts
1
CASE STUDY
Locating a Chart at the Top of Your Dataset
It is easy to build a dataset so you can work along with this case study. Follow these steps to build the dataset.
1. Start a blank worksheet.
2. Type 1 in cell A2.
3. With cell A2 selected,choose Home,Fill,Series….
4. Choose Series in Columns.Enter a Stop Value of 3000.Choose OK to fill in the
numbers from 1 to 3000 in column A.
5. Enter the label Result in B1.Enter the number 10 in B2.In B3,enter the formula
=B2+RANDBETWEEN(-2,2).
6. Select cell B3. Double-click the fill handle to copy the formula down to B3001.
The goal of this case study is to create a chart of the results ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007 Inside Out

Microsoft® Office Excel® 2007 Inside Out

Mark Dodge, Craig Stinson
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
How to Become a Game-Changing Leader

How to Become a Game-Changing Leader

Douglas A. Ready, Alan Mulally

Publisher Resources

ISBN: 0789736101Purchase book