PowerPoint Tips Blog

Helping you with presenting, PowerPoint, and speaking

  • Home
  • Blog
  • Tips
  • E-Store
  • Training
  • About
  • Affiliates
  • Advertise
  • Contact
You are here: Home / Design / Charts, tables & diagrams / Adjust the location of the X (horizontal) chart axis in a PowerPoint chart

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

June 12, 2013 by Ellen Finkelstein 2 Comments

READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

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.

 

powerpoint-tips-adjust-horizontal-axis-in-chart-1And here is the resulting chart on the slide.

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

Unfortunately, the labels for the horizontal chart axis are inside the columns of the chart. This makes them almost impossible to read. Even if I made them white, they wouldn’t look right. This sometimes happens when you have negative values in your chart.

I found 2 ways to fix this problem. Going into these solutions will show you some of the detailed settings available for charts.

powerpoint-tips-adjust-horizontal-axis-in-chart-4Adjust the horizontal axis label position

One way to adjust the labels is to directly work with the horizontal axis. Usually, axis labels are on the axis itself, but you can change that. Follow these steps:

  1. Right-click one of the labels to select the horizontal axis and choose Format Axis.
  2. In PowerPoint 2013, expand the Labels section. and look for the Label Position drop-down list. In earlier versions, look for the Axis Labels drop-down list, as you see at the right.
  3. Choose High from the list. In this case, you want the High option to put the labels above the bars.

You’ll probably also want to increase the size of the text.  To stand out, the text should be pretty  large. Right-click one of the labels of the axis and choose Font. In the Font dialog box, select the current font in the Size box. Type a new value and press Enter or click OK.

Here’s the resulting slide after increasing the font size of both axes and removing some irrelevant junk.

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

Adjust where the horizontal axis crosses the vertical (Y) axis

You can change the value at which the horizontal axis crosses the vertical axis.  Follow these steps:

  1.  Right-click the vertical axis and choose Format Axis.
  2. Whether in the task pane (PowerPoint 2013) or the dialog box (earlier versions), look for “Horizontal axis crosses.”
  3. In this situation, choose Maximum Axis Value.

Again, the axis labels appear above the columns.

What controls do you use to fine-tune your PowerPoint charts?

Share6
Tweet
Share2
+12
Shares 10
READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Related posts:

  1. Moving the axis labels when a PowerPoint chart/graph has both positive and negative values
  2. Changing the order of items in a chart
  3. Adjust font spacing — both vertical and horizontal
  4. Create a PowerPoint chart/graph with 2 Y-axes and 2 chart types

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

2
Leave a Reply

avatar
This comment form is under antispam protection
2 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
1 Comment authors
googleplay Recent comment authors
avatar
This comment form is under antispam protection
  Subscribe  
newest oldest most voted
Notify of
googleplay
Guest
googleplay

Thanks a lot

Vote Up0Vote Down 
5 years ago
trackback
ᐉ Déplacer L'axe Y Vers La Gauche Dans Microsoft Excel Graph (Diagram Scatter) ≫ Excel | UDIL

[…] Voulez-vous déplacer l’axe vertical « Y »/ vers la gauche pour qu’il ne soit plus au centre du graphique ? Cet article vous explique comment : https://www.ellenfinkelstein.com/pptblog/adjust … […]

Vote Up0Vote Down 
11 months ago
wpdiscuz   wpDiscuz

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
4-up-ads PresenterMedia PoweredTemplate High-Persuasion Secrets Power Pointers Quarter Hour


Recent Posts

Recent Posts

  • Creating and using a strong call-to-action slide
  • 3 ways to use images
  • Interview with Barry Shore on the Joy of Living
  • Use icons to create a list
  • 3 techniques for putting less text on your slides

Connect with me!

Connect with me! Twitter LinkedIn Facebook

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

Privacy, Refund, and Other Legal Stuff

wpDiscuz