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
Select the chart on your page.
Select "Chart" and "Source Data" from the menu to open the "Source Data" dialogue box.
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.
Open the spreadsheet containing the chart you want to modify.
Go to the cells from which the chart's source originates.
Replace the contents of the cells with the label you want to use. View the change reflected on the x axis of your chart.
OpenOffice Calc and Google Spreadsheets
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."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for