Charting Problem in Excel 2010

B

Bill

I have created a new file with attached line chart but I cannot seem
to navigate to the proper screen where you add the vertical axis label
AND chart title.

Bill
 
D

Don Guillett

I have created a new file with attached line chart but I cannot seem
to navigate to the proper screen where you add the vertical axis label
AND chart title.

Bill
Add axis titles manually
1.Click anywhere in the chart to which you want to add axis titles.

This displays the Chart Tools, adding the Design, Layout, and Format
tabs.
2.On the Layout tab, in the Labels group, click Axis Titles.


3.Do any of the following:
To add a title to a primary horizontal (category) axis, click Primary
Horizontal Axis Title, and then click the option that you want.

Tip If the chart has a secondary horizontal axis, you can also
click Secondary Horizontal Axis Title.
To add a title to primary vertical (value) axis, click Primary
Vertical Axis Title or Secondary Vertical Axis Title, and then click
the option that you want.

Tip If the chart has a secondary vertical axis, you can also click
Secondary Vertical Axis Title.
To add a title to a depth (series) axis, click Depth Axis Title, and
then click the option that you want.

Note This option is only available when the selected chart is a
true 3-D chart, such as a 3-D column chart.
4.In the Axis Title text box that appears in the chart, type the text
that you want.

Tip To start a new line, press ENTER. To insert a line break, click
to place the cursor where you want to break the line, and then press
ENTER.
5.To format the text in the title box, do the following:
1.Click in the title box, and then select the text that you want to
format.
2.On the Mini toolbar, click the formatting options that you want.

Tip You can also use the formatting buttons on the ribbon (Home
tab, Font group. To format the whole title, you can right-click it,
click Format Axis Title, and then select the formatting options that
you want.

Notes
If you switch to another chart type that does not support axis titles
(such as a pie chart), the axis titles will no longer be displayed.
The titles will be displayed again when you switch back to a chart
type that does support axis titles.
Axis titles that are displayed for secondary axes will be lost when
you switch to a chart type that does not display secondary axes.
 
B

Bill

Don,

I managed to get the axis labels but only by using the Text Box and
then moving it to the desired location. I just missed the #2! I knew
it had to be there somewhere; I just missed it! Thanks!

Bill
 
D

Don Guillett

Don,

I managed to get the axis labels but only by using the Text Box and
then moving it to the desired location. I just missed the #2! I knew
it had to be there somewhere; I just missed it! Thanks!

Bill

Glad to help
 

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

Top