Change axis labels in a chart

How to Change Axis Labels in a Chart (Excel, Google Sheets, Python, and More)

You can customize X-axis and Y-axis labels in charts for better readability. Here’s how to do it in different tools:

1. Microsoft Excel

For Most Charts (Bar, Line, Column, etc.)

1. Click on the chart to select it.

2. Right-click the axis (X or Y) you want to edit → Select “Format Axis”.

3. Change the axis title:

   • Under Axis Options, edit:

     • Axis Title → Click the text box and type a new label.

     • Axis Labels (e.g., dates, numbers) → Adjust formatting under Number or Labels.

4. Customize text formatting (font, size, color) from the Home tab.

For Histograms & Special Charts

• If Excel auto-generates labels (like bin ranges), adjust them by:

  • Changing the bin width (right-click axis → Format Axis → Bin Width).

  • Manually editing the source data to define custom labels.

2. Google Sheets

1. Click on the chart → Chart Editor (⋮ → Edit chart).

2. Customize Axis Labels:

   • Setup Tab → Check if data range includes labels.

   • Customize Tab → Chart & Axis Titles → Edit:

     • Horizontal (X) Axis Title

     • Vertical (Y) Axis Title

3. Change Axis Values (e.g., scaling):

   • Under Customize → Horizontal/Vertical Axis → Adjust min/max values or label font.

3. Python (Matplotlib/Seaborn)

Matplotlib Example

import matplotlib.pyplot as plt

# Sample data
x = [1, 2, 3, 4]
y = [10, 20, 25, 30]

# Plot
plt.plot(x, y)
plt.xlabel(“X-Axis Label”) # Change X-axis label
plt.ylabel(“Y-Axis Label”) # Change Y-axis label
plt.title(“Chart Title”)
plt.show()

Seaborn Example


import seaborn as sns
tips = sns.load_dataset("tips")

# Plot with modified labels
sns.barplot(x=”day”, y=”total_bill”, data=tips)
plt.xlabel(“Day of Week”) # X-axis
plt.ylabel(“Total Bill ($)”) # Y-axis
plt.title(“Average Bill by Day”)
plt.show()

4. PowerPoint/Word (Linked Excel Charts)

1. Right-click the chart → Edit Data (opens Excel).

2. Modify axis labels in the Excel sheet.

3. Refresh the chart in PowerPoint/Word.