Adding x axis labels

  • Thread starter Thread starter Happy
  • Start date Start date
H

Happy

A very basic question: how do you add, or select X axis titles? (Excel 101!
but I can't make it work)
 
Select the chart, then from the main menu Chart|Chart Options. The
first table has title fields for the chart and each axis.

Jerry
 
I obviously gave the wrong info for what I needed-- how do you add, or
include, not the titles, but the actual tags, or legends ,or whatever they
are called, just below the chart, that make up the X axis? ie. if the X axis
is called "Years 1996-2004", how do you insert the individual years for the
chart points, below the chart?
 
Happy -

They're called axis labels.

You didn't mention the chart type.

For a Line chart type (and other chart types where the x axis is a category
axis), choose Chart | Source Data | Series | Category (X) axis labels, and
select the worksheet range containing the labels.

For an XY (Scatter) chart type (where the x axis is a value axis), choose
Chart | Source Data | Series | X Values, and select the worksheet range
containing the values.

- Mike
www.mikemiddleton.com

+++++++++++++++++++++++++

I obviously gave the wrong info for what I needed-- how do you add, or
include, not the titles, but the actual tags, or legends ,or whatever they
are called, just below the chart, that make up the X axis? ie. if the X axis
is called "Years 1996-2004", how do you insert the individual years for the
chart points, below the chart?

+++++++++++++++++++++++++

Select the chart, then from the main menu Chart|Chart Options. The first
table has title fields for the chart and each axis.
Jerry

+++++++++++++++++++++++++

Happy wrote:
A very basic question: how do you add, or select X axis titles? (Excel 101!
but I can't make it work)
 
Thank you!! Sorry to bother you with that. Can you recommend a website /
book / spot where I can get a little more familiar with Excel, so I don't
have to ask simple questions?
 
Back
Top