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

"ShaneDevenshire" wrote:

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.
--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Kenyon_M" wrote:

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.