Teach Yourself MS Office 2003 In 24 Hours Free Open Book

Teach Yourself MS Office 2003 In 24 Hours

Previous Section Next Section

Q&A

Q1:

Can I add a picture as a background inside the chart's data area itself?

A1:

You can easily add a background to your chart. Whereas Figure 10.9 shows a picture that appears behind the chart's normal gray charting area (called the fill area), you can override this background and place a picture behind the actual data lines, bars, and points themselves. To do so, right-click over the fill area's background and select Format Plot Area. Next, select Fill Effects and place the picture just as you did in the final section of this hour.

Q2:

Why would I want an instant graph from the F11 keypress if none of the labels are accurate and if I cannot determine the graph type ahead of time?

A2:

Excel's instant charting feature certainly does not produce final, presentation-ready charts, but that's not the point. When you have data to analyze and you need a quick look at the data, select the data in a range and press F11 (or Alt+F1) to see whether Excel's default Column chart fits the nature of the data. If you want a fancier graph, use the Chart Wizard and specify all the details of the chart. The instant charting feature is available, however, for an initial look at a picture of your data.

    Previous Section Next Section
    Index: [SYMBOL][A][B][C][D][E][F][G][H][I][J][L][M][N][O][P][Q][R][S][T][U][V][W][X][Z]


         Main Menu
    Main Page
    Table of content
    Copyright
    About the Author
    Acknowledgments
    We Want to Hear from You!
    Introduction
    Part I: Working with Office 2003
    Part II: Processing with Word 2003
    Part III: Computing with Excel 2003
    Hour 6. Understanding Excel 2003 Workbooks
    Hour 7. Restructuring and Editing Excel 2003 Worksheets
    Hour 8. Using Excel 2003
    Hour 9. Formatting Worksheets to Look Great
    Hour 10. Charting with Excel 2003
    Creating Custom Graphs
    A Quick Chart
    Making Your Chart Fancy
    Summary
    Q&A
    Part IV: Presenting with Flair
    Part V: Organizing with Outlook 2003
    Part VI: Tracking with Access 2003
    Part VII: Combining Office 2003 and the Internet
    Part VIII: Publishing Eye-Catching Documents
    Part IX: Appendixes
    Part X: Bonus Hours
    Index


    More Books
    PHP Hacks
    Processing Xml With Java - A Guide To Sax, Dom, Jdom, Jaxp, And Trax
    The Koran (Holy Qur'an)
    Macromedia Flash 8 Bible
    Search Engine Optimization for Dummies
    YouTube Traffic
    PHP 5 for Dummies
    Harry Potter and The Chamber of Secrets
    Harry Potter and the Sorcerer's Stone
    The Pilgrim's Progress
    Wireless Hacks
    Flash Hacks. 100 Industrial-Strength Tips & Tools
    PayPal Hacks. 100 Industrial-Strength Tips and Tools
    Amazon Hacks
    Pdf Hacks
    The Da Vinci Code
    Google Hacks
    The Holy Bible
    Windows XP For Dummies
    Harry Potter and the Half-Blood Prince
    Seo Book
    Upgrading and Repairing Networks
    Macromedia Dreamweaver 8 UNLEASHED
    Windows XP Annoyances
    Windows XP Hacks
    Microsoft Windows XP Power Toolkit
    Teach Yourself MS Office In 24Hours
    iPod & iTunes Missing Manual
    PC Hacks 100 Industrial-Strength Tips and Tools
    PC Overclocking, Optimization, and Tuning - 2th Edition
    PC Hardware In A Nutshell 3rd Edition
    PC Hardware in a Nutshell, 2nd Edition
    Upgrading and Repairing PCs
    Google for Dummies
    MySQL Cookbook
    Teach Yourself Macromedia Flash 8 In 24 Hours
    PHP CookBook
    Sams Teach Yourself JavaScript in 24 Hours
    PHP5 Manual
    Free Games Paper Airplanes
    500 Juegos Gratis 500 Giochi Gratis 500 Jeux Gratuits 500 Jogos Gratis 500 Kostenlose Spiele