PowerPoint Tips Blog

Helping you with presenting, PowerPoint, and speaking

  • Home
  • Blog
  • Tips
  • E-Store
  • Training
  • About
  • Affiliates
  • Advertise
  • Contact
Home » chart axis

Moving the axis labels when a PowerPoint chart/graph has both positive and negative values

July 14, 2014 by Ellen Finkelstein 4 Comments

powerpoint-tips-chart-axis-label-placement-1

For her PhD dissertation, my friend, Leslee Goldstein, did research teaching the Transcendental Meditation technique to Ugandan women who were part of an NGO (non-governmental organization) program that taught them skills to help them support themselves, such as sewing.  These women had been subjected to a huge amount of stress in their lives and this stress made progress difficult.

She did 3 pre- and post-tests that are commonly used in this situation and got great results. But when she created the chart in PowerPoint, she had a problem.

powerpoint-tips-chart-axis-label-placement-1

As you can see, by default PowerPoint puts the horizontal axis labels near the axis. Usually, this works, but when you have a combination of positive and negative numbers, the bars interfere with the labels. While the results for the Self-Efficacy Scale and Medical Outcomes Survey increased, the Perceived Stress Scale numbers decreased.

Here’s how to fix this problem:

  1. Select the chart.
  2. Right-click the horizontal axis text and choose Format Axis.
  3. In PowerPoint 2013: In the taskpane on the right, click the arrow next to Labels to expand that section.
  4. In PowerPoint 2007, 2010 and 2013: Click the Label Position or Axis Labels drop-down list and choose High. (Another option that works in some situations is Low.)

Here’s the result.

powerpoint-tips-chart-axis-label-placement-2

Much better, right?

3 orange large asterisks

Do you have frustrations getting charts to look right in PowerPoint? Leave a comment!

Filed Under: Charts, tables & diagrams Tagged With: axis labels, chart axis

Adjust the location of the X (horizontal) chart axis in a PowerPoint chart

June 12, 2013 by Ellen Finkelstein 1 Comment

powerpoint-tips-adjust-horizontal-axis-in-chart-1

Sometimes, you need to fine-tune charts, because they just don’t look right. One situation I saw recently was the horizontal chart axis not appearing in the right location. I needed to create a chart from this data for a client:

Systolic blood pressure -4.5
Diastolic blood pressure -3.2

Here’s what the datasheet looks like. (Did you know that PowerPoint 2013 brought back the datasheet from PowerPoint 2003?) The data starts in cell A2 because it doesn’t have any header labels. [Read more…]

Filed Under: Charts, tables & diagrams Tagged With: axes, axis, chart axis, charts, labels

Free Video Training!

13 Techniques that Will Make Designing Your Slides EASY!

And get the PowerPoint Tips Newsletter with tips and resources for presenters. Plus 5 bonus tips!

BirdSend Email Marketing Tool

PresenterMedia

1-on-1 Presentation Coaching

Recent Posts

Recent Posts:

Recent Posts

  • New SmartArt layouts, including numbered lists and Meet the Team options
  • New Remove Background options in PowerPoint
  • Managing complex backgrounds
  • Creating images with AI: The end of stock photo sites?
  • Format multiple headshots for consistency

Connect with me!

Connect with me on LinkedIn!


Search the site:

Search the site:

Ellen Finkelstein, Inc. · Fairfield, IA · Tel: 515-989-1832

Privacy, Refund, and Other Legal Stuff