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.