How to Change X Axis Labels

Written by foye robinson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Change X Axis Labels
(Jupiterimages/BananaStock/Getty Images)

The X axis represents the horizontal values on a chart. You can use a spreadsheet application, such as Microsoft Excel, Open Office Calc or Google Spreadsheets to generate and modify a chart and its labels. By default, Excel and Open Office Calc use the categories from the table as X axis labels when the labels feature is enabled. So if your chart includes the categories, "Total Owed" and "Total Paid," the labels on the X axis should reflect those categories.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

    Excel

  1. 1

    Select the chart on your page.

  2. 2

    Select "Chart" and "Source Data" from the menu to open the "Source Data" dialogue box.

  3. 3

    Go to the "Category (X) axis labels" text field and type the labels you want to include. Separate each with a comma, as follows: label 1,label 2,label 3 and so forth.

    OpenOffice Calc and Google Spreadsheets

  1. 1

    Open the spreadsheet containing the chart you want to modify.

  2. 2

    Go to the cells from which the chart's source originates.

  3. 3

    Replace the contents of the cells with the label you want to use. View the change reflected on the x axis of your chart.

Tips and warnings

  • According to Microsoft Office, "If you type the label text in the Category axis labels box, the category axis text is no longer linked to a worksheet cell."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.