Format Axis Alignment

K

Kenyon_M

I'm using office 2007 and in the vertical (category) axis I need to see a
persons full name ie. Joe Smith. Right now it's only showing the first name
because it's in the first column. If I expand the chart and make it huge it
shows the first and last name. I know one way to fix the problem is to use
the CONCATENATE function to put both first and last together into one cell
but there are thousands of entries I have like this. On the Format Axis
Option in the Alignment section is there a way to modify the Autofit or
Internal margin? right now it's grayed out.
 
S

ShaneDevenshire

Hi M,

Where are you getting the first and last names from? two columns of cells?
Suppose that the first names are in A1:A1000 and the last names in B1:B1000,
then in C1 enter the formula =A1&" "&B1. Then drag the fill handle down to
copy the formula. Use colum C in your chart.
 
K

Kenyon_M

Thank you for your help. That function will also help, but I was wondering
is there a way to extend the vertical axis using the auto fit or Internal
Margin that is grayed out. If so how? Also, is there a reason that the
Autofit and Internal margin are grayed out in the Alignment segment of Format
Axis?

Your help is greatly appreciated,
Kenyon_M
 
S

ShaneDevenshire

Hi Kenyon,

The dialog box is a general one, many of the options do not apply to the
chart or a portion of the chart such as the category axis labels. Some of
these options apply to text boxes, where there are interal margins and
autofit make sense.
 

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