Restoring Horizontal Axis Labels

A

Art

I have a simple two-series line chart. At first I thought the horizontal axis
labels just added unneccesary clutter. So I chose 'none' in one of the
formatting dialogs, and they disappeared. Now I want to restore them. But I
cannot 'select' the horizontal axis. When I click on it the entire plot area
is selected.

What are the exact steps to edit the horizontal axis formatting?
 
S

Shane Devenshire

Hi,

With the chart selected and the Chart toolbar displayed, open the Chart
Object drop down and choose Category Axis, then choose the command Format,
Selected Axis, ... (this turns the display of the categorys)

If the entire axis is gone, not just the values, then with the chart
selected choose Chart, Chart Options, Axes tab, and check Category (X) axis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
change chart primary horizontal axis label or name 1
Pivot Chart with 2 horizontal axis field (categories) 1
Axis labels wrap until print/print preview 3
Horizontal Axis Options Changing 6
Finding second data point on primary axis of two axis chart 1
Text-wrapping horizontal axis labels 4
Offset Horizontal axis data 1

Top