A very basic question: how do you add, or select X axis titles? (Excel 101!
but I can't make it work)
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
Happy wrote:
> A very basic question: how do you add, or select X axis titles? (Excel 101!
> but I can't make it work)
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?
"Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
news:423EC79D.6030109@no_e-mail.com...
> 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)
>
>
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
+++++++++++++++++++++++++
"Happy" <[email protected]> wrote in message
news:eki%[email protected]...
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?
+++++++++++++++++++++++++
"Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
news:423EC79D.6030109@no_e-mail.com...
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?
"Michael R Middleton" <[email protected]> wrote in message
news:%23Y%[email protected]...
> 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
>
> +++++++++++++++++++++++++
>
> "Happy" <[email protected]> wrote in message
> news:eki%[email protected]...
> 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?
>
> +++++++++++++++++++++++++
>
> "Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
> news:423EC79D.6030109@no_e-mail.com...
> 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)
>
>
>
Happy,
You can get a list of Excel based websites here:
http://www.pdbook.com/index.php/excel/sites/
John Walkenbach's site has an extensive list of Excel web site references.
Here are some excellent sites that focus on charting in Excel:
http://www.andypope.info/
http://www.peltiertech.com/
http://www.tushar-mehta.com/
----
Regards,
John Mansfield
http://www.pdbook.com
"Happy" wrote:
> 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?
> "Michael R Middleton" <[email protected]> wrote in message
> news:%23Y%[email protected]...
> > 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
> >
> > +++++++++++++++++++++++++
> >
> > "Happy" <[email protected]> wrote in message
> > news:eki%[email protected]...
> > 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?
> >
> > +++++++++++++++++++++++++
> >
> > "Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
> > news:423EC79D.6030109@no_e-mail.com...
> > 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)
> >
> >
> >
>
>
>
>
I appreciate it!
"John Mansfield" <[email protected]> wrote in message
news:[email protected]...
> Happy,
>
> You can get a list of Excel based websites here:
>
> http://www.pdbook.com/index.php/excel/sites/
>
> John Walkenbach's site has an extensive list of Excel web site references.
>
> Here are some excellent sites that focus on charting in Excel:
>
> http://www.andypope.info/
>
> http://www.peltiertech.com/
>
> http://www.tushar-mehta.com/
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
>
> "Happy" wrote:
>
>> 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?
>> "Michael R Middleton" <[email protected]> wrote in message
>> news:%23Y%[email protected]...
>> > 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
>> >
>> > +++++++++++++++++++++++++
>> >
>> > "Happy" <[email protected]> wrote in message
>> > news:eki%[email protected]...
>> > 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?
>> >
>> > +++++++++++++++++++++++++
>> >
>> > "Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
>> > news:423EC79D.6030109@no_e-mail.com...
>> > 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)
>> >
>> >
>> >
>>
>>
>>
>>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks