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 1 Comment

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?

Did you find this post useful? Get my free video training, "13 techniques that will make designing your slides EASY." 
Need training? Click here to find out about training to bring your presentations to the next level!

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

1
Leave a Reply

avatar
This comment form is under antispam protection
1 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 
4 years 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

  • Using PowerPoint’s new illustrations
  • Communication skills for online success
  • PowerPoint has photos again! And a lot more…
  • Equipment for Speakers
  • Collaborate with others in real time using PowerPoint on the Web

Connect with me!

Twitter LinkedIn Facebook Google Plus RSS feed

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

Privacy, Refund, and Other Legal Stuff

wpDiscuz