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



  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

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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