Skip to Content
Fixing PowerPoint Annoyances
book

Fixing PowerPoint Annoyances

by Echo Swinford
February 2006
Intermediate to advanced
326 pages
9h 16m
English
O'Reilly Media, Inc.
Content preview from Fixing PowerPoint Annoyances

Chapter 6. Charts and Graphs

If you use PowerPoint for any length of time, sooner or later you’ll come face to face with Microsoft Graph, PowerPoint’s charting engine. Microsoft Graph is a scaled-down subset of Excel that charts based on data in a datasheet. Graph does not do calculations, nor can it handle formulas. It just charts the data as is. If you need something more robust, you can always create your charts in Excel and import those charts into your presentation.

This chapter tackles some of the more annoying issues you may run into when working with charts in PowerPoint, whether they’re created in Microsoft Graph or Excel. We’ll deal with some of the bizarre text and formatting issues Microsoft’s graphing programs bring your way. You’ll also learn how to resize your charts without distorting the fonts, create user-defined charts, and solve other tricky issues.

TEXT ISSUES

Y-Axis Titles Truncated

THE ANNOYANCE: The last letter of my Y-axis title text is cut off. I tried making the font smaller, but it didn’t help. How can I make PowerPoint show the whole title?

THE FIX: Unfortunately, you can’t resize the Y-axis title box on the chart. You can, however, replace the Y-axis title with a regular text box.

You can also try adding two spaces followed by a period to the Y-axis title box to extend it. Format the period as the background color so it won’t print.

This is a sporadic issue possibly related to video drivers and display settings. The truncated Y-axis title on the chart will ...

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.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

How to Develop a Great Digital Strategy

How to Develop a Great Digital Strategy

Jeanne W. Ross, Cynthia M. Beath, Ina M. Sebastian
The Hidden Cost of AI-Assisted Creativity

The Hidden Cost of AI-Assisted Creativity

Léonard Boussioux, Anil Doshi, Oliver Hauser, Kartik Hosanagar

Publisher Resources

ISBN: 0596100043Errata Page